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