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

See Also