SET SESSION RESOURCE_POOL
Associates the user session with the specified resource pool.
Syntax
SET SESSION RESOURCE_POOL = { pool-name | DEFAULT }
Parameters
| pool‑name |
The name of an existing resource pool to associate with the current session. |
DEFAULT
|
Sets the session's resource pool to the user's default resource pool. |
Privileges
- Superusers can assign their session to any available resource pool.
- Non-superusers must have USAGE privileges for the resource pool.
Examples
This example sets ceo_pool as the session resource pool:
=> SET SESSION RESOURCE_POOL = ceo_pool; SET