Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle Real Application Clusters (RAC) Tuning Training

© 2007-2016 by Burleson Corporation

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

   
Key Features

* Expert techniques for monitoring and tuning cluster bottlenecks.

* See how to optimize your cluster architecture for optimal performance.

* Learn secrets for monitoring transient RAC performance issues.

* See how to minimize pinging and optimizer the cache fusion interconnect.

* Understand expert tips for managing disk I/O in RAC.

* See how to expose the internal concurrency, resource coordination and locking mechanism within RAC.

* See how to tune RAC block transfers with the cache transfer views.

* Learn how to monitor RAC performance with Oracle Grid control.

* Get real-world scripts for proactive RAC and Grid performance management and exception reporting.
 

  

This is an intensive 3-day Oracle Real Application Clusters (RAC) tuning course.

Unlike other Oracle RAC tuning classes, this course is taught by a practicing RAC expert with years of experience in tuning mission-critical RAC databases. 

The course focuses on RAC disk I/O tuning, SGA tuning and tuning the cache fusion cluster interconnect.  The course will also include specialized Oracle RAC tuning script for monitoring all of the critical RAC performance areas.

This Oracle RAC training is special because this course is taught by a veteran Oracle Certified DBA with years of full-time experience.
 

  Oracle RAC Performance Tuning

Brian Peasland

Buy it here

This is an advanced Oracle Real Application Clusters tuning course that is designed for practicing Oracle professionals who have basic experience with Oracle RAC architecture and RAC administration.  While prior experience with RAC is not a firm prerequisite, experience with Oracle database administration is a plus.

This Oracle RAC Clusters tuning training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors have over a decade of real-world DBA experience in Oracle cluster technology and shares their Oracle RAC tuning secrets in this Oracle RAC tuning training.



Oracle Real Application Clusters (RAC) Tuning
Syllabus

Copyright © 2007-2016 by Donald K. Burleson

 

DAY 1
 
Introduction to RAC Tuning

Analysis of Performance Issues

Using Automated Memory Management (AMM) with RAC

Disk Monitoring and Tuning for RAC and ASM

Monitoring RAC Cluster Interconnect Performance
Undesirable Global Cache Statistics
Monitoring CURRENT Blocks
Additional Wait Events of Concern

Global Cache Service Times

GCS Monitoring
Use of the "CACHE_TRANSFER" Views
Monitoring the GES Processes
Monitoring the Global Directory

Monitoring and Tuning RAC using OEM

Configuring the Oracle Intelligent Agent With RAC
Step-By-Step Setup of the Intelligent Agents on UNIX

Monitoring RAC Using OEM

RAC Tuning Guidelines

Growth of Powerful Processors
            Why Parallel Processing?
            Opportunities for Parallelism
            Scalability
Parallel Databases
            Types of Parallelism
High Performance Computing Cluster
Oracle RAC – High Performance and Highly Available Database
 
DAY 2

 
Internals of Real Application Clusters Tuning

Overview of Cache Fusion
            Evolution of Cache Fusion
            Nature of Cache Fusion
            Benefits of Cache Fusion
            Concurrency and Consistency
            Cache Coherency
            Global Cache Service
 
SGA Components and Locking
            SGA – System Global Area
            Program Global Area (PGA)
            Buffer Cache Management
            What is a Dirty Block?
            Multi – Version Consistency Model

 

 
 
 
RAC Lock tuning Components
            Global Cache Service
            Global Enqueque Service
            Row-Level Locks
            Global Resource Directory
            RAC Processes
Resource Coordination
            Synchronization
            GCS Resource Modes and Roles
            Concept of Past Image
            Lock Modes
            Block Access Modes and Buffer States
            Cache Fusion Scenarios
            Block transfers using Cache Fusion – Examples
            Block Access, Grants, and Interrupts
Cache Fusion and Recovery tuning
            Recovery Features
            Recovery Methodology and Steps
            Recovery Process – Re-mastering
 
DAY 3

RAC Performance Monitoring and Tuning

 
Analysis of Performance Issues
            Monitoring RAC Cluster Interconnect Performance
            Use of the cache_transfer Views
            Monitoring the GES Processes
Monitoring and Tuning using OEM
            Configuring the Oracle Intelligent Agent with RAC
            Step-by-Step Setup of the Intelligent Agents on UNIX
            Monitoring RAC using OEM
 
RAC Parallel Execution
 
Overview
            Types of Parallelism
Parallelism in Oracle Relational Database
            Parallel Execution Mechanism
            Granules for Parallelism
            Parallel Execution Servers
            Degree of Parallelism – DOP
            Parallel Query: SELECT
            Parallel DML – Update, Merge, Delete
            Parallel DML – Insert…Select
            Parallel DDL Statements
            Rules for Paralleling “Create Table as Select” (CTAS)
            SQL*LOADER – Parallel Load
            Other Parallel Operations
            Initialization Parameters at a Glance
            Monitoring and Diagnosing the Parallel Execution
 
 
 
 
 

This is a BC Oracle training course (c) 2007-2016

 

   

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.