Oracle Performance Tuning Course

Oracle Performance Tuning Course for Oracle DBAs.

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
Summary
Education
5.0
5 based on 8 votes
Online Training
Education
The Skill Pedia
The Skill Pedia,
S-8, Malik Buildcon Plaza-II, Plot No. 6, Pocket 5, Sector 12, Dwarka,Delhi-110078,
Telephone No.+919312406920
India
World
Online Courses for Professionals
The Oracle Performance Tuning Course is designed for professionals who have more than 5 Years of Working Experience as Oracle DBA.
July 24, 2019

0 responses on "Oracle Performance Tuning Course"

Leave a Message

Featured Testimonial

I think the course was excellent for someone like me (Web Designer working on always improving...Read more

Karen Cadman

Sr. Web Designer

Certificate Code

Who’s Online

There are no users currently online

Last Tweets

Error retrieving tweets
top
WhatsApp chat
X