26.4.3.12 The io_global_by_file_by_latency and x$io_global_by_file_by_latency Views
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. By default, rows are sorted by descending total latency.
The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns:
-
fileThe file path name.
-
totalThe total number of I/O events for the file.
-
total_latencyThe total wait time of timed I/O events for the file.
-
count_readThe total number of read I/O events for the file.
-
read_latencyThe total wait time of timed read I/O events for the file.
-
count_writeThe total number of write I/O events for the file.
-
write_latencyThe total wait time of timed write I/O events for the file.
-
count_miscThe total number of other I/O events for the file.
-
misc_latencyThe total wait time of timed other I/O events for the file.
© 2025 Oracle
Licensed under the GPLv2 License.
