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 and users who have been granted CONTROL WLM ON SYSTEM 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.