Oracle DB Performance Tuning 11g

Home > Courses > 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

Download Oracle Performance Tuning Brochure

Course Content

Section 1: ORACLE DATABASE ARCHITECTURE – TUNING CENTRIC

Software functionality

OS Dependencies

Background processes – To concentrate

Storage and Memory dependencies

Section 2: PERFORMANCE TUNING TOOLS

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

Section 3: ORACLE OPTIMIZER

Basics of Optimizer

Understanding behaviour

Histograms and Bind Peeking

Access paths

Interpreting JOINS

Optimizer statistics

Hints

Manage Optimizer

Section 4: SQL TUNING WITH ACTIVITIES- 1

Thumb rules

Possible SQL issues

.SQL Tuning methods and Tools

Pro-active SQL Tuning

Reactive SQL Tuning

Real-Time Tuning Examples

Section 5: SQL TUNING WITH ACTIVITIES – 2

SQL tuning examples (Continue)

Creating SQL tuning sets and baselines

Tuning JOINS

Sorting and Grouping activities

PL/SQL tuning notes

Parallelism in SQL

Section 6: REAL TIME DATA LOADING AND MONITORING

Creating SCHEMAS, TABLES

Preparing Environment

Load Data-1

Monitor using OEM & Alert log

Load Data-2

Monitor using V$ views

Section 7: REAL TIME – AWR REPORT ANALYSIS

Preparing environment

Load Data-3

Generate AWR reports

Analysis & Problem Identification

Fixing Performance Issue

Section 8: REPORTS & ANALYSIS

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

Section 9: DATABASE STORAGE OBJECTS

Storage options

Oracle Partitioning

Star schema design

Partitioning Examples

Indexes Overview

B-Tree Indexes & Examples

BitMap Indexes & Examples

Index Organized Tables & Examples

Section 10: ADVISORIES

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

Section 11: INSTANCE/MEMORY REAL TIME TUNING

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

Section 12: I/O TUNING

Oracle I/O Architecture

Disk I/O concepts

Monitoring Oracle I/O

All about RAID

Tuning I/O – Options

ASM solutions

Section 13: BEST ARCHITECTURAL PRACTICES

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 be the first to get notify on latest videos and upcoming batches.

Subscribe to our mailing list