Re: Limit I/O per session

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 23 Mar 2004 15:33:56 +0100
Message-ID: <40604abd$0$308$626a14ce@news.free.fr>

"pz" <pz_at_xx.interia.pl> a écrit dans le message de news:c3pg3c$t1i$1_at_news2.ipartners.pl...
> Hi,
> I prepared special backup procedure (procedure read a lot of data).
> This procedure cannot affect other sessions speed.
> Limit cpu priority for backup user significantly decrease speed for
> other (hi priority) sessions.
> It is possible to limit I/O read per user / session ?
> How to solve my issue?
>
> Thanks for any suggesions
>
> Paul

I don't if it is the overall I/O or the I/O rate you want to limit. In the first case, have a look at profile and logical_reads_per_session limit. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_611a.htm#2065932

If you use RMAN to backup, you can limit the rate with the RATE parameter of allocate channel. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta6.htm#78115

Regards
Michel Cadot Received on Tue Mar 23 2004 - 08:33:56 CST