DROP WLM RESOURCE POOL

Drop a workload management (WLM) resource pool.

DROP WLM RESOURCE POOL [ IF EXISTS ] name

Only superusers can create, alter, and drop WLM resource pools. When you drop a WLM profile, its associated resource pools and rules are dropped.

IF EXISTS: Do not return a warning if the resource pool does not exist.
name: The pool name must match the name of an existing resource pool in the database.

For example:

premdb=# drop wlm resource pool longest_pool;
DROP WLM RESOURCE POOL

Query the sys.wlm_active_pool view to see the current pools in the system.

Note: The default and admin resource pools cannot be dropped.