SUBCLUSTER_RESOURCE_POOL_OVERRIDES
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
|
|
The name of the built-in resource pool. |
SUBCLUSTER_OID
|
|
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
|
|
The amount of memory allocated to the global resource pool. |
MAXMEMORYSIZE
|
|
Value assigned as the maximum size this resource pool can grow by borrowing memory from the |
MAXQUERYMEMORYSIZE
|
VARCHAR
|
The maximum amount of memory allocated by this pool to process any query. |