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 and maintenance profiles cannot be dropped.