Oracle Performance Tuning Course

    • 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, 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
    • 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
    • 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, 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

    Course Curriculum

    No curriculum found !

    Course Reviews


    1 ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    Become an Instructor

    WhatsApp chat