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

See Also