Oracle Performance Tuning Course  - Join Now

The Oracle Performance Tuning Course is designed for professionals who have more than 5 Years of Working Experience as Oracle DBA.

  • Introduction
    • Introduction to Linux
    • Oracle Virtual Box Installation and Linux Machine Import
    • Installation of Oracle on Linux
  • Getting Started
    • Linux Commands Revision cp, mv, service, vi editor, cat, more, tail, wc, fd, du, path, history, find etc.
    • Getting started with Oracle on Linux
    • Important Linux Commands, Service Configuration
    • SQL Developer connecting to linux
  • Oracle Architecture
    • Oracle Memory Architecture
    • Oracle Physical Architecture
    • Performance & Tuning: Overview & Goals
    • Tuning The Shared Pool
    • Tuning The Buffer Cache
  • Control Files

Day 2

  • Redo files
    • Archive Log
    • No Archive Log
  • Oracle Physical Architecture
    • Tablespaces
    • Data files
    • Blocks
    • Extents
  • Oracle Result Cache
    • Query Result Cache
    • Function Result Cache
  • Oracle Transactions and Locks
    • Transactions
    • Isolation Levels in Oracle
    • MVCC
    • Deadlocks

Day 3

  • Oracle Indexes
    • B-Tree Indexes
    • Bitmap Indexes
    • Functional Indexes
    • Invisible Indexes
  • Query Plans
    • Actual Query Plan
    • Estimated Query Plan
    • Query Statistics
    • Optimizer Modes: Rules vs Cost Based
    • Managing Statistics
    • SQL Optimization Using TKProf

Day 4

  • Oracle Table Partitioning
    • Range Partitioning
    • List Partitioning
    • Hash Partitioning
    • Interval Partitioning
    • Referential Partitioning
  • Oracle Index Partitioning
    • Local Indexes
    • Global Indexes
    • Global Partitioned Indexes
  • Tuning SGA Structure Oracle Query Hints
    • Tuning SGA Structure
    • Automatic Shared Memory
    • SQL Hints
    • Monitoring & Re-Constructing Indexes
    • Monitoring Triggers & Constraints
    • Tuning Disk I/O

Day 5

  • SQL Trace Utility
  • Materialized Views
    • Static Materialized Views
    • Refreshable Materialized Views
    • SQL Optimization Using Explain Plan
    • SQL Optimization Using Auto Trace
  • Advanced Performance Tuning
    • Tuning PGA & Temporary Space
    • Generating STATSPACK Reports
    • Generating UTLBSTAT & UTLESTAT
    • Introduction To SQL Tunning