Oracle Performance Tuning Online Training

Oracle Performance Tuning Online Training

Oracle Performance Tuning Online Training
Oracle Performance Tuning Online Training

Oracle Performance Tuning Online Training Course Content:

Oracle 11g Performance Tuning:

Properly Focusing Database Tuning Efforts

  • The Database Tuning Focus
  • Comparing Database Applications
  • Impact Of Systems Infrastructure
  • Impact Of Enterprise Architecture
  • Top 10 Oracle Database Mistakes

Understanding The Database Host System

  • Top 3 Host Performance Issues
  • The Operating System
  • Host System Processors
  • I/O Processing
  • Oracle Exadata Database Platform

Assessing Current Database Performance

  • About Database Tuning
  • Performance Statistics
  • Comprehensive Performance Analysis
  • Real-Time Performance Monitors

Real-Time Instance Activity Monitoring

  • Drill-Down Real-Time Monitors
  • How To Monitor Instance Activity
  • Cursor Measures
  • Transaction Measures
  • Session Measures
  • Logical I/O Measures
  • Physical I/O Measures
  • Net I/O Measures
  • Table Measures
  • All Measures

Understanding Statistics and Wait Events

  • How Are The Statistics Organized?
  • Controlling The Statistics Collection
  • Statistics_Level Parameter
  • Timed_Statistics Parameter
  • Timed_Os_Statistics Parameter
  • Examining Current Statistics Collection Settings
  • Control_Management_Pack_Access Database Parameter
  • Using Operational Statistics
  • Using Wait Events
  • Using Time Model Statistics
  • Interpreting Os Statistics

Understanding I/O Internals

Automatic Database Tuning and Awr

  • Management and Advisory Framework
  • Managing Awr
  • About Active Session History (Ash)
  • Addm

Managing Snapshots

Create_Baseline() and Drop_Baseline()

Create_Snapshot() and Drop_Snapshot_Range()

Proactive Tuning With Metrics, Alerts and Baselines

  • Metrics and Alert Thresholds
  • Managing Metrics
  • Using Metric Baselines
  • Managing Alerts

Tuning Memory: The Shared Pool

  • More About The Shared Pool
  • Diagnose Shared Pool Problems
  • Keep Objects In The Shared Pool

Tuning Memory: The Buffer Cache

  • More About The Buffer Cache
  • Remedy Performance Issues

Tuning Memory: Automatic Shared Memory

  • Automatic Shared Memory Management
  • Using Em and The Memory Advisors

Tuning I/O: Checkpoint and Redo Tuning

  • Tune Redo Writing and Archiving
  • Mttr Advisor and Tuning Checkpoints
  • Log_Checkpoints_To_Alert
  • Additional Redo Tuning Options
  • Redo Log Files and 4k Sectors

Tuning I/O: Database Writes

Space Tuning: Block Space Usage

  • Using The Shrink Space Option
  • Using The Segment Advisor
  • About Chained and Migrated Rows
  • Call Delete_Task()

PL/SQL Tuning Support From Em

  • Application Tuning Setup
  • Em Application Monitoring and Tuning

Performance Tuning Using Statspack

  • Install The Statspack Utility
  • Create Statspack Snapshots
  • Generate Statspack Reports
  • Identify The Report Sections


Drop your query

What my Client's Say?


  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim