Re: Limit I/O per session

"pz" <pz_at_xx.interia.pl> wrote in message news:c3rmjp$25bf$1_at_news2.ipartners.pl...
> Hi again,
>
> when I use RESOURCE_LIMIT and my session exceeded limit (ie
> LOGICAL_READS_PER_CALL) session is killed.
> My session have to read a lot of data. My intention is stop execution
> query for some time and execute other query (with high prority)
>
> Paul

There's no feature that quite does that, but there is resource manager. Frankly, profiles are a bit old hat these days, and they really ought to be consigned to the backlot. Resource manager won't kill your session, but it will throttle it back so that it takes a lower priority to other jobs being executed by people who need a scarce resource (CPU, for example) more than you do.

It's all done through dbms_resource_manager, or the GUI in Enterprise Manager.

Things you can limit/throttle back are (you did say you had 9i, didn't you?): CPU usage, estimated execution time, amount of undo generated, degree of parallelism permitted. There's also the ability to bump you down to a lower-priority group if your job has run for (or threatens to run for) longer than a specified amount of time.

Quite flexible, very useful (much more so than in 8i, anyway), and probably not exactly what you're looking for, but as close as you're going to get.

Regards
HJR Received on Wed Mar 24 2004 - 05:10:28 CST