Back to Search Results

Training Course Summary:

This 3 day practical course is for individuals with responsibility for monitoring, maintaining and improving the performance of an Oracle database. It will be extremely useful for anyone intending to take the Oracle Certified Professional DBA Exams.

Pre-Requisites:

This course assumes Database Administrator training or relevant experience. Knowledge of basic PL/SQL is assumed.

Training Course Overview/Content:

Performance Tuning : The goals and tools§ The Development Stage§ The Tuning Process§ Measuring the Results
Oracle Files § Review of the alert log§ Review of Oracle trace filesOracle Data Dictionary§ Oracle dynamic performance views in detail§ Detecting and resolving locks§ Detecting and reducing various waits§ Oracle pre-supplied dictionary tools Buffer Cache Tuning § Using the Oracle 8i keep and recycle pools to advantage§ Monitoring & improving the hit ratio§ Optimum sizing of the buffer pools§ Hidden initialisation parameters Shared Pool Tuning § Generating Data Dictionary cache statistics§ Interpreting and improving the statistics§ The shared pool and Multithreaded Server§ Library cache statistics§ Shared SQL area Redo Logs § Online redo logs – size, number, placement and status§ Log switches§ Sizing the redo log buffer§ Performance issues with latches