Re: Limit I/O per session

From: pz <pz_at_xx.interia.pl>
Date: Wed, 24 Mar 2004 11:06:48 +0100
Message-ID: <c3rmjp$25bf$1@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

Douglas Hawthorne wrote:
> "pz" <pz_at_xx.interia.pl> wrote in message
> news:c3pg65$t1i$2_at_news2.ipartners.pl...
>

>>I use oracle 9i
>>
>>Paul

>
>
> Paul,
>
> Check out the RESOURCE_LIMIT system parameter in conjunction with the use of
> PROFILEs. Start with the Concepts Guide to get an understanding before
> diving in.
>
> Also see http://www.psoug.org/reference/profiles.html
>
> Douglas Hawthorne
>
>
Received on Wed Mar 24 2004 - 04:06:48 CST