Trainer

24 yrs exp

Duration

16 Days

Recordings

24 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?

  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database
  • Gain an understanding of the Oracle Database Cloud Service

Who should go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

  • Oracle DBA

Course Overview

Course Content

Expand All
  • Course Objectives
  • Course Organization
  • Course Agenda
  • Topics Not Included in the Course
  • Who Tunes 
  • What Does the DBA Tune 
  • How to Tune
  • Tuning Methodology
  • Performance Tuning Diagnostics
  • Performance Tuning Tools
  • Tuning Objectives
  • Top Timed Events
  • DB Time
  • CPU and Wait Time Tuning Dimensions
  • Time Model
  • Dynamic Performance Views
  • Automatic Workload Repository Overview
  • Automatic Workload Repository Data
  • Enterprise Manager Cloud Control and AWR
  • Snapshots
  • Reports
  • Compare Periods
  • Defining the Problem
  • Limiting the Scope
  • Setting the Priority
  • Top SQL Reports
  • Common Tuning Problems
  • Tuning During the Life Cycle
  • ADDM Tuning Session
  • Performance Versus Business Requirements
  • Metrics and Alerts Overview
  • Limitation of Base Statistics
  • Benefits of Metrics
  • Viewing Metric History Information
  • Viewing Histograms
  • Server-Generated Alerts
  • Setting Thresholds
  • Metrics and Alerts Views
  • Comparative Performance Analysis with AWR Baselines
  • Automatic Workload Repository Baselines
  • Moving Window Baseline
  • Baselines in Performance Page Settings
  • Baseline Templates
  • AWR Baseslines
  • Creating AWR Baselines
  • Managing Baselines with PL/SQL
  • Automatic Maintenance Tasks
  • ADDM Performance Monitoring
  • Using Compare Periods ADDM
  • Active Session History
  • New or Enhanced Automatic Workload Repository Views
  • Emergency Monitoring
  • Real-time ADDM
  • Overview
  • Use Cases
  • Defining a Database Operation
  • Scope of a Composite Database Operation
  • Database Operation Concepts
  • Identifying a Database Operation
  • Enabling Monitoring of Database Operations
  • Identifying, Starting, and Completing a Database Operation
  • What is a Service 
  • Service Attributes
  • Service Types
  • Creating Services
  • Managing Services in a Single-Instance Environment
  • Where are Services Used 
  • Using Services with Client Applications
  • Services and Pluggable Databases
  • SQL Statement Processing Phases
  • Role of the Oracle Optimizer
  • Identifying Bad SQL
  • Top SQL Reports
  • SQL Monitoring
  • What is an Execution Plan 
  • Methods for Viewing Execution Plans
  • Uses of Execution Plans
  • Functions of the Query Optimizer
  • Selectivity
  • Cardinality and Cost
  • Changing Optimizer Behavior
  • Optimizer Statistics
  • Extended Statistics
  • Controlling the Behavior of the Optimizer with Parameters
  • Enabling Query Optimizer Features
  • Reducing the Cost
  • Index Maintenance
  • SQL Access Advisor
  • Table Maintenance for Performance
  • Table Reorganization Methods
  • Space Management
  • Extent Management
  • Data Storage
  • Real Application Testing: Overview
  • Real Application Testing: Use Cases
  • SQL Performance Analyzer: Process
  • Capturing the SQL Workload
  • Creating a SQL Performance Analyzer Task
  • SQL Performance Analyzer: Tasks
  • Parameter Change
  • SQL Performance Analyzer Task Page
  • Maintaining SQL Performance
  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Statistic Gathering Options
  • Setting Statistic Preferences
  • Restore Statistics
  • Deferred Statistics Publishing
  • Automatic SQL Tuning
  • Using Database Replay
  • The Big Picture
  • System Architecture
  • Capture Considerations
  • Replay Considerations: Preparation
  • Replay Considerations
  • Replay Options
  • Replay Analysis
  • Shared Pool Architecture
  • Shared Pool Operation
  • The Library Cache
  • Latch and Mutex
  • Diagnostic Tools for Tuning the Shared Pool
  • Avoiding Hard Parses
  • Reducing the Cost of Soft Parses
  • Sizing the Shared Pool
  • Oracle Database Architecture: Buffer Cache
  • Buffer Cache: Highlights
  • Database Buffers
  • Buffer Hash Table for Lookups
  • Working Sets
  • Buffer Cache Tuning Goals and Techniques
  • Buffer Cache Performance Symptoms
  • Buffer Cache Performance Solutions
  • SQL Memory Usage
  • Performance Impact
  • Automatic PGA Memory
  • SQL Memory Manager
  • Configuring Automatic PGA Memory
  • Setting PGA_AGGREGATE_TARGET Initially
  • Limiting the size of the Program Global Area (PGA)
  • SQL Memory Usage
  • Oracle Database Architecture
  • Dynamic SGA
  • Granule
  • Memory Advisories
  • Manually Adding Granules to Components
  • Increasing the Size of an SGA Component
  • Automatic Shared Memory Management: Overview
  • SGA Sizing Parameters: Overview
  • Commonly Observed Wait Events
  • Additional Statistics
  • Top 10 Mistakes Found in Customer Systems
  • Symptoms
