DROP WLM PROFILE
Drop a workload management (WLM) profile.
DROP WLM PROFILE [ IF EXISTS ] name
This command also drops resource pools and rules associated with the profile. Only superusers can create, alter, and drop WLM profiles.
- IF EXISTS
- Do not return a warning if the profile does not exist.
- name
- The profile name must match the name of an existing profile in the database.
For
example:
premdb=# drop wlm profile myprofile;
DROP WLM PROFILE
Query the sys.wlm_active_profile
view to see the current profiles in the system
and which profile is active.
Note: The
default
, flex
, and maintenance
profiles cannot be dropped.