RAC Performance Tuning On-Line with Arup Nanda

The “Performance Tuning in RAC” seminar is spread over 4 modules of total 8 hours and aims exclusively at training the Oracle DBA in improving the performance of the RAC system. The foundation of any tuning depends heavily on the proper diagnosis. So, this seminar starts with the building the knowledge on the RAC system, with respect to performance, and gradually prepares the student to unravel the mysteries surrounding performance issues. All the concepts will be shown with live examples and real life stories from the instructors’ experience. Students will learn how to assess the performance using various tools and techniques available in Oracle and how to use the output in developing a strategy to handle performance issues. The stress point is on the word “strategy”, as the course aims to help the student master the art of the strategy building based on evidence collected; not just a blind shot at the problem using various ad-hoc approaches.

Topics covered:

• Module 1: RAC Fundamentals
• Module 2: RAC Wait Event and Tuning
• Module 3: Measurement Techniques
• Module 4: Additional Tuning

Please Note:

This event has 1day (8 hours) length.

Audience
Course Topics Module 1 RAC Fundamentals

• What is RAC architecture
• Locking and Latching
• Buffer Cache Management
• CR Processing and Past Image
• How Cache Fusion Works
• Concept of Buffer Lock
• How Resource is Mastered

Module 2 RAC Wait Event and Tuning

• Placeholder event
• Blocking Events –vs- Grant Events
• Explanation of each event and why they occur
• How to measure Wait Events
• How to reduce these wait events

Module 3 Measurement Techniques

• Correct way to get execution plan
• Wait Interface
• Tracing using 10046 and dbms_monitor
• Consolidating tracefiles
• Hanganalyze
• Calculating the traffic over the interconnect
• Measuring performance of interconnect
• Associating AWR Reports to views

Module 4 Additional Tuning

• Sequences
• Library Cache
• Buffer Busy Waits
• Interconnect tuning
• Parallel Query Tuning
• Issues on one instance causing the issue on the other

Course Objectives

• Understand the various areas of RAC that contribute to performance
• Learn how to assess the performance of each component
• Understand how the Cache Fusion really works not how it is advertised
• Learn how to develop a plan of attack
• Learn how to use correct application design to avoid RAC issues
• Understand the need for changed practices in RAC environment