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 |