sys Schema Views • sql_kill_blocking_query • sql_kill_blocking_connection The  KILL  statement to execute to kill the blocking statement. The  KILL  statement to execute to kill the session running the blocking statement. These views summarize I/O consumers to display time waiting for I/O, grouped by thread. By default, rows are sorted by descending total I/O latency. The  io_by_thread_by_latency  and  x$io_by_thread_by_latency  views have these columns: 28.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views • user • total • total_latency • min_latency • avg_latency • max_latency • thread_id • processlist_id For foreground threads, the account associated with the thread. For background threads, the thread name. The total number of I/O events for the thread. The total wait time of timed I/O events for the thread. The minimum single wait time of timed I/O events for the thread. The average wait time per timed I/O event for the thread. The maximum single wait time of timed I/O events for the thread. The thread ID. For foreground threads, the processlist ID of the thread. For background threads,  NULL . These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The  io_global_by_file_by_bytes  and  x$io_global_by_file_by_bytes  views have these columns: 28.4.3.11 The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Views • file The file path name. 5149