开发者

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

开发者 https://www.devze.com 2022-12-22 07:35 出处：网络

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

相关专题：oracle oracle10g performance report throttling

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?

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.

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.