Database Administration (MOSC)

MOSC Banner

Reset resource limit max utilisation

Hi

I have a scheduled job running every 3 hours on all database which is checking v$resource_limit and report any instances where max_utilization has reached 90% of the limit.

We have process which runs maybe once a month which sometimes hits this. The only way I know to clear it is to restart the database. As this is database is required 24/7, I can't just restart it.

Is there a way that I can reset this without a DB restart.

Many thanks

James

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