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
Post Assessment Questions
Exam related FAQs
What is the exam registration fee? USD 245
Where do I take the exam? The 1Z0-054 exam is administered by Pearson VUE at testing centers worldwide.Click here to find a testing center near you.
What is the format of the exam? The exam consists of multiple choice questions.
What are the pre-requisites of the exam? You are required to have Oracle Database 11g Administrator Certified Professional Certification before giving this exam. Click here for more information on this.
How many questions are asked in the exam? The exam contains 80 questions.
What is the duration of the exam? 135 minutes
What is the passing score? 70%
What is the exam's retake policy?

Retake Policy for Oracle 1Z0-054 exam is:

  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may not retake a beta exam at any time.
What is the validity of the certification? The Oracle Database 11g Performance Tuning Certified Expert certification has no expiration. The certification holder is certified for life unless Oracle changes their policy. Click here for more information.
Where can I find more information about this exam? To know more about the 1Z0-054, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Senior Database Administrators
  • Support Engineers
  • Technical Consultants
  • 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)