Tuning para DBA's Oracle10g

CONTENIDOS

• 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
• 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
• Metrics, Alerts, and Baselines
• View metrics using the metrics history views
• Create metric thresholds
• View alerts
• Using Statspack
• Install Statspack
• Create Statspack snapshots
• Generate Statspack reports
• Identify the major sections of the Statspack report
• Using AWR
• Create and manage AWR snapshots
• Generate AWR reports
• Create snapshot sets and compare periods
• Generate ADDM reports
• Generate ASH reports
• Reactive Tuning
• Use Enterprise Manager pages to identify symptoms
• Eliminate operating system issues
• Tuning the Shared Pool
• Diagnose shared pool problems
• Size the shared pool
• Size the reserved area
• Keep objects in the shared pool
• 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
• 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
• 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
• 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
• Tuning PGA and Temporary Space
• Diagnose PGA memory issues
• Size the PGA memory
• Diagnose temporary space issues
• Specify temporary tablespace parameters for efficient operation
• 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