Oracle Database 11g: Performance Tuning 1Z0-054

Basic Tuning Tools
1. Diagnose performance issues using top wait events and the time model
2. Use dynamic performance views to view statistics and wait events
3. Use Enterprise Manager Monitoring
4. Identify the key tuning components of the alert logs
Using Automatic Workload Repository
1. Create and manage AWR snapshots
2. Generate and read AWR reports, analyze Compare Periods reports
Defining Problems
1. Identify performance issues & set tuning priorities
2. Interpret tuning diagnostics
3. Tune for life cycle phase
Using Metrics and Alerts
1. Interprete metric views and alerts
Baseline
1. Create and manage AWR baselines
2. Create AWR baselines for future time periods
3. Monitor performance and enable adaptive thresholds
Using AWR-Based Tools
1. Tune automatic maintenance tasks
2. Analyze ADDM reports
3. Analyze Active Session History (ASH) reports
Monitoring an Application
1. Configure and manage services
2. Use services with client applications, Database Resource Manager and Scheduler
3. Configure services aggregation, tracing, and set performance-metric thresholds
Identifying Problem SQL Statements
1. Describe SQL statement processing
2. View the SQL statement statistics to identify the SQL statements that perform poorly
3. Describe and use methods for Viewing Execution Plans
Influencing the Optimizer
1. Describe the optimizer's behavior
2. Adjust parameters to influence the optimizer
3. Influence the optimizer (access methods, join techniques and adjust data structures)
SQL Performance Management
1. Manage optimizer statistics
2. Configure automatic SQL tuning and SQL profiling
3. Set up and use SQL plan baseline
Using SQL Performance Analyzer
1. Describe SQL Performance Analyzer process and benefits
2. Use SQL Performance Analyzer
Using Database Replay
1. Identify when and how to use Database Replay
2. Use Enterprise Manager to record and replay workloads
Tuning the Shared Pool
1. Describe Latches and Mutexes
2. Diagnose and change cursor sharing
3. Diagnose and resolve shared pool fragmentation
4. Manage the results cache and tune the large pool
5. Tune the data dictionary cache
Tuning the Buffer Cache
1. Describe the buffer cache architecture
2. Explain the symptoms that indicate a buffer cache problem
3. Tune the buffer cache for performance issues
Tuning PGA and Temporary Space
1. Diagnose PGA memory issues and size the PGA
2. Diagnose temporary space issues
3. Specify temporary tablespace parameters for efficient operation
Automatic Memory Management
1. Implement Automatic Shared Memory Management (ASMM)
2. Implement Automatic Memory Management (AMM)
Tuning Segment Space Usage
1. Tune segment space management
2. Use Automatic Segment Space Management
3. Diagnose row migration and chaining
4. Use segment shrinking and table compression
Tuning I/O
1. Diagnose database I/O issues
2. Describe the Stripe and Mirror Everything (SAME) concept
3. Set filesystemio_options and Choose appropriate I/O solutions
4. Tune Automatic Storage Management (ASM)
Appendix B Using Statspack
1. Using Statspack

Next up

Oracle Database 11g: Performance Tuning 1Z0-054

Description

Resource summary

Similar

	Created by Diego Stammerjohann over 10 years ago