RESOURCE_POOL_STATUS

Provides current state of built-in and user-defined resource pools on each node. 提供每个节点上内置和用户自定义资源池的当前状态。

图例

• ✅ = 字段存在于该版本
• ❌ = 字段不存在于该版本
• 备注列标注首次出现或类型变更的版本

字段名	Data Type	11.0.x	11.1.x	12.0.x	23.3.x	23.4.x	24.1.x	24.2.x	24.3.x	24.4.x	25.1.x	25.2.x	25.3.x	25.4.x	26.1.x	26.2.x	备注
CPU_AFFINITY_MASK	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CPU_AFFINITY_MODE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CPU_AFFINITY_SET	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
EXECUTION_PARALLELISM	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
GENERAL_MEMORY_BORROWED_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
IS_INTERNAL	BOOLEAN	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
IS_STANDALONE	BOOLEAN	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
MAX_CONCURRENCY	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
MAX_MEMORY_SIZE_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
MAX_QUERY_MEMORY_SIZE_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
MEMORY_INUSE_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
MEMORY_SIZE_ACTUAL_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
MEMORY_SIZE_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
NODE_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PLANNED_CONCURRENCY	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
POOL_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
POOL_OID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PRIORITY	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
QUERY_BUDGET_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
QUEUEING_THRESHOLD_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
QUEUE_TIMEOUT	INTERVAL	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
QUEUE_TIMEOUT_IN_SECONDS	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
RUNNING_QUERY_COUNT	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
RUNTIMECAP_IN_SECONDS	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
RUNTIME_PRIORITY	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
RUNTIME_PRIORITY_THRESHOLD	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
SINGLE_INITIATOR	BOOLEAN	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