TechFetch | Oracle Database 11g: Performance Tuning - 24x7 Online Class
  • Introduction
  • Course Details
  • Target Audience
  • Register
  • FAQ
  • Trainer
24x7 Online
Oracle Database 11g: Performance Tuning
Oracle Database 11g: Performance Tuning
  • Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool – Enterprise Manager – can be used to monitor an Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface. This course provides an introduction to performance tuning methodologies, effective tuning goals, and the types of performance data that can be gathered by diagnostic tools available in Oracle Database 11g. It also demonstrates how to use Time Model and Enterprise Manager to diagnose performance issues, and discusses using the various dynamic performance views (V$ views) to perform statistical analysis when diagnosing problems. The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the Oracle Database 11g Performance Tuning Certified Expert designation. TechFetch and Skillsoft TechFetch Academy partnered with Skillsoft to bring finest quality training content, known for in-depth treatment of concepts. This course is modular, designed with finest navigation controls, allowing you the flexibility to pace your learning. Courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. You will encounter several feedback loops to help you assess where you are strong and where you need additional review. More value at less cost. This course gives you all of the benefits of a live class at just a fraction of the cost.
Course Details
1. Performance Tuning Methodology and Tools
  • Identify the steps in both the general and Oracle tuning methodologies
  • Identify the characteristics of effective tuning goals
  • Recognize the three types of performance data gathered by diagnostic tools
  • Recognize the factors to consider when tuning DB time
  • Recognize how to use the time model to diagnose performance issues
  • Recognize how to view diagnostic information in Enterprise Manager
  • Recognize how you can use dynamic performance to view statistics
  • Recognize how to use dynamic performance views to display wait events
  • Recognize how to use Alert Logs to perform tuning
  • Identify ways to generate user trace files
  • View diagnostic information in a given scenario
2. Using AWR and Defining Problems
  • Identify the features of the AWR
  • Recognize how to create and manage AWR snapshots
  • Recognize how to run an AWR report
  • Recognize how to generate a Compare Periods report
  • Generate an AWR report in a given scenario
  • Generate a Compare Periods report in a given scenario
  • Recognize how to define problems
  • Recognize how to set tuning priorities
  • Identify factors to consider when tuning for different application life cycle phases
  • Identify the seven steps for implementing migration, upgrade, and environment changes
  • Recognize how business requirements affect performance
  • Identify how to file a performance service request
  • Recognize how to install Statspack
  • Recognize how to capture and manage Statspack snapshots
  • Recognize how to read Statspack performance reports
3. Metrics, Alerts, Baselines, AWR Tools, and Services
  • Identify the features of metrics, alerts, and baselines
  • Recognize how to view metric history information, metric details, and histogram views
  • Recognize how to receive an alert when a specified threshold is exceeded
  • Identify the features of AWR baselines
  • Recognize how to create AWR baselines
  • Recognize how to manage AWR baselines
  • Recognize how to manage thresholds
  • Create and manage AWR baselines and thresholds
  • Recognize how to tune automatic maintenance tasks
  • Recognize how to generate and read ADDM reports
  • Identify the features of the Active Session History
  • Recognize how to generate ASH reports
  • Recognize how to configure and manage services
  • Recognize how to use services with client applications, the Database Resource Manager, and the Scheduler
  • Recognize how to set performance-metric thresholds on services
  • Recognize how to configure services aggregation and tracing
4. Problem SQL Statements and Oracle Optimizer
  • Match each phase in SQL statement processing with its features
  • Identify the steps in DML processing
  • Identify the operations performed by the Oracle optimizer
  • Recognize the features of execution plans
  • Recognize how to generate and view execution plans
  • Recognize how to use the SQL*Plus AUTOTRACE command options to view execution plans and statistics
  • Identify the functions of the query optimizer
  • Recognize how to influence and control the optimizer's behavior
  • Identify the scan types for retrieving data from the database
  • Recognize how to work with bitmap and B*Tree indexes
  • Identify when to use different join methods
  • Identify common sort operations
  • Recognize how to manage and maintain indexes
  • Recognize how to reorganize tables
  • Use AUTOTRACE to analyze statistics and execution plans in a given scenario
