Oracle Database: Performance Management and Tuning

Overview

Understudies make sense of how to use Oracle Database customized tuning features, for instance, SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning procedures. The course bases on the tuning tasks expected of a DBA: open tuning of SQL declarations, keeping up SQL clarification and movement execution, and tuning the Oracle Database Instance parts.

Audience

  • Administrator
  • Database Administrator

 

Download Course Contents Test your current knowledge Qubits
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 5 Days
Fee : Dubai : USD 3,400 Sydney : USD 3,000 London : USD 3,200 India : USD 2,000
March
02-06 (Birmingham)
02-06 (Brisbane)
02-06 (Delhi)
02-06 (london)
02-06 (Manchester)
02-06 (Melbourne)
02-06 (Sydney)
08-12 (Dubai)
09-13 (Bangalore)
09-13 (london)
16-20 (Chennai)
April
06-10 (Birmingham)
06-10 (Brisbane)
06-10 (London)
06-10 (Manchester)
06-10 (Melbourne)
06-10 (Sydney)
13-17 (Bangalore)
20-24 (Chennai)
May
04-08 (Birmingham)
04-08 (Brisbane)
04-08 (London)
04-08 (Manchester)
04-08 (Melbourne)
04-08 (Sydney)
18-22 (Chennai)
June
01-05 (Birmingham)
01-05 (Brisbane)
01-05 (London)
01-05 (Manchester)
01-05 (Melbourne)
01-05 (Sydney)
July
06-10 (Delhi)
06-10 (london)
12-16 (dubai)
13-17 (Bangalore)
13-17 (london)
20-24 (Chennai)
November
02-06 (Delhi)
02-06 (london)
08-12 (Dubai)
09-13 (Bangalore)
09-13 (london)
16-20 (Chennai)
Instructor-Led Online Training
Duration : 5 Days
Fee : USD 2,500 (1-on-1)†
March
02-06
08-12
09-13
16-20
April
06-10
13-17
20-24
May
04-08
18-22
June
01-05
July
06-10
12-16
13-17
20-24
November
02-06
08-12
09-13
16-20

Enquire Now




Input symbols

Course Prerequisites

Proposed Prerequisite :

  • Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
  • Familiarity with Oracle Database foundation
  • Familiarity with Oracle Database arrangement thoughts

 

Required Prerequisite :

  • Oracle Database 18c: Administration Workshop Ed 1
  • Basic data of Linux working system
  • A working data of SQL and PL/SQL groups
  • Basic perception of Oracle Database plan
  • Familiarity with basic database checking procedures

 



After completion of this course, you will learn following topics:

  • Diagnose and tune regular Instance related execution issues
  • Use Enterprise Manager execution related pages to screen an Oracle database
  • Use the Oracle Database tuning procedure
  • Utilize database counsels to proactively tune an Oracle Database Instance
  • Use the devices dependent on the Automatic Workload Repository to tune the database
  • Diagnose and tune basic SQL related execution issues

 

)