Durasi : 4 hari

1. Performance Tuning Overview
   Write appropriate tuning goals
   Apply the tuning methodology
   Balance performance and safety trade-offs
   Identify common tuning problems
   Log a performance Service Request with Oracle Support
2. Statistics and Wait Events
   Identify dynamic performance views useful in tuning
   Identify key tuning components of the alert log file
   Identify key tuning components of user trace files
   Use dynamic performance views to view statistics and wait events
3. Metrics, Alerts, and Baselines
   View metrics using the metrics history views
   Create metric thresholds
   View alerts
   Create metric baselines
   Enable adaptive thresholds
4. Using Statspack
   Install Statspack
   Create Statspack snapshots
   Generate Statspack reports
   Identify the major sections of the Statspack report
5. Using AWR
   Create and manage AWR snapshots
   Generate AWR reports
   Create snapshot sets and compare periods
   Generate ADDM reports
   Generate ASH reports
6. Reactive Tuning
   Use Enterprise Manager pages to identify symptoms
   Eliminate operating system issues
7. Tuning the Shared Pool
   Diagnose shared pool problems
   Size the shared pool
   Size the reserved area
   Keep objects in the shared pool
8. Tuning the Buffer Cache
   Describe the buffer cache architecture
   Size the buffer cache
   Resolve common performance issues related to the buffer cache
   Use common diagnostic indicators to suggest a possible solution
9. Automatic Shared Memory
   Enable Automatic Shared Memory
   Set auto-tuned memory parameters
   Set the manually tuned SGA parameters
   Use the SGA advisor to set SGA target
10. Checkpoint and Redo Tuning
    Diagnose checkpoint and redo issues
    Implement Fast Start MTTR target
    Monitor performance impact of Fast Start MTTR target
    Implement multiple database writers
    Tune the redo chain
    Size the redo log file
    Size the redo log buffer
11. Tuning I/O
    Diagnose database I/O issues
    Describe the Stripe and Mirror Everything (SAME) concept
    Explain the benefits of asynchronous I/O
    Choose appropriate I/O solutions
12. Tuning PGA and Temporary Space
    Diagnose PGA memory issues
    Size the PGA memory
    Diagnose temporary space issues
    Specify temporary tablespace parameters for efficient operation
13. Tuning Block Space Usage
    Tune segment space management
    Convert from dictionary managed tablespaces
    Convert to automatic segment space management
    Tune block space management
    Diagnose and correct row chaining
    Diagnose table fragmentation
    Compare characteristics of bigfile and smallfile tablespaces