在Oracle中有没有办法限制或限制用户使用的资源? [英] Is there a way to throttle or limit resources used by a user in Oracle?

问题描述

我有一个多用户Web应用程序，当第三方报告应用程序查询我的Oracle 10g数据库时遇到问题.

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?

推荐答案

，您可以使用 Oracle文档或在来自Joel Kallman的APEX博客的示例.

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.

这篇关于在Oracle中有没有办法限制或限制用户使用的资源?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！