Section Objectives:
List the important steps for outlining a tuning methodology
Reconfigure file structures for performance and other considerations
Configure memory and disk resources to optimize sort operations
Identify and resolve I/O, data storage, and database configuration problems
Configure an Oracle Database with an emphasis on good performance
Utilize Enterprise Manager to perform Tuning tasks
Configure Resource Manager to control resource usage
Perform day-to-day monitoring on an operational database using STATSPACK
Use Oracle tools to diagnose performance problems
Diagnose and resolve performance issues associated with Shared Server
Detect and resolve latch and lock contention problems within the Oracle database environment

Topics:
Overview of Oracle 9i Performance Tuning
Job Roles in Tuning
Tuning phases
Tuning goals and Service Level Agreements
Common performance problems
Tuning Methodology

Diagnostic and Tuning Tools
Alert log file
Background process trace files
User trace files
Dictionary views providing statistics
Dynamic performance views
TIMED_STATISTICS parameter to collect statistics
Statistics Package
UTLBSTAT/UTLESTAT Utilities

Previous page << pg1 pg2 pg3 pg4 pg5 pg6 pg7 pg8 PAGE9 pg10 pg11 pg12 pg13 Next page >>