info@smashgaps.com +91.7391.042.951 020 2565 4714

Oracle DBA Performance Tuning

Oracle DBA Performance Tuning - Training and Placement - Best Job Oriented IT Training Institutes and certification courses
Category Name : Database
Time Limit : 45 Hrs
Review

Intended Audience Database Administrators, Support Engineer, Technical Consultant.

Prerequisites Oracle Database 11g: Administration Workshop I Release 2
Oracle Database 11g: Administration Workshop II Release 2

Oracle Database 11g: Performance Tuning Methodology and Tools

  • Introduction to Performance Tuning in Oracle Database 11g
  • Performance Tuning Diagnostics and Tools in Oracle Database 11g

Oracle Database 11g: Using AWR and Defining Problems

  • Working with the Automatic Workload Repository (AWR)
  • Defining Problems in Oracle Database 11g

Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools and Services

  • Metrics, Alerts, Baselines and Thresholds in Oracle Database 11g
  • Using AWR-Based Tools
  • Configuring, Managing, and Implementing Services

Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

  • Identifying Problem SQL Statements
  • Influencing the Oracle Query Optimizer

Oracle Database 11g: SQL Performance Management and Database Replay

  • Using SQL Performance Analyzer and SQL Performance Management
  • Using Database Replay

Oracle Database 11g: Shared Pool and Buffer Cache Tuning

  • Tuning the Buffer Cache
  • Using Automatic Memory Management

Oracle Database 11g: Tuning PGA, Temporary Space, and Automatic Memory Management

  • Tuning PGA and Temporary Space
  • Using Automatic Memory Management

Oracle Database 11g: Segment Space, I/O and Performance Tuning

  • Tuning Segment Space Usage
  • Tuning I/O and Performance Tuning