||Oracle Tips by Burleson
Database internals tuning is a complex
topic. Just when you think you have Oracle internals figured out,
Oracle slips in some new features, takes old ones away, or, just for
some perverse form of fun, changes the structures of tried-and-true
tables and views. Actually it is all a secret plot between senior
Oracle DBAs and Oracle to maintain job security.
This section will cover one of the more
challenging and critical aspects of the DBA job: analyzing,
diagnosing, and fixing database internals performance problems. The
last chapter discussed application tuning. You will get a majority
of the performance gains in an application from proper database
configuration and application tuning. However, where you will be
most exposed will be in the area of internals tuning. Squeezing that
last bit of performance from the database seems to be the one area
managers like to focus on (they forgot the bit about application
tuning and now expect you to work miracles) when there are problems.
This is an excerpt by Mike Ault’s book “Oracle9i
Administration & Management” . If you want more current Oracle
tips by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s
Oracle Scripts Download.