Brochure Download

Modes of Training

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 22 Yrs exp and delivered more than 350 batches
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
Key Benefits

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 16 Live classroom sessions
  • Reading material and Lab activity guide
  • One-to-one dedicated server access for practice
  • 35 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Certified technical assistance
25-Dec

7:00am to 8:30am IST

15 Days (Mon-Fri)

31-Dec

7:00am to 8:30am IST

15 Days (Mon-Fri)

03-Jan

7:00am to 8:30am IST

15 Days (Mon-Fri)

₹16,000/- ₹12,000/- 25%OFF

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 16 Virtual online sessions
  • Access for 24 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicated online AksWave server access
  • 35 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
25-Dec

6:30am to 8:00am IST

15 Days (Mon-Fri)

30-Dec

6:30am to 8:00am IST

15 Days (Mon-Fri)

02-Jan

6:30am to 8:00am IST

15 Days (Mon-Fri)

21 % OFF ₹ 28,000/- $260 ₹22,000/-

SELF-PACED LEARNING

This Course Includes:
  • Access for 24 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicate online AksWave server access
  • 35 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

₹16,000/-

Our Instructor

Akal Singh

Oracle Certified Master
  • 4.5 Instructor Rating
  • 2,852 Reviews
Akal Singh stands at the forefront of the fastest moving technologies in IT Industry. He spent his past 24 yrs experience as Oracle DBA with skills into DBA Support, High Availability Design & Implementations, Technical Solutions, Automation using Scripting, Database Designing & as a Corporate Trainer too. With deep technical industry knowledge, Akal Singh has implemented many real time projects on advance Database areas.

His certification list includes many OCP, Oracle Certified Expert/Specialist (OCE) and Oracle Certified Master (OCM). He is an expertise in OS Administrations, Virtualizations/VMWare and Oracle Database 8i/9i/10g/11g & 12c, RAC, Data Guard, ASM, Oracle Exadata, Oracle Performance Tuning, Golden Gate, Streams, Oracle Security & many more advance technologies.

Akal Singh is also recognized as Senior Corporate Instructor and worked with Oracle University training division providing more than 300 corporate trainings into database advance concepts.

Certifications include :
  • Oracle Certified Professional (OCP) 9i, 10g, 11g and 12c
  • Oracle Certified RAC Expert (OCE)
  • Oracle RAC 11g Release 2 and Grid Infrastructure Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 11g Exadata Certified Implementation Specialist
  • Oracle Exadata X5 Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 10g Certified Master (OCM)
  • Oracle Cloud Autonomous Database Specialist
  • Oracle Cloud Infrastructure Certified Associate
  • Foundation Certificate in IT Service Management (ITIL Certificate)

Demo Video

No Video Found

No Demo Video

Certification Guidence

  • This course is designed for clearing the 1Z0-064 Oracle Database 12c: Performance Management and Tuning Certification exam.
  • This entire course content and our trainers helps you to get expertise and clear the certification program easily.
  • You will be awarded with Akswave course completion certificate after the course completion.
AksWave Certificate
Further details related to Oracle Database 12c: Performance Management and Tuning certification exam, find here.

Faq

Our trainer is an OCP & OCM certified consultant and has significant amount of experience in working with the technology, having 18yrs of experience.


Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that 

particular session.

For practical execution, our trainer/technical team will provide server access details to the student


Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to online@akswave-trainings.com with your queries.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant

& special discount for 2 or more participants.

* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If request made after 2 days, then Refund is made after deduction of administration fee.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Manoj Kumar
3 years ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna
3 years ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain
3 years ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8