Oracle 9i Database FastTrack Performance Tuning

Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly 

Class Summary

The Oracle9i Database FastTrack Performance Tuning class offers delegates the opportunity to discuss and examine potential tuning bottlenecks that may impact performance of an Oracle database. The class focuses on the tuning required for a production level database instance and describes memory, disk and process tuning in detail.

Who Should Attend

This class is intended for technical users of the Oracle database system who are responsible for ensuring peak performance in an intensive production environment.

Prerequisites

Experience with the role of an Oracle Database Administrator, including practical expertise in using SQL and PL/SQL.

Content

• Oracle Database Architecture Review: Reviewing disk, memory and process architecture for tuning purposes.
  
  
• Tuning Principles: Priority sequence for best performance, programs, memory, disk, processes, operating systems.
  
  
• Graphical Tuning Tools: Oracle Enterprise Manager modules.
  
  
• Application Tuning Tools: SQL Tuning, utlbstat/estat (8i), statspack (9i), execution plans, affecting plans, query hints, stored outlines.
  
  
• Memory Tuning: Shared pool, buffer pool, log buffer, using the large pool, memory tuning techniques, working with memory and disk buffers.
  
  
• Disk Tuning: Dictionary views, potential bottlenecks, optimising principles, tuning datafiles, tuning archive logs.
  
  
• Process Tuning: What to watch for process tuning, wait states, locks and latches.
  
  
• OS Tuning: Operating system CPU, I/O and memory utilisation.
  
  

Sample notes

To be uploaded shortly ...

Suggested next class

Please contact us for further details of our ad-hoc consultancy and individualised training programmes.