Oracle Performance TuningThe books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now. Performance tuning is crucial in any modern relational database management system. Too many organizations respond to Oracle performance problems by throwing money at these problems -- by buying larger and more expensive computers or by hiring expert consultants. But there's a lot you can do on your own to increase dramatically the performance of your existing system. Whatever version of Oracle you're running -- from Version 6 to Oracle8, proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades. The first edition of Oracle Performance Tuning became a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition contains 400 pages of updated material updating on Oracle features, incorporating advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPS, SMPs, and other architectures. It also includes chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more. |
Contents
I | 1 |
Introduction to Oracle Performance Tuning | 3 |
What Causes Performance Problems? | 27 |
II | 41 |
Planning and Managing the Tuning Process | 43 |
Defining System Standards | 63 |
III | 81 |
Designing for Performance | 83 |
Tuning Parallel Query | 551 |
Tuning Database Backup and Recovery | 579 |
VI | 647 |
Tuning LongRunning Jobs | 649 |
Tuning in the ClientServer Environment | 683 |
Capacity Planning | 721 |
Tuning for Specific Systems | 745 |
VII | 771 |
IV | 131 |
Tuning SQL | 133 |
Tuning PLSQL | 205 |
Selecting a Locking Strategy | 269 |
V | 297 |
Tuning a New Database | 299 |
Diagnostic and Tuning Tools | 385 |
Monitoring and Tuning an Existing Database | 443 |
Tuning Parallel Server | 521 |
Other editions - View all
Common terms and phrases
allocation allows application batch block bottlenecks buffer cache bytes Chapter clause client client-server column configuration cost-based optimizer create cursors data files database triggers DBWR default DELETE denormalized disk I/O emp_no example execution EXPLAIN PLAN export extents fetch foreign key full table scan functions hardware hit ratio improve INIT.ORA parameter INSERT kilobytes latch load log buffer log files long-running jobs machine megabytes memory monitor NULL objects OLTP operating system Oracle database Oracle Expert Oracle’s package parallel query option parallel server PCM locks performance PL/SQL primary key problems procedures production RDBMS recovery redo log referential integrity response rollback segments script SELECT shared pool sort SORT_AREA_SIZE specify SQL statement SQL*Net SQL*Plus statistics storage stored stored procedures striping sure TABLE TABLE TABLE tables and indexes temporary tablespace tion transaction tuning UNIX update