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.