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.

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.

For more information on the data retrieved in this report, see The io_global_by_file_by_latency and x$io_global_by_file_by_latency Views.

Figure 30.2 Database File I/O By File

Example of the Database File I/O By File report.

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.

For more information on the data retrieved in this report, see The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency Views.

Figure 30.3 Database File I/O By Wait Type Report

Example of the Database File I/O By Wait Type report.

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

Example of the Database File I/O By Wait Type graphs.

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.

For more information on the data retrieved in this report, see The io_by_thread_by_latency and x$io_by_thread_by_latency Views.

Figure 30.5 Database File I/O By Thread

Example of the Database File I/O By Thread report.


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