Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Controlling the Priority of Oracle Sessions
True, but this simply disconnects the session when it reaches a certain CPU limit
per call or session, depending on which you implement. It sounds like Doug is
trying to allocate more resources to one process than another, rather than
disconnecting one when it hits a certain limit.
HTH. Pete
AleX wrote:
> 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
--
Regards
Pete
Received on Wed Jun 30 1999 - 11:47:25 CDT