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 |