Databases Reference
In-Depth Information
and monitors response times of applications and relieving bottlenecks. QoS Manage‐
ment Memory Guard determines if nodes are about to fail due to memory over-
commitment and prevents additional new connections from taking place.
A Final Note on Performance Tuning
Performance has real-world business implications. Whenever you attempt to address
performance problems, you must make sure to carefully monitor the areas that you are
attempting to improve, both before and after your changes. Important baseline data
gathered by the AWR includes application, database, operating system, disk I/O, and
network statistics.
You should use a systematic approach to both discovering the source of a performance
problem and implementing the appropriate solution. This approach calls for establish‐
ing baselines for resource usage and response time before making any changes, and only
making a small group of changes before reexamining the performance in the changed
environment. It might be tempting to simply try to fix a problem without taking a
measured approach, but this tactic will usually lead to additional problems down the
road.
