10. Database Forensics and Tuning Using AWR Analysis: Part II

Chapter 9 covered the review and analysis of the first half of the Automatic Workload Repository (AWR) report. In this chapter, we complete this analysis.

Tablespace I/O Statistics

The next section of the AWR report deals with the tablespace I/O statistics. There are two parts to the tablespace I/O statistics: the first part rolls up the I/O statistics by tablespace, and the second lists the statistics by datafile, as each tablespace may have multiple datafiles associated with it. Listing 10.1 shows an example of this section of the report.

Listing 10.1 Tablespace I/O Statistics Section

Click here to view code image

Tablespace IO Stats                  DB/Inst: AULTDB/aultdb1  Snaps: ...

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.

Start your free trial