 |
|
Oracle Brain Cramps? How simple mistakes can cripple your database
Oracle Tips by Burleson Consulting |
Full Presentation
published at Oracle OpenWorld 2006
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 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. This is a do-not-miss session for anyone who
wants to understand how small changes can have a dramatic impact
on Oracle performance.
Key points
include:
-
Understand
common disk problems
-
Watch out
for those optimizer settings
-
See legacy
issues with 10g upgrades
-
See “Silly”
Oracle configurations
-
See what
happens when you forget to take your DBA training
