Related Documentation Download this Manual

30.2.2 Database File I/O Graphs and Reports

This section describes the Database File I/O reports and graphs.

Each tab contains the following common elements:

  • Show n Entries: Number of entries to show per page.

  • Search: search the contents of the page.

  • Show/Hide Columns: enables you to change the column set displayed on the page by selecting or deselecting the columns.

  • Page Navigation: buttons enabling you to navigate the pages of the report.

For more information on the data retrieved in these reports, see the XREFTO REFMAN.

I/O By File

Shows the top global I/O consumers by latency, and by file. The data is retrieved from sys.x$io_global_by_file_by_latency, and sorted by total latency by default.

Figure 30.2 Database File I/O By File

Database File IO report, by File tab

I/O By Wait Type

Shows the top global I/O consumers by latency. The data is retrieved from sys.x$io_global_by_wait_by_latency, and sorted by total latency, by default.

This report is a combination of report and graphs. The graphs can be redrawn based on a time range. To change the time range, select one of the range buttons. Values range from 1 hour to 1 week.

Figure 30.3 Database File I/O By Wait Type Report

Database File IO report, By Wait Type tab

The following shows a subset of the graphs available on the I/O By Wait Type tab:

Figure 30.4 Database File I/O By Wait Type Graphs

Database File IO graphs, By Wait Type tab

I/O By Thread

Shows the top I/O consumers by thread, ordered by total latency. The data is retrieved from sys.x$io_by_thread_by_latency, and sorted by latency, by default.

Figure 30.5 Database File I/O By Thread

Database File IO report, By Thread tab


User Comments
Sign Up Login You must be logged in to post a comment.