Oracle7 Server Tuning

• Oracle7(tm) Server Tuning

• Preface
  • Reading Guide to the Oracle7 Server Library
  • Audience
  • How Oracle7 Server Tuning is Organized
  • Conventions Used in this Manual
  • Your Comments Are Welcome

• Overview of Tuning

• Overview of Tuning
  • Who Tunes?
  • When Do You Tune?
  • Goals for Tuning
  • Tuning While Designing and Developing a System
  • Tuning a Production System
  • Monitoring Facilities for Production Systems

• Effective Application Design
  • Types of Applications
  • Oracle Configurations
  • Client/Server Considerations

• Tuning Applications

• Registering Applications
  • Overview
  • Registering Applications
  • Setting the Module Name
  • Setting the Action Name
  • Setting the Client Information
  • Retrieving Application Information

• SQL Processing
  • SQL Statement Execution
  • DML Statement Processing
  • DDL Statement Processing
  • Controlling Transactions
  • Discrete Transactions
  • Shared SQL and PL/SQL
  • The Optimizer
  • Parallel Query Option

• The Optimizer: Overview
  • What is Optimization?
  • How Oracle Optimizes SQL Statements

• Parallel Query Option
  • Parallel Query Processing
  • Parallelizing SQL Statements
  • Setting the Degree of Parallelism
  • Managing the Query Servers
  • Tuning for the Parallel Query Option
  • Parallel Index Creation

• Tuning SQL Statements
  • How to Write New SQL Statements
  • How to Tune Existing SQL Statements

• Tuning the Instance

• Tuning Memory Allocation
  • The Importance of Memory Allocation
  • Steps for Tuning Memory Allocation
  • Tuning Your Operating System
  • Tuning Private SQL and PL/SQL Areas
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Reallocating Memory

• Tuning I/O
  • The Importance of Tuning I/O
  • Reducing Disk Contention
  • Allocating Space in Data Blocks
  • Avoiding Dynamic Space Management

• Tuning Contention
  • Reducing Contention for Rollback Segments
  • Reducing Contention for Multi-Threaded Server Processes
  • Reducing Contention for Query Servers
  • Reducing Contention for Redo Log Buffer Latches
  • Assigning All Oracle Processes Equal Priority

• Additional Tuning Considerations
  • Tuning Sorts
  • Reducing Free List Contention
  • Tuning Checkpoints

• Reference

• Performance Diagnostic Tools
  • The SQL Trace Facility
  • The EXPLAIN PLAN Command

• Statistc Descriptions
  • Statistic Descriptions

• Operating System-Specific Information
  • Topics

Copyright