Keyword: WAIT
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| DBA_WAITERS | |
| GV$SESSION_WAIT | Synonym for GV_$SESSION_WAIT |
| V$SESSION_WAIT | Synonym for V_$SESSION_WAIT |
Columns
| Column Name | Description |
|---|---|
| AVERAGE_WAIT (V$SYSTEM_EVENT) | |
| AVERAGE_WAIT (V$SESSION_EVENT) | |
| AVERAGE_WAIT (GV$SYSTEM_EVENT) | |
| AVERAGE_WAIT (V$AQ1) | |
| AVERAGE_WAIT (GV$AQ1) | |
| AVERAGE_WAIT (V$AQ) | |
| AVERAGE_WAIT (GV$AQ) | |
| AVERAGE_WAIT (GV$SESSION_EVENT) | |
| BUFFER_BUSY_WAIT (GV$BUFFER_POOL_STATISTICS) | |
| BUFFER_BUSY_WAIT (V$BUFFER_POOL_STATISTICS) | |
| CPU_WAITS (GV$RSRC_CONSUMER_GROUP) | |
| CPU_WAITS (V$RSRC_CONSUMER_GROUP) | |
| CPU_WAIT_TIME (GV$RSRC_CONSUMER_GROUP) | |
| CPU_WAIT_TIME (V$RSRC_CONSUMER_GROUP) | |
| CUM_WAIT_TIME (GV$ENQUEUE_STAT) | |
| CUM_WAIT_TIME (V$ENQUEUE_STAT) | |
| EXECUTION_WAITERS (GV$RSRC_CONSUMER_GROUP) | |
| EXECUTION_WAITERS (V$RSRC_CONSUMER_GROUP) | |
| FREE_BUFFER_WAIT (GV$BUFFER_POOL_STATISTICS) | |
| FREE_BUFFER_WAIT (V$BUFFER_POOL_STATISTICS) | |
| LOG_SWITCH_WAIT (GV$INSTANCE) | |
| LOG_SWITCH_WAIT (V$INSTANCE) | |
| LONG_WAITS (V$BACKUP_ASYNC_IO) | |
| LONG_WAITS (GV$BACKUP_ASYNC_IO) | |
| LONG_WAIT_TIME_MAX (V$BACKUP_ASYNC_IO) | |
| LONG_WAIT_TIME_MAX (GV$BACKUP_ASYNC_IO) | |
| LONG_WAIT_TIME_TOTAL (V$BACKUP_ASYNC_IO) | |
| LONG_WAIT_TIME_TOTAL (GV$BACKUP_ASYNC_IO) | |
| MAX_WAIT (GV$SESSION_EVENT) | |
| MAX_WAIT (V$SESSION_EVENT) | |
| ROW_WAIT_BLOCK# (GV$SESSION) | |
| ROW_WAIT_BLOCK# (V$SESSION) | |
| ROW_WAIT_FILE# (GV$SESSION) | |
| ROW_WAIT_FILE# (V$SESSION) | |
| ROW_WAIT_OBJ# (V$SESSION) | |
| ROW_WAIT_OBJ# (GV$SESSION) | |
| ROW_WAIT_ROW# (GV$SESSION) | |
| ROW_WAIT_ROW# (V$SESSION) | |
| SECONDS_IN_WAIT (V$SESSION_WAIT) | |
| SECONDS_IN_WAIT (GV$SESSION_WAIT) | |
| SHORT_WAITS (GV$BACKUP_ASYNC_IO) | |
| SHORT_WAITS (V$BACKUP_ASYNC_IO) | |
| SHORT_WAIT_TIME_MAX (V$BACKUP_ASYNC_IO) | |
| SHORT_WAIT_TIME_MAX (GV$BACKUP_ASYNC_IO) | |
| SHORT_WAIT_TIME_TOTAL (V$BACKUP_ASYNC_IO) | |
| SHORT_WAIT_TIME_TOTAL (GV$BACKUP_ASYNC_IO) | |
| TCKT_WAIT (GV$DLM_TRAFFIC_CONTROLLER) | |
| TCKT_WAIT (V$DLM_TRAFFIC_CONTROLLER) | |
| TIME_WAITED (GV$SESSION_EVENT) | |
| TIME_WAITED (V$SYSTEM_EVENT) | |
| TIME_WAITED (V$SESSION_EVENT) | |
| TIME_WAITED (GV$SYSTEM_EVENT) | |
| TIME_WAITED_MICRO (GV$SYSTEM_EVENT) | |
| TIME_WAITED_MICRO (V$SESSION_EVENT) | |
| TIME_WAITED_MICRO (V$SYSTEM_EVENT) | |
| TIME_WAITED_MICRO (GV$SESSION_EVENT) | |
| TOTAL_WAIT (GV$AQ1) | |
| TOTAL_WAIT (V$AQ) | |
| TOTAL_WAIT (V$AQ1) | |
| TOTAL_WAIT (GV$AQ) | |
| TOTAL_WAIT# (V$ENQUEUE_STAT) | |
| TOTAL_WAIT# (GV$ENQUEUE_STAT) | |
| TOTAL_WAITS (GV$SESSION_EVENT) | |
| TOTAL_WAITS (V$SYSTEM_EVENT) | |
| TOTAL_WAITS (GV$SYSTEM_EVENT) | |
| TOTAL_WAITS (V$SESSION_EVENT) | |
| TOTAL_WAIT_COMMITS (GV$STREAMS_APPLY_COORDINATOR) | |
| TOTAL_WAIT_COMMITS (V$STREAMS_APPLY_COORDINATOR) | |
| TOTAL_WAIT_DEPS (V$STREAMS_APPLY_COORDINATOR) | |
| TOTAL_WAIT_DEPS (GV$STREAMS_APPLY_COORDINATOR) | |
| WAIT (V$QUEUE) | |
| WAIT (GV$QUEUE) | |
| WAITERS_WOKEN (V$LATCH) | |
| WAITERS_WOKEN (GV$DLM_LATCH) | |
| WAITERS_WOKEN (V$LATCH_CHILDREN) | |
| WAITERS_WOKEN (V$DLM_LATCH) | |
| WAITERS_WOKEN (GV$LATCH_CHILDREN) | |
| WAITERS_WOKEN (GV$LATCH) | |
| WAITERS_WOKEN (V$LATCH_PARENT) | |
| WAITERS_WOKEN (GV$LATCH_PARENT) | |
| WAITING (GV$AQ) | |
| WAITING (V$AQ) | |
| WAITING (V$AQ1) | |
| WAITING (GV$AQ1) | |
| WAITING_SESSION (DBA_WAITERS) | |
| WAITS (V$PQ_TQSTAT) | |
| WAITS (GV$ROLLSTAT) | |
| WAITS (GV$PQ_TQSTAT) | |
| WAITS (V$ROLLSTAT) | |
| WAITS_HOLDING_LATCH (GV$DLM_LATCH) | |
| WAITS_HOLDING_LATCH (GV$LATCH) | |
| WAITS_HOLDING_LATCH (GV$LATCH_PARENT) | |
| WAITS_HOLDING_LATCH (V$DLM_LATCH) | |
| WAITS_HOLDING_LATCH (V$LATCH) | |
| WAITS_HOLDING_LATCH (V$LATCH_PARENT) | |
| WAITS_HOLDING_LATCH (GV$LATCH_CHILDREN) | |
| WAITS_HOLDING_LATCH (V$LATCH_CHILDREN) | |
| WAIT_COUNT (V$FILESTATXS) | |
| WAIT_COUNT (V$TEMPSTATXS) | |
| WAIT_TIME (V$SESSION_WAIT) | |
| WAIT_TIME (V$LATCH_CHILDREN) | |
| WAIT_TIME (V$LATCH) | |
| WAIT_TIME (GV$LATCH_CHILDREN) | |
| WAIT_TIME (V$LATCH_PARENT) | |
| WAIT_TIME (GV$LATCH) | |
| WAIT_TIME (GV$LATCH_PARENT) | |
| WAIT_TIME (GV$SESSION_WAIT) | |
| WAIT_TIME (V$DLM_LATCH) | |
| WAIT_TIME (GV$DLM_LATCH) | |
| WRITE_COMPLETE_WAIT (V$BUFFER_POOL_STATISTICS) | |
| WRITE_COMPLETE_WAIT (GV$BUFFER_POOL_STATISTICS) |