RESOURCE_QUEUES
Provides information about requests pending for various resource pools.
Provides information about requests pending for various resource pools.
| Column Name | Data Type | Description |
|---|---|---|
NODE_NAME |
VARCHAR | The name of the node for which information is listed. |
TRANSACTION_ID |
INTEGER | Transaction identifier for this request |
STATEMENT_ID |
INTEGER | Unique numeric ID for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID, STATEMENT_ID uniquely identifies a statement within a session. |
POOL_NAME |
VARCHAR | The name of the resource pool |
MEMORY_REQUESTED_KB |
INTEGER | Amount of memory in kilobytes requested by this request |
PRIORITY |
INTEGER | Value of PRIORITY parameter specified when defining the pool. |
POSITION_IN_QUEUE |
INTEGER | Position of this request within the pool’s queue |
QUEUE_ENTRY_TIMESTAMP |
TIMESTAMP | Timestamp when the request was queued |