RESOURCE_QUEUES
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 |