Oracle Database 11g: Performance Tuning DBA Training

3896 Learners

Oracle Database 11g: Performance Tuning DBA training demonstrates the skills and knowledge to identify the problems in a database, diagnose properly and fix with an optimized solution. The training describes the Oracle tuning methodology and explains how to use the tools for monitoring and diagnosing SQL and Instance tuning issues. The skills learned during the training will help the participants to optimize database workloads, manage performance, and provide hassle free service with higher quality within the Datacenter.

Upon the completion of the Oracle Database 11g: Performance Tuning training, you will be exhibiting the following skills:

  • Understand and use the Oracle Database tuning methodology and tools
  • Work with the Automatic Workload Repository (AWR) to tune the database
  • Define and use Metrics, Alerts, Baselines, AWR Tools and Services
  • Diagnose and tune common SQL and instance related performance problems
  • Use  Automatic Memory Management to tune the buffer cache, PGA , and temporary space
  • Use Enterprise Manager to monitor the instance performance
  • Use Instance parameters to tune instance components
Target audience
  • Database Designers
  • Database Administrators
  • Support Engineer
  • Technical Consultant
Prerequisites
  • Oracle Database 11g: DBA Track
Download Course Brochure

Oracle Database 11g: Performance Tuning DBA training demonstrates the skills and knowledge to identify the problems in a database, diagnose properly and fix with an optimized solution. The training describes the Oracle tuning methodology and explains how to use the tools for monitoring and diagnosing SQL and Instance tuning issues. The skills learned during the training will help the participants to optimize database workloads, manage performance, and provide hassle free service with higher quality within the Datacenter.

Upon the completion of the Oracle Database 11g: Performance Tuning training, you will be exhibiting the following skills:

  • Understand and use the Oracle Database tuning methodology and tools
  • Work with the Automatic Workload Repository (AWR) to tune the database
  • Define and use Metrics, Alerts, Baselines, AWR Tools and Services
  • Diagnose and tune common SQL and instance related performance problems
  • Use  Automatic Memory Management to tune the buffer cache, PGA , and temporary space
  • Use Enterprise Manager to monitor the instance performance
  • Use Instance parameters to tune instance components
Target audience
  • Database Designers
  • Database Administrators
  • Support Engineer
  • Technical Consultant
Prerequisites
  • Oracle Database 11g: DBA Track

Oracle Database 11g: Performance Tuning DBA Training Course Content

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

2. Oracle Database 11g: Using AWR and Defining Problems

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

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

4. Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

  • Identifying Problem SQL Statements
  • Influencing the Oracle Query Optimizer

5. Oracle Database 11g: SQL Performance Management and Database Replay

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

6. Oracle Database 11g: Shared Pool and Buffer Cache Tuning

  • Tuning the Buffer Cache
  • Using Automatic Memory Management

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

  • Tuning PGA and Temporary Space
  • Using Automatic Memory Management

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

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

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Oracle Database 11g: Performance Tuning DBA Corporate Training & Certification Program

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7