Oracle Performance Tuning Course

29,000.00 per 90 days

  • 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
SUBSCRIPTION FOR 3 months
Category:

Description

  • 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

Reviews

There are no reviews yet.

Be the first to review “Oracle Performance Tuning Course”

Featured Testimonial

The experience with The SkillPedia from start to finish was faultless. I can see why your online learning portal is called this name! Read more

Rebecca Johnson

Sybase DBA

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