"Exam 1Z0-033"--Cover. [1].

Includes index.

Introduction to Performance Tuning -- The Oracle Tuning Methodology -- Tuning Development Systems -- Tuning Production Systems -- Goal-Oriented Tuning -- Establishing a Benchmark -- Setting Performance Goals -- General Tuning Concepts -- Understanding Trade-offs -- Common Tuning Problem Areas -- Two Tuning Guidelines -- Tuning Lifecycles -- Review of the Oracle Architecture -- The Oracle Instance -- The Oracle Database -- Sources of Tuning Information -- The Alert Log -- Background, Event, and User Trace Files -- Background Process Trace Files -- Event Trace Files -- User Trace Files -- Managing Trace Files -- Performance Tuning Views -- V Views Commonly Used in Performance Tuning -- DBA Views Commonly Used in Performance Tuning -- Sample Queries on Views -- Oracle-Supplied Tuning Utilities -- UTLBSTAT.SQL and UTLESTAT.SQL -- STATSPACK -- Graphical Performance Tuning Tools -- Oracle Enterprise Manager Console -- Oracle Diagnostics Pack -- Oracle Tuning Pack -- SQL Application Tuning and Design -- Measuring SQL Performance -- The TKPROF Utility -- The Explain Plan Facility -- The AUTOTRACE Utility -- SQL Tuning Information in STATSPACK Output -- Understanding the Oracle Optimizer -- Rule-Based Optimization -- Cost-Based Optimization -- Setting the Optimizer Mode -- Optimizer Mode: Instance Level -- Optimizer Mode: Session Level -- Optimizer Mode: Statement Level -- Optimizer Precedence Rules -- Improving Application Performance -- Improving Execution Paths -- Minimizing I/O Using Indexes and Clusters -- OLTP vs. DSS Tuning Requirements -- Tuning OLTP Systems -- Tuning DSS Systems -- Tuning Hybrid Systems: OLTP and DSS -- Tuning the Shared Pool -- Understanding the Shared Pool -- The Benefits of Statement Caching -- Components of the Shared Pool -- Measuring the Performance of the Shared Pool -- Measuring Library Cache Performance -- Measuring Data Dictionary Cache Performance -- Improving Shared Pool Performance -- Make It Bigger -- Make Room for Large PL/SQL Statements -- Keep Important PL/SQL Code in Memory -- Encourage Code Reuse -- Tune Library Cache-specific init.ora Parameters -- Tuning the Database Buffer Cache -- Understanding the Database Buffer Cache -- The LRU List -- User Server Process -- Database Writer -- Measuring the Performance of the Database Buffer Cache -- Monitoring the Buffer Cache Using VSYSSTAT -- Monitoring the Buffer Cache Using STATSPACK -- Using REPORT.TXT Output -- Non-Hit Ratio Performance Measures -- Using OEM to Monitor Buffer Cache Performance -- Improving Buffer Cache Performance -- Make It Bigger -- Use Multiple Buffer Pools -- Cache Tables in Memory -- Bypass Buffer Cache -- Use Indexes Appropriately -- Tuning Other SGA Areas -- Shared Server Architecture -- Configuring Shared Servers -- Measuring Shared Server Performance -- Improving Shared Server Performance -- Large Pool Concepts -- Configuring the Large Pool -- Measuring the Performance of the Large Pool -- Improving the Performance of the Large Pool -- Java Pool Concepts -- Configuring the Oracle Java Environment -- Measuring the Performance of the Java Pool -- Improving the Performance of the Java Pool -- Tuning Redo Mechanisms -- Understanding Oracle's Redo Mechanisms -- Tuning the Redo Log Buffer -- Measuring the Performance of the Redo Log Buffer -- Improving Redo Log Buffer Performance -- Tuning Checkpoints -- Measuring the Performance of Checkpoints -- Improving Checkpoint Performance -- Tuning Online Redo Log Files -- Measuring the Performance of Redo Logs -- Improving Redo Log Performance -- Tuning Archiving Operations -- Measuring the Performance of Archiving -- Improving the Performance of Archiving -- Tuning Disk I/O -- Tuning Tablespace and Datafile I/O -- Measuring Datafile I/O -- Improving Datafile I/O -- Tuning DBW0 Performance -- Measuring DBW0 I/O -- Improving DBW0 I/O -- Tuning Segment I/O -- Understanding Oracle Blocks and Extents -- Improving Segment I/O -- Tuning Sort I/O -- Measuring Sort I/O -- Improving Sort I/O -- Tuning Rollback Segment I/O -- Understanding Rollback Segments -- Measuring Rollback Segment I/O -- Improving Rollback Segment I/O -- Tuning Contention -- Latch Contention -- Measuring Latch Contention -- Tuning Latch Contention -- Free List Contention -- Measuring Free List Contention -- Tuning Free List Contention -- Lock Contention -- Measuring Lock Contention -- Tuning Lock Contention -- Operating System Tuning -- Understanding Server Resources -- Understanding and Tuning Server Memory -- Understanding and Tuning Server CPUs -- Understanding and Tuning Processes and Threads -- Understanding Resource Manager -- Resource Manager Resources -- Configuring Resource Management -- Monitoring Resource Manager.

This book has all the features of Sybex's bestselling study guides including self-assessment tests, key-terms sections, review questions, practice exams, plus new real-world scenario sidebars.