Oracle 10g – How to prevent one user from hogging all resources?

Posted on

Question :

I am wondering if there is any way to limit how much resources one user can take on my Oracle system. I want to limit some queries and systems from being able to hog all system resources when they run non optimized queries.

Answer :

There is a built-in utility called Resource Manager exactly for that purpose:

If you’re looking for something simpler than the resource manager, try Profiles.

I haven’t had much success with the resource manager. In my experience with it I’ve found that it’s easier to give priority over resources to certain users than to limit users.

Leave a Reply

Your email address will not be published. Required fields are marked *