Oracle Database 11g: Performance Tuning

Oracle Database 11g: Performance Tuning

The Oracle Database 11g: Performance Tuning (1Z0-054) exam is primarily intended for the database administrators, support engineers, and technical consultants who can demonstrate 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.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. Prerequisites or additional requirements apply. Please click on the certification link for further clarification. This certification helps their companies qualify for the Oracle Database Performance Tuning Specialization.  

Exam Number:
135 minutes
Associated Certifications:

Oracle Database 11g Performance Tuning Certified Expert

OPN Certified Specialist

Number of
Exam Price:
US $245
Pricing may vary slightly by country or by localized currency. Check Pearson VUE’s website for exact pricing in your country.

Passing score subject to change. View Details
Click Here to Register:


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Mandatory Training
Candidates who are not already certified as 11g DBA OCP must complete the online or in class instructor led course below to obtain this certification. Candidates who already hold a 11g DBA OCP do not need to complete the training requirement.

Oracle Database 11g: Performance Tuning

Recommended Training
Oracle Database 11g: Performance Tuning - Exam Study Guide
OPN Guided Learning Path
Oracle Database 11g Performance Tuning Implementation Specialist
Oracle University Training
Oracle Database 11g: Performance Tuning



Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)



Exam Topics

Basic Tuning Tools

  • 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

Using Automatic Workload Repository

  • Create and manage AWR snapshots
  • Generate and read AWR reports, analyze Compare Periods reports

Defining Problems

  • Identify performance issues & set tuning priorities
  • Interpret tuning diagnostics
  • Tune for life cycle phase

Using Metrics and Alerts

  • Interprete metric views and alerts


  • Create and manage AWR baselines
  • Create AWR baselines for future time periods
  • Monitor performance and enable adaptive thresholds

Using AWR-Based Tools

  • Tune automatic maintenance tasks
  • Analyze ADDM reports
  • Analyze Active Session History (ASH) reports

Monitoring an Application

  • Configure and manage services
  • Use services with client applications, Database Resource Manager and Scheduler
  • Configure services aggregation, tracing, and set performance-metric thresholds

Identifying Problem SQL Statements

  • 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

Influencing the Optimizer

  • Describe the optimizer's behavior
  • Adjust parameters to influence the optimizer
  • Influence the optimizer (access methods, join techniques and adjust data structures)

SQL Performance Management

  • Manage optimizer statistics
  • Configure automatic SQL tuning and SQL profiling
  • Set up and use SQL plan baseline

Using SQL Performance Analyzer

  • Describe SQL Performance Analyzer process and benefits
  • Use SQL Performance Analyzer

Using Database Replay

  • Identify when and how to use Database Replay
  • Use Enterprise Manager to record and replay workloads

Tuning the Shared Pool

  • 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

Tuning the Buffer Cache

  • Describe the buffer cache architecture
  • Explain the symptoms that indicate a buffer cache problem
  • Tune the buffer cache for performance issues

Tuning PGA and Temporary Space

  • Diagnose PGA memory issues and size the PGA
  • Diagnose temporary space issues
  • Specify temporary tablespace parameters for efficient operation

Automatic Memory Management

  • Implement Automatic Shared Memory Management (ASMM)
  • Implement Automatic Memory Management (AMM)

Tuning Segment Space Usage

  • Tune segment space management
  • Use Automatic Segment Space Management
  • Diagnose row migration and chaining
  • Use segment shrinking and table compression

Tuning I/O

  • 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)

Appendix B Using Statspack

  • Using Statspack



Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.



 E-mail this page  Printer View