Twelve Silver Bullets For
Oracle Performance Tuning
"Contrary to the
pontifications of
theoreticians and
ivory-tower academics, there
are many silver bullets for
Oracle performance tuning.
By silver bullet, I mean a
small set of commands that
quickly relieves an acute
performance bottleneck. Some
of these techniques of
just-in-time tuning have
been codified in Oracle10g
with the Automatic Memory
Management (AMM) facility,
in which the SGA regions are
changed dynamically to meet
changing demands in
processing."
writes Don Burleson for
dbazine.com. So what are
they?
According to Don:
-
Fix
missing CBO statistics
-
Replace
an obsolete statistics
gathering method
-
Initialize missing
Oracle instance
parameters
-
Add
missing indexes
-
Implement cursor_sharing=force
-
Implement the KEEP pool
for small-table
full-scanned tables
-
Change
the CBO optimizer
parameters
-
Add
additional SGA RAM
-
Employ
materialized views
-
Create
bitmap indexes
-
Add
freelists
-
Windows
Oracle issues
Check out the article
for full details.
