dbms_resource_manager Archives

Limiting I/O and CPU resources using 11g Oracle Resource Manager

Post author:Amit Bansal
Post published:1 September, 2012
Post category:11g / Performance
Post comments:6 Comments

Recently I was working on using Oracle DBMS_RESOURCE_MANAGER to limit resources usage by read-only queries. This was required to prevent long running ad-hoc and poorly written queries.Instead of writing custom…