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. Non-superusers must have USAGE privileges on the specified resource pool.

DEFAULT

Sets the session's resource pool to the resource pool assigned to this user.

Privileges

None

Examples

This example sets ceo_pool as the session resource pool:

=> SET SESSION RESOURCE_POOL = ceo_pool;
SET

See also

• ALTER RESOURCE POOL
• CREATE RESOURCE POOL
• CREATE USER
• DROP RESOURCE POOL
• GRANT (Resource pool)
• SET SESSION MEMORYCAP
• Managing workloads