Database Administration (MOSC)

MOSC Banner

Is there some workaround to disable resource manager in Oracle standard edition?

edited Nov 25, 2022 7:42AM in Database Administration (MOSC) 7 commentsAnswered

We are facing the exact problem of the documment Resmgr:cpu Quantum Waits (Doc ID 2713834.1).

The problem is that several sessions were active waiting for Resmgr:cpu Quantum event (last time were 80 sessions), and it increases the load average of the machine, also affecting other instances in the same machine.

Is there any workaround for it? Oracle does not allow disable resource manager.

alter system set resource_manager_plan = ''
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager

Maybe not disable resource_manager_plan parameter, but change other configuration?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center