Oracle Expert Seminar

30 April 2012

1
Register Now!
1

Please mention this code
at the time of booking: E1044

divline

About
Oracle University
Expert Seminars:

Oracle University Expert Seminars are exclusive events delivered by top Oracle experts with years of experience in working with Oracle products.

divline
ical Save the date
fb Visit our Facebook page
twitter Follow us on Twitter
linkedin Join our LinkedIN Group
linkedin Find us on Google+

divline

About the trainer:

Arup Nanda


Arup NandaArup Nanda has been an Oracle DBA for more than 14 years working on all aspects of Oracle database from modeling, performance tuning, backup, disaster recovery to security.


“Planning to use this knowledge at work. Very good teacher, high level of knowledge”


“Instructor was really knowledgeable and a strong expert on his topics. Not every day is it possible to learn from the best.”


“I like that he insists to make everything clear and I like the power he tries to give to students.”


 

RAC Performance Tuning

About this seminar:

Due to popular demand, Oracle University has rescheduled this exclusive online training delivered by Arup Nanda, one of Oracle's database experts. This online seminar consists of four modules

of about two hours each and will cover advanced concepts in RAC Performance Tuning. All concepts will be illustrated with examples and real-life stories from the instructor’s personal experience.

1
Register Now!
1

Why you should attend this seminar:

  • You will learn how to use correct application design to avoid RAC issues
  • You will understand the various areas of RAC that contribute to performance
  • You will learn how to assess the performance of each component
  • You will understand how the Cache Fusion really works, not how it is advertised

The following topics
will be covered in this seminar:

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

What’s next?

More courses on Oracle Database 11g:

ORACLE DATABASE 11G: RAC ADMINISTRATION RELEASE 2

ORACLE 11G: RAC AND GRID INFRASTRUCTURE ADMINISTRATION ACCELERATED RELEASE 2

For a full list of Oracle Seminars near you or on line click here

Please mention this code at the time of booking: E1044

Hardware and Software, Engineered to Work Together Oracle University
Copyright © 2012, Oracle and/or its affiliates.
All rights reserved.
Contact Us | Legal Notices and Terms of Use | Privacy Statement
   
SEV100056750