Oracle Database 10g Performance Tuning Tips & Techniques

CHAPTER 15Performing a Quick System Review (DBA)

Oracle 10g introduced many new features that can be leveraged for tuning. While some DBAs are great at planning and implementing a new version, few are good at evaluating and implementing the new features that will help their system. With the introduction of the Automatic Workload Repository (AWR) and the AWR Report (see Chapter 14 for differences with STATSPACK), you can monitor your system in different ways. And with the advent of the Tuning Advisor, comes different ways to fix your system. One of the keys to a good system review is checking to see if you've implemented the features that fit your needs and have a good return on the cost of the feature as well as the time it takes to implement ...