456: Brain Cramps: How simple mistakes can cripple your database
Donald Burleson , Burleson Oracle Consulting and Training    Biography

Objectives: See legacy issues with 11g upgrades
See what happens when you forget to take your DBA training
Understand common configuration problems
Abstract: It’s amazing how simple unobtrusive mistakes can cripple your database. Oracle 10g is the world most robust and flexible database and it’s not uncommon to find inappropriate configurations that perform miserably. This presentation will draw from real-world consulting experiences and show actual examples of Oracle brain cramps and how to detect and correct the most common Oracle performance issues.

This presentation explores some of the root causes of Oracle performance bottlenecks and offers specific advice for detecting and correcting sub-optimal configurations. Drawn from real-word experiences with actual examples, this presentation shows how simple mistakes in global Oracle settings can have unforeseen side effects. Examples will include sub-optimal initialization parameters, inappropriate parameters for tables & indexes, SQL optimizer traps and external issues such as disk and network configurations.

Audiernce Focus: Application Server Administrator
Expertise: Beginner
Track: Database
Date: Wednesday, April 16, 2008
Time: 1:30 PM - 2:30 PM