1Z0-054 : Oracle Database 11g: Performance Tuning

Oracle Database 11g: Performance Tuning
ISBN : 978-1-61691-615-2
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.


uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keep the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keep learners engaged and make learning fun.

Here's What You Get

Exercises Flashcards Quizzes Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts. Glossary defines the key terms.

Exercise Questions
Glossary of terms

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
Full Length Tests
Post-Assessments Questions


Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Exam Information

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.

Prepare for the following certification

Career Prospects
  • Senior Database Administrators
  • Support Engineers
  • Technical Consultants
Exam FAQs
What is the exam registration fee?
USD 245

Pricing and taxes may vary from country to country.

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?
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.

Table of Content

Here's What you will Learn

Lesson 1: 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

Lesson 2: Using Automatic Workload Repository

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

Lesson 3: Defining Problems

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

Lesson 4: Using Metrics and Alerts

  • Interpret metric views and alerts

Lesson 5: Baseline

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

Lesson 6: Using AWR-Based Tools

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

Lesson 7: 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

Lesson 8: 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.

Lesson 9: 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)

Lesson 10: SQL Performance Management

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

Lesson 11: Using SQL Performance Analyzer

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

Lesson 12: Using Database Replay

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

Lesson 13: 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

Lesson 14: 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

Lesson 15: Tuning PGA and Temporary Space

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

Lesson 16: Automatic Memory Management

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

Lesson 17: Tuning Segment Space Usage

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

Lesson 18: 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)

Lesson 19: Appendix B Using Statspack

  • Using Statspack

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved