9. Database Forensics and Tuning Using AWR Analysis: Part I
Oracle utilities such as Statspack and Automatic Workload Repository (AWR) reports provide the database administrator (DBA) or tuner detailed information concerning a snapshot of database execution time. This snapshot provides statistics on wait events, latches, storage input and output volumes and timings, as well as various views of memory and SQL activities.
The statistics and insights into the memory, I/O, and SQL performance characteristics are invaluable aids in determining whether a database is functioning optimally. Unfortunately, there is such a plethora of data in most AWR reports that DBAs often feel overwhelmed and may miss important clues about database performance issues. ...
Get Oracle Database Problem Solving and Troubleshooting Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
