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.

    Featured Testimonial

    The level and nature of course coverage was simply exceptional, concrete exercise, concrete examples, excellent analysis and evaluation and certification in the end. The time flew by!Read more

    Fedrick Y.

    PHP Developer

    Popular Courses

    About The SkillPedia

    The Skill Pedia is a platform for online training. It offers great learning experience for learners by offering features such as Interactive Videos, Interaction with Trainer, Assignments, Rich Audio Visuals and Handouts.

    The Course Completion Certificate generated automatically based on your performance after the course is complete is an edge.

    For Trainers, it is a platform for sharing your Skills which may be in the form of videos, slides, handouts, e-books or even consulting and get up to 85% of the fee you decide for the course.

    The Skill Pedia - Learn or Teach a Skill

    TheSkillPedia Tweets

    WhatsApp chat


    This Offer is Limited!  Avail 50% Discount on all Courses!

    You have successfully subscribed to the newsletter

    There was an error while trying to send your request. Please try again.

    The Skill Pedia will use the information you provide on this form to be in touch with you and to provide updates and marketing.