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