301: 10g Tuning – Tuning Oracle has Radically Changed
Rich Niemiec , TUSC    Biography

Objectives: Learn to tune Oracle better
Learn how AWR Report can help
Learn how Grid Control can help
Abstract: This presentation is a look at tuning Oracle10g. We will take a brief look at Oracle over the years and demonstrate their current direction with 10g. We also look at RAC and how it can prepare you for moving to grid computing. We will look at how Enterprise Manager lets you manage the entire environment and some other tuning features. We will also go over statspack tuning in detail showing how to use statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events, latch waits, top SQL, instance activity, file i/o issues. Lastly, we'll look at some helpful V$ views and X$ tables when you need to dig deeper that can help as well.

I. Oracle...Always in the fast Lane a. Why Oracle? b. Oracle Innovation II. Consolidation a. Moving to centralized computing b. Cost savings c. Where grid fits in III. Grid Computing and 10g new features a. Data Pump b. Rename Tablespace c. DBMS_ADVANCED_REWRITE d. Flush

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Monday, April 14, 2008
Time: 9:15 AM - 11:30 AM