SET SESSION RESOURCE_POOL
Associates the user with the specified 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