Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limit I/O per session

Re: Limit I/O per session

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Wed, 24 Mar 2004 11:08:23 GMT
Message-ID: <H_d8c.122556$Wa.97349@news-server.bigpond.net.au>


"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
>
>
> 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
> >
> >

Paul,

My apologies for misunderstanding your original query.

What you is more along the lines of a resource plan (see Ch. 9 of 9i Database Concepts). However, a resource plan does not consider logical I/O's in allocating resources - it considers the allocation of CPU time to various groups of users and to users within each group.

In 10G, there is now Automatic Workload Management which is more flexible in its approach to allocating resources and my reading of the documentation seems to indicate that AWM will consider logical I/O. I have not tested it out yet. See Ch.14 of 10G Database Concepts for an overview.

Douglas Hawthorne

Douglas Hawthorne Received on Wed Mar 24 2004 - 05:08:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US