Is there a way to throttle or limit resources used by a user in Oracle?

Question

I have a multi-user web application and am encountering issues when a third party reporting application queries my Oracle 10g database.

The reporting queries are slowing the system and impacting all other users.

Is there a way to throttle this user's session so their queries don't impact the other users?

Answer 1

AFAIK, you can only throttle sessions based on CPU in 10g, which usually isn't the problem with long running queries. The most useful thing would be limits placed on disk I/O, which it appears is now available in 11g in the Database Resource Manager.

Answer 2

Hi bitstream,

you can use the Database Resource Manager to manage workload. Have a look at the Oracle documentation or at this example from Joel Kallman's APEX blog.