Oracle DB Performance Tuning 11g

Course Duration: 40 Hours

Course Highlights:

  • Oracle Database Architecture
  • Performance Tuning Tools
  • Oracle Optimizer
  • SQL Tuning with Activities
  • REAL TIME DATA LOADING AND MONITORING
  • REAL TIME – AWR REPORT ANALYSIS
  • REPORTS & ANALYSIS
  • DATABASE STORAGE OBJECTS
  • ADVISORIES
  • INSTANCE/MEMORY REAL TIME TUNING
  • I/O TUNING
  • BEST ARCHITECTURAL PRACTICES

Required Prerequisites:

  • Knowledge of Oracle SQL and PL/SQL
  • Knowledge of Oracle Database 11g.

Target Audience:

  • Oracle DBA who to learn Oracle Database Performance Tuning in detail

Course Content

timeline_pre_loader

Software functionality

OS Dependencies

Background processes – To concentrate

Storage and Memory dependencies

Explain plan of SQL statements

Tracing SQL execution

tkprof for trace analysis

AUTOTRACE in SQL*

V$ dynamic performance views

OEM

AWR, ADDM and ASH reports

SQL tuning advisor and baselines

OS monitoring

Basics of Optimizer

Understanding behaviour

Histograms and Bind Peeking

Access paths

Interpreting JOINS

Optimizer statistics

Hints

Manage Optimizer

Thumb rules

Possible SQL issues

.SQL Tuning methods and Tools

Pro-active SQL Tuning

Reactive SQL Tuning

Real-Time Tuning Examples

SQL tuning examples (Continue)

Creating SQL tuning sets and baselines

Tuning JOINS

Sorting and Grouping activities

PL/SQL tuning notes

Parallelism in SQL

Creating SCHEMAS, TABLES

Preparing Environment

Load Data-1

Monitor using OEM & Alert log

Load Data-2

Monitor using V$ views

Preparing environment

Load Data-3

Generate AWR reports

Analysis & Problem Identification

Fixing Performance Issue

AWR reports and baselines

ADDM reports

ASH report

Exercise on AWR, ADDM & ASH REPORTS

Optimizer tracing and analysis

Tracing levels and options

Exercise on Optimizer tracing

Storage options

Oracle Partitioning

Star schema design

Partitioning Examples

Indexes Overview

B-Tree Indexes & Examples

BitMap Indexes & Examples

Index Organized Tables & Examples

BAD SQL tracing & Analysis

SQL tuning Advisor

STS (SQL Tuning Set) with SQL tuning advisor

SQL Access advisor

Implementing SQL Plan management

Fragmentation and Data distribution

Shared pool tuning – Latch/Mutex, Library cache, Cursors

Shared pool tuning – Parses, Result cache, Data dictionary

Real time Activity – Shared pool Tuning

Buffer cache tuning – TitBits

Real time Activity – Buffer cache Tuning

PGA tuning and Sort area – Titbits

Automatic memory management – Concepts

Real time Activity – PGA Tuning

Oracle I/O Architecture

Disk I/O concepts

Monitoring Oracle I/O

All about RAID

Tuning I/O – Options

ASM solutions

Important parameters

Storage considerations

Memory size planning

High Availability – Best practices

Maintenance

Top WAIT Events

Application analysis

Pro-active monitoring approach

Monitoring tools in place

Signup today and get latest Videos and Upcoming Courses for free and be the first to get notified on new updates.

Subscribe to our mailing list