5. Shared Pool and Buffer Cache Tuning
  • Recognize the features of the shared pool
  • Identify the role of AWR and Statspack reports indicators when diagnosing problems
  • Recognize how to avoid hard parses
  • Recognize how to avoid soft parses
  • Recognize how to reserve space in the shared pool
  • Recognize how to manage the results cache
  • Recognize the features of the buffer cache architecture
  • Identify the symptoms that indicate a buffer cache problem
  • Identify methods to resolve common performance issues related to the buffer cache
  • Recognize how to properly size the buffer cache
  • Manage the buffer cache in given scenarios
6. SQL Performance Management and Database Replay
  • Recognize the steps in the SQL Performance Analyzer process
  • Recognize how to use the SQL Performance Analyzer with PL/SQL
  • Recognize how to manage changes to optimizer statistics to maintain SQL performance
  • Recognize how to use Automatic SQL Tuning to automate the SQL tuning process
  • Recognize how to set up SQL plan management
  • Seed SQL plan baselines from SQL Performance Analyzer in a given scenario
  • Recognize the steps in using Database Replay to test the impact of a system change
  • Recognize how to use the Enterprise Manager to capture workloads
  • Recognize how to replay workloads using the Enterprise Manager
  • Recognize how to use PL/SQL to capture and replay workloads
7. Tuning PGA, Temporary Space, and AMM
  • Identify how to diagnose PGA memory issues
  • Recognize how to size the PGA memory
  • Recognize how to manage temporary tablespaces
  • Identify the components of Automatic Shared Memory Management
  • Recognize how to configure Automatic Shared Memory Management (ASMM)
  • Recognize how to configure Automatic Memory Management
  • Configure memory in a given scenario
  • Tune PGA memory in a given scenario
  • Create a temporary tablespace group in a given scenario
8. Segment Space, I/O, and Performance Tuning
  • Identify the characteristics of extents
  • Identify the characteristics of blocks
  • Identify the characteristics of Automatic Segment Space Management (ASSM)
  • Recognize how to manage row migration and chaining
  • Recognize how to shrink segments using SQL or the Enterprise Manager
  • Recognize how to use table compression
  • Identify the characteristics of I/O
  • Recognize how to tune I/O effectively
  • Identify the characteristics of RAID
  • Recognize how to manage and monitor ASM
  • Recognize best practices for performance tuning
  • Tune I/O in a given scenario
  • View I/O statistics in a given scenario
Target Audience
  • A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Course Fee
90 days
$179
Register for course
Frequently Asked Questions (FAQ)
1. How long do I have access to the course materials?

You have unlimited access to the materials, for the duration of your purchase period, viz 3 months, 6 months, 12 months etc. If no purchase period is mentioned, you will have 12-months access.

2. What is the refund policy on the course?

Our standard policy is that purchases are considered final, and no refunds are possible.

3. Do I have to download any software to view material?

No. If you have an internet connection, you should be able to access courses from Windows and Mac OS devices, with the following environments:

  • Windows 7 or above, with Internet Explorer v8.0 JRE 1.6.0_17 (or above)
  • Mac 10.6 with Safari 4.0.3 and JRE 1.6.0_17 (or above)
4. Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, you should be able to access courses from Windows and Mac OS devices, with the following environments:

  • Windows 7 or above, with Internet Explorer v8.0 JRE 1.6.0_17 (or above)
  • Mac 10.6 with Safari 4.0.3 and JRE 1.6.0_17 (or above)

We are currently working to bring some courses that can be downloaded on your local devices as well. Please stay tuned.

5. Do I have to be registered user of TechFetch.com to subscribe to TechFetch Academy?

No. You are welcome to be member of TechFetch Academy even if you are not a registered user TechFetch.com. We recommend that you post your resume on TechFetch.com though. It is free. Who knows what pleasant surprises await you there!

