Monday, August 20, 2012

Oracle 11g Release 2 Performance Tuning Online course

ORACLE 11g Release 2 Performance Tuning Online Class

Topic: Performance Tuning

Duration: 30 Hrs

OS: OEL 6.3

Pre-requisites: OCP knowledge

Contact : 91-8553162006
Email: enquiry@amktechs.com

Syllabus
--------


Click to collapse 1 Performance Tuning Overview
  • 1.1 Introduction to Performance Tuning
  • 1.2 Introduction to Performance Tuning Features and Tools
Click to collapse 2 Designing and Developing for Performance
Click to collapse 3 Performance Improvement Methods
  • 3.1 The Oracle Performance Improvement Method
  • 3.2 Emergency Performance Methods
Click to collapse 4 Configuring a Database for Performance
  • 4.1 Performance Considerations for Initial Instance Configuration
  • 4.2 Creating and Maintaining Tables for Optimal Performance
  • 4.3 Performance Considerations for Shared Servers
Click to collapse 5 Automatic Performance Statistics
  • 5.1 Overview of Data Gathering
  • 5.2 Overview of the Automatic Workload Repository
  • 5.3 Managing the Automatic Workload Repository
Click to collapse 6 Automatic Performance Diagnostics
  • 6.1 Overview of the Automatic Database Diagnostic Monitor
  • 6.2 Setting Up ADDM
  • 6.3 Diagnosing Database Performance Problems with ADDM
  • 6.4 Views with ADDM Information
Click to collapse 7 Configuring and Using Memory
  • 7.1 Understanding Memory Allocation Issues
  • 7.2 Configuring and Using the Buffer Cache
  • 7.3 Configuring and Using the Shared Pool and Large Pool
  • 7.4 Configuring and Using the Redo Log Buffer
  • 7.5 PGA Memory Management
  • 7.6 Managing the Server and Client Result Caches
Click to collapse 8 I/O Configurations and Design
  • 8.1 About I/O
  • 8.2 I/O Configuration
 Click to collapse 9 Managing Operating System Resources
  • 9.1 Understanding Operating System Performance Issues
  • 9.2 Resolving Operating System Issues
  • 9.3 Understanding CPU
  • 9.4 Resolving CPU Issues
Click to collapse 10 Instance Tuning Using Performance Views
  • 10.1 Instance Tuning Steps
  • 10.2 Interpreting Oracle Database Statistics
  • 10.3 Wait Events Statistics
  • 10.4 Real-Time SQL Monitoring
  • 10.5 Tuning Instance Recovery Performance: Fast-Start Fault Recovery
Click to collapse 11 The Query Optimizer
  • 11.1 Overview of the Query Optimizer
  • 11.2 Overview of Optimizer Access Paths
  • 11.4 Reading and Understanding Execution Plans
  • 11.5 Controlling Optimizer Behavior
Click to collapse 12 Using EXPLAIN PLAN
  • 12.1 Understanding EXPLAIN PLAN
  • 12.2 The PLAN_TABLE Output Table
  • 12.3 Running EXPLAIN PLAN
Click to collapse 13 Managing Optimizer Statistics
  • 13.1 Overview of Optimizer Statistics
  • 13.2 Managing Automatic Optimizer Statistics Collection
  • 13.3 Gathering Statistics Manually
Click to collapse 14 Using Indexes and Clusters
  • 14.1 Understanding Index Performance
Click to collapse 15 Using SQL Plan Management
  • 15.1 Overview of SQL Plan Baselines
  • 15.2 Managing SQL Plan Baselines
  • 15.3 Using SQL Plan Baselines with SQL Tuning Advisor
  • 15.4 Using Fixed SQL Plan Baselines
  • 15.5 Displaying SQL Plan Baselines
  • 15.6 SQL Management Base
  • 15.7 Importing and Exporting SQL Plan Baselines
  • 15.8 Migrating Stored Outlines to SQL Plan Baselines
Click to collapse 16 SQL Tuning Overview
  • 16.1 Introduction to SQL Tuning
  • 16.2 Goals for Tuning
  • 16.3 Identifying High-Load SQL
  • 16.4 Automatic SQL Tuning Features
  • 16.5 Developing Efficient SQL Statements
  • 16.6 Building SQL Test Cases
Click to collapse 17 Automatic SQL Tuning
  • 17.1 Overview of the Automatic Tuning Optimizer
  • 17.2 Managing the Automatic SQL Tuning Advisor
  • 17.3 Tuning Reactively with SQL Tuning Advisor
  • 17.4 Managing SQL Tuning Sets
  • 17.5 Managing SQL Profiles
Click to collapse 18 SQL Access Advisor
  • 18.1 Overview of SQL Access Advisor
  • 18.2 Using SQL Access Advisor
  • 18.3 Tuning Materialized Views for Fast Refresh and Query Rewrite
Click to collapse 19 Using Optimizer Hints
  • 19.1 Overview of Optimizer Hints
  • 19.2 Specifying Hints
  • 19.3 Using Hints with Views
Click to collapse 20 Using Plan Stability
  • 20.1 Using Plan Stability to Preserve Execution Plans
  • 20.2 Using Plan Stability with Query Optimizer Upgrades
Click to collapse 21 Using Application Tracing Tools
  • 21.1 End to End Application Tracing
  • 21.2 Using the trcsess Utility
  • 21.3 Understanding SQL Trace and TKPROF

8 comments:

  1. Hi there,
    I would like to take this course. Please tell me when course starts and how much for the course. Thanks.

    ReplyDelete
  2. tell me how can i join the course .Reply atsubha19821@gmail.com

    ReplyDelete
  3. Hi. I would like to get this training. Please let me know my email id is darvinv@gmail.com

    ReplyDelete
  4. Hi there,
    I would like to take this course. Please tell me when course starts and how much for the course. Thanks.

    ReplyDelete
  5. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in ORACLE DBA 11 G, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on ORACLE DBA 11 G. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/


    ReplyDelete
  6. It is very good and useful .Learned a lot of new things from your post!Good creation ,thanks for good info Oracle SOA Online Training

    ReplyDelete

Share your knowledge it really improves, don't show off...