SUBCLUSTER_RESOURCE_POOL_OVERRIDES

Displays subcluster-level overrides of settings for built-in global resource pools.

Displays subcluster-level overrides of settings for built-in global resource pools.

Column Name Data Type Description
POOL_OID INTEGER Unique identifier for the resource pool with settings overrides.
NAME VARCHAR The name of the built-in resource pool.
SUBCLUSTER_OID INTEGER Unique identifier for the subcluster with settings that override the global resource pool settings.
SUBCLUSTER_NAME VARCHAR The name of the subcluster with settings that overrides the global resource pool settings.
MEMORYSIZE VARCHAR The amount of memory allocated to the global resource pool.
MAXMEMORYSIZE VARCHAR Value assigned as the maximum size this resource pool can grow by borrowing memory from the GENERAL pool.
MAXQUERYMEMORYSIZE VARCHAR The maximum amount of memory allocated by this pool to process any query.