• waiting_query 

The statement that is waiting for the lock. 

• waiting_query_secs 

How long the statement has been waiting, in seconds. 

• waiting_query_rows_affected 

The number of rows affected by the statement. 

• waiting_query_rows_examined 

The number of rows read from storage engines by the statement. 

• blocking_thread_id 

The thread ID of the thread that is blocking the waiting lock. 

• blocking_pid 

The processlist ID of the thread that is blocking the waiting lock. 

• blocking_account 

The account associated with the thread that is blocking the waiting lock. 

• blocking_lock_type 

The type of lock that is blocking the waiting lock. 

• blocking_lock_duration 

How long the blocking lock has been held. 

• 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.29 The schema_table_statistics and x$schema_table_statistics Views 

These views summarize table statistics. By default, rows are sorted by descending total wait time (tables with most contention first). 

These views user a helper view, x$ps_schema_table_statistics_io . 

The schema_table_statistics  and x$schema_table_statistics  views have these columns: 

• table_schema 

The schema that contains the table. 

• table_name 

The table name. 

