Reset support key values to DEFAULT using query

1

Hi,

We are currently using the query “ALTER SYSTEM set key=” to customize support key values whenever needed. However, we are not tracking the replaced value and if ever need be, is there a way to revert the support key values to DEFAULT in case we want to?

2

@jerickoramilo

ALTER SYSTEM RESET <support key name>

Example:

ALTER SYSTEM RESET planner.verbose_profile

Thanks
Bali

1 Like