Home > Training > Peformance Tuning > Page 2

Oracle8i Performance Tuning

Course Topics Contd... Page2

Tuning the Redo Log Buffer
Determining if processes are waiting for space in the redo log buffer
Sizing the redo log buffer appropriately
Reducing redo operations
Identifying performance issues associated with the redo buffer latches

Database Configuration and I/O Issues
Diagnosing inappropriate use of SYSTEM, RBS, TEMP, DATA and INDEX tablespaces
Detecting I/O problems
Ensuring that files are distributed to minimize I/O contention
Using striping where appropriate
Tuning checkpoints
Tuning background process I/O

Using Oracle Blocks Efficiently
Determining an appropriate block size
Optimizing space usage within blocks
Detecting and resolving row migration
Monitoring and tuning indexes
Appropriately sizing extents

Optimizing Sort Operations
Identifying the SQL operations that require sorts
Ensuring that sorting is done in memory where possible
Allocating temporary space appropriately

Rollback Segment Tuning
Using the dynamic performance views to check rollback segment performance
Reconfiguring and monitoring rollback segments
Defining the number and sizes of rollback segments
Allocating rollback segments to specific transactions

Monitoring and Detecting Lock Contention
Defining the levels of Oracle locking
Listing possible causes of lock contention
Using Oracle utilities to diagnose lock contention
Resolving contention in an emergency
Preventing locking problems
Recognizing Oracle errors arising from deadlocks

SQL Issues and Tuning Considerations for Different Applications
Identifying the role of the DBA in application tuning
Using optimizer modes to enhance SQL statement performance
Managing stored outlines to store execution paths as a series of hints
Using the available data access methods to tune the physical design of the database. Identify the demands of online transaction processing systems (OLTP).
Identify the demands of decision support system.

Managing Mixed Workload
Resource Management Concepts
Steps in Database Resource Management
Dictionary View

Tuning with Oracle Expert
Listing the features of Oracle Expert
Creating a tuning session
Gathering, viewing, and editing the input data
Analyzing the collected data using rules
Reviewing tuning recommendations
Implementing tuning recommendations

Multithreaded Server Tuning Issues (Optional)
Identifying issues associated with managing users in a multithreaded server environment
Diagnosing and resolving performance issues with multithreaded server processes
Configuring the multithreaded server environment to optimize performance

Use a tuning methodology to diagnose and resolve performance tuning issues
Using Oracle tools to diagnose performance problems
Tuning memory structures, file I/O, and contention


Suggested Next Courses:

Oracle8i Network Administration

Back <<