MV_ RESOURCE_ POOL_ STATUS
This view contains information about the status of resource pools aggregating this information across all nodes in the cluster.
The view LMV_
provides the same resource pool status information as a local view for a specific node.
Column Name |
Description |
---|---|
|
The |
|
The name of a given resource pool. |
|
The number of queries running on a given resource pool. |
|
The number of queries queued for a given resource pool. |
|
The number of queries killed on a given resource pool. |
|
The number of queries finished on a given resource pool. |
|
The historical total queue time for a given resource pool. |
|
The historical average queue time for a given resource pool. |
|
A boolean mask showing which CPU is designated for the queries in a given resource pool. |
|
The amount of memory (in bytes) currently utilized by the associated resource pool. |
Last modified: October 8, 2025