This course consists of:

  • Using the Oracle tuning methodology
  • Tuning instance components by primarily using instance parameters
  • Using Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Identifing problem SQL statements
  • Using database advisors to proactively correct performance issues
  • Tuning SQL performance problems
  • Monitoring instance performance by using Enterprise Manager

Radiant Techlearning offers Oracle Database: Performance Management and Tuning Training Program in Classroom and Virtual Instructor Led/Online mode.


Duration: 5 days


Learning Objectives:

  • Make use of the Oracle Database tuning methodology appropriate to the available tools.
  • Use database advisors to proactively tune an Oracle Database Instance.
  • Using the tools based on the Automatic Workload Repository to tune the database.
  • Diagnose and tune common SQL related performance difficultie
  • Diagnose and tune common Instance related performance issue
  • Using Enterprise Manager performance-related pages to monitor an Oracle Database.


Suggested Prerequisite:

  • Knowledge of Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts

Required Prerequisite:

  • Oracle Database 18c: Administration Workshop Ed 1
  • Basic knowledge of Linux operating system
  • Working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

Audience Profile

  • Administrator
  • Database Administrator

Course Content

  • Introduction
  • Basic Tuning Diagnostics
  • Using Automatic Workload Repository
  • Defining the Scope of Performance Issues
  • Using Metrics and Alerts
  • Using Baselines
  • Using AWR-Based Tools
  • Real-Time Database Operation Monitoring
  • Monitoring Applications
  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • Reducing the Cost of SQL Operations
  • Using SQL Performance Analyzer
  • SQL Performance Management
  • Using Database Replay
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Tuning PGA and Temporary Space
  • Automatic Memory
  • Performance Tuning Summary with Waits


Q: Why do we need tuning in Oracle and do we have to perform tuning consistently?


A: By tuning the Oracle server, you can tailor its performance to make your needs highly tunable.  Its flexibility allows you to make small adjustments that affects database performance. Yes, we have to perform tuning consistently.

Q: What version tools and devices do I need to have access for tuning and performance management?


A: One of the most effective tool to be recommended would be SolarWinds Database Performance Analyser. It is a specifically designed for Oracle database deployment and has wide range of capability to improve the perfomance.

Q: What are PL/SQL packages?


A: PL/SQL is a block structured language that supports developers to combine the power of SQL with database statements.  It is also responsible for transferring all the statements to Oracle engine which results increment in processing speed and decreases the traffic load.

Q: What is Index and how does it work?


A: Index is a key of database tabular arrangement which is a responsible to optimize the performance of the database by reducing the number of access to the query processing.   A clustered index helps in determining the potential order of data in a specific table.

Q: What is AWR and what is its role?


A: AWR means Automatic Workload Repository which is responsible for collection of performance statistics and to navigate performance issues.

Q: Do I need to have knowledge of any operating system?


A: Yes, one should have basic knowledge of Linux operating system.

Q: Why one should prefer Radiant Techlearning ?


A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the e-mail to answer your technical queries even after the training program.

Q: Does this training program include any project?


A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.

Q: If I face technical difficulty during the session then is there any remedy for that?


A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.

Q: What is schedule of training program?


A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch