• sql_kill_blocking_query 

The KILL  statement to execute to kill the blocking statement. 

• sql_kill_blocking_connection 

The KILL  statement to execute to kill the session running the blocking statement. 

## 28.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views 

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: 

• user 

For foreground threads, the account associated with the thread. For background threads, the thread name. 

• total 

The total number of I/O events for the thread. 

• total_latency 

The total wait time of timed I/O events for the thread. 

• min_latency 

The minimum single wait time of timed I/O events for the thread. 

• avg_latency 

The average wait time per timed I/O event for the thread. 

• max_latency 

The maximum single wait time of timed I/O events for the thread. 

• thread_id 

The thread ID. 

• processlist_id 

For foreground threads, the processlist ID of the thread. For background threads, NULL . 

## 28.4.3.11 The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Views 

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: 

• file 

The file path name. 

