sys Schema Views • 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. 5164