Database Reference
In-Depth Information
Chapter 11:
Oracle Performance Tuning
Oracle Performance Tuning, the topic is not that scary as it
sounds. Actually it's very simple if you understand the
performance tuning concept -the bigger picture or in other words
bird's eye view. Performance tuning is nothing but the collection
of statistics regarding the current status of the system and then
changing system values based on the statistics analysis outcome
to enhance the performance. In other words performance tuning
is
•
Collection of system statistics
•
Identifying the problematic areas
•
Changing system based on the statistics
You can collect statistics using the built-in DBMS_STATS
PL/SQL Package or through EM Database Control. In this
chapter we will be using EM Database Control as a primary tool
for Oracle system performance tuning.
Search WWH ::
Custom Search