[ Home ] [ IT Training ] [ Careers ] [ About Us ] [ How To reach ] 

Oracle 9i Performance Tuning

Duration:    3 days

Course Contents:

• Brief overview of Oracle architecture
  Components of an Oracle database
  Introduction to performance tuning goals and activities

• Understanding Oracle alerts and trace files
  Interpreting the diagnostic information

• Utilities and dynamic performance views
  Interpreting the system level and session level tuning statistics

• SQL Tuning
  Analysing SQL performance
  Using Explain Plan and SQL*Trace

• Indexing considerations
  Various types of indexes in Oracle
  Using hints
  Tuning the queries for optimal performance

• Tuning the schema
  Using clusters and hash clusters

• Tuning the SGA
  Tuning the data dictionary cache
  Tuning the shared pool area
  Tuning the redo log buffer

• Tuning the I/O contention
  Understanding tablespaces and data files 
  Recommended division of data files across volumes

• Identifying migrated and chained rows
  Eliminating migration and chaining

• Removing fragmentation
  Tablespace fragmentation
  Freespace fragmentation

• Optimising storage
  Using Oracle blocks efficiently

• Optimising sort operations
  Identifying operations which invoke sort operations 
  Tuning the sort parameters

• Tuning rollback segments
  Deciding the number and size of rollback segments 
  Handling the "segment too old" problem

• Monitoring and detecting lock contention
  Understanding DML and DDL lock attributes 
  Identifying situations that lead to lock contention

• Latch tuning
  Latch contention issues
  

Corporate Office:
207, Lok Center, Marol-Maroshi Road, Marol, Andheri (East), Mumbai 400 059. India.
Tel: +91- 22- 2920 1583, 2920 6976, 2925 7840, 2920 9720, 2920 4122, 2925 7632, 2920 4130, 2920 8902, 2925 3052, 2925 7689, 2920 7387, 2920 6329 Fax. No: +91-22- 2920 7388      |e-mail: info@pragatisoftware.com

© Pragati Software Pvt. Ltd. All rights reserved.