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.