Re: Controlling the Priority of Oracle Sessions

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

Received on Wed Jun 30 1999 - 11:00:51 CDT