Re: Controlling the Priority of Oracle Sessions

Pete Sharman wrote:

> Doug
>
> It is strongly recommended NOT to change the priority of any Oracle sessions.
> You could end up with a lockout of the database as a session with low priority
> takes out a lock and can't get back in to release it. Everyone can end up
> queuing on that lock (unlikely situation in reality, but it can happen).
>
> Having said that, there is a different way of doing what you want in 8i. You
> can set up resource profiles and allocate users to them so that they get more
> (or less) resources. Have a look at the concepts manual on technet.oracle.com
> if you don't already have 8i to see what it's capable of doing.
>
> HTH.
>
> Pete
>
> Doug Stailey wrote:
>
> > Is there any way to set the priority of Oracle sessions so that one session
> > gets more processor resources? What I am looking for is similar to the
> > 'nice' command in Unix. I don't need a full explantion here, but I would
> > like
> > to know whether this is possible and where I can find more information.
> >
> > Thanks,
> >
> > Doug
>
> --
> Regards
>
> Pete

CPU time can also be set for profiles in 8.0.x Received on Wed Jun 30 1999 - 11:41:05 CDT