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 15 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 creativity and design process) …..  Thanks for all your great work and your dedication to sharing your skills and knowledge with us. Hats off to The Skill Pedia!Read more

Karen Cadman

Sr. Web Designer

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

top
WhatsApp chat

SPECIAL OFFER!

 Avail 50% Discount on all Courses!  Offer Expiring on 24th Sept.

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.
X