6. Will I get a certificate after completing this course?

Not now. However, very soon, you will have the option to export learning credits to TechFetch.com job board, which will be displayed as a configurable badge.

7. How do I pay for the courses?

You can purchase courses, securely, using any of the major credit cards (Visa / Mastercard / Discover).

8. Do you offer testing for certification exams?

No. we offer certification-prep only. You will need to register with one of the authorized testing centers for actual exams.

9. How long will a course take to complete?

It varies from student to student, and from course to course. However, on average, it is prudent to budget around 50-hours per single exam.

10. Who do I contact for any clarifications?

Our helpdesk team is available on all working days from 8AM – 6PM New York Time (Eastern Standard Time).

Helpdesk Phone : +1-703–544-2058; Helpdesk Email: Academy@techfetch.com

Trainer
  • Skillsoft is a pioneer in the field of learning with a long history of innovation. Skillsoft provides cloud-based learning solutions for our customers worldwide, who range from global enterprises, government and education customers to mid-sized and small businesses.
    Skillsoft’s courses, books and videos have been developed by industry-leading learning experts to ensure that they build talent and develop a more knowledgeable, productive and valuable workforce. Skillsoft’s customer support teams draw on a wealth of in-house experience and a comprehensive learning e-library to develop both packaged and custom learning programs tailored to customers' needs.
    Over 5,000 corporate clients and more than 13,000,000 learners worldwide benefit from Skillsoft’s high-value training content and hands-on support to assist them, in maximizing their ongoing learning success.
  • Awards & recognition Skillsoft consistently earns recognition from our industry's best-known publications and analyst firms. Some recent honors: 2013
    • TrainingIndustry.com Top 20 Training Outsourcing Companies & Top 20 Leadership Training Companies.
    • Best of Elearning! Awards – Finalist.
    2012
    • Workforce Management's Training Providers Hot List.
    • TrainingIndustry.com Top 20 Content Development Companies, Top 20 Learning Portal Companies, Top 20 Leadership Training Companies, Top 20 IT Training Companies & Top 20 Workforce Development Providers.
    • Chief Learning Officer Learning in Practice Awards: Gold Winner for Excellence in Social Learning.
    • Military Training Technology's Top Simulation and Training Companies.
    • Best of Elearning! Best Leadership Develop and Best IT Content.
    • Brandon Hall Excellence in Technology Silver Award for Best Advance in Learning Management Technology.
    • Gold Steve Winner, Sales Department of the Year (Public Services & Education).
    • LearnX Asia Pacific First Place Winner, Best eLearning Design: Interactive Scenario.
    2011
    • LearnX Asia Pacific Platinum Winner, Best Training Provider.
    • TrainingIndustry.com Top 20 IT Training Companies.
    • Elearning! Magazine Best Social Learning Tool & Best IT Content.
    • Military Training Technology magazine's Top Training & Simulation Companies.
    • Brandon Hall Excellence in Technology Silver Award for Best Advance in Learning Management Technology.
    2010
    • Elearning! Magazine Excellence Awards for Best Learning Management System, Best Leadership Development Program, & Best Soft Skills Content; Best Compliance Content, Best IT Content.
    • TrainingIndustry.com Top 20 IT Training Companies & Top 20 Learning Portal Companies.
    • Brandon Hall Research Bronze Medal in Best Advance in Social Learning Technology.
    • LearnX Asia Pacific Platinum Winner, Best Training Provider.
    • AIIA iAwards Victoria State Award Winner, Elearning.
    • Military Training Technology magazine's Top Training & Simulation Companies.
    2009
    • LearnX Asia Pacific Gold Winner, Best Training Provider.
    • Brandon Hall Research Gold Medal for Best Advance in Technology for Virtual-Classroom Training or Conferencing.
    • TrainingIndustry.com Top 20 IT Training Companies.
    • Elearning! and Government Elearning! Magazine's Best IT Content and Best Soft Skills Training.