Trainer

NA yrs exp

Duration

18 Days

Recordings

24 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

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

What are the pre-requisites for this Course?

Course Overview

Course Content

  • 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

Modes of Training

Akswave_classroom

Classroom Training

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

Akswave_Online

Online Training

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

Akswave_Selfpaced

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.

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, NA Yrs exp and delivered more than 350 batches
  • QUALITY CONTENT : Covers in-depth and industry-relevant advance topics.
  • LAB ACCESS : Practice hands-on with dedicated online servers, anytime, anywhere.
  • BEST PRICE : Best value training at a competitive price.
  • SESSION RECORDINGS : Access to session recordings for easy revision.
  • REAL-TIME SCENARIOS : Learn through practical scenarios and live projects.
Key Benefits

Upcoming Batches

CLASSROOM TRAINING

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

7:00am to 8:30am IST

15 Days (Mon-Fri)

05-Aug

7:00am to 8:30am IST

15 Days (Mon-Fri)

08-Aug

7:00am to 8:30am IST

15 Days (Mon-Fri)

Course Fee : 16,000/-

Discount : ₹ 4,000/- (25%)

Offer Price : 12,000/-

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having NA yrs exp
  • 18 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
30-Jul

6:30am to 8:00am IST

18 Days (Mon-Fri)

04-Aug

6:30am to 8:00am IST

18 Days (Mon-Fri)

07-Aug

6:30am to 8:00am IST

18 Days (Mon-Fri)

Course Fee : 28,000/-

Discount : ₹ 6,000/- (21%)

Offer Price : 22,000/- $257

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
  • 38 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

16,000/-

Our Instructor

No Records Found

Demo Video

No Video Found

No Demo Video

Certification Guidence

No Records Found

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

Testimonials

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8