Scroll to top button

Oracle Database 11g: Performance Tuning

ISBN : 9781616916152

The OracleDatabase 11g: Performance Tuning certification is an industry recognized credential. The certification is proof of a person's competence across a spectrum of skills including SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor.

The certification is targeted to those database administrators, support engineers, and technical consultants who have demonstrated their knowledge and skills using Oracle Database 11g automatic tuning features, including SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor.

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