Re: Controlling the Priority of Oracle Sessions

Doug

The other approach I've seen some people take is to use a separate database on a separate machine for report processing. Of course, the use of this approach is dependent on how up to date the report data needs to be, but it may be worth thinking about as well.

HTH. Pete

Doug Stailey wrote:

> I am trying to limit or expand the resources used by publication- and
> report-
> generating client programs so that I can control their impact on data entry.
> We have a transaction-based system which periodically experiences large
> and complex output requests.
>
> Thanks for your advice earlier regarding Oracle 8i, and I will look into it.
>
> Doug
>
> Pete Sharman wrote in message <377A4A1D.6684D730_at_us.oracle.com>...
> >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
> >
> >

--
Regards

Pete

Received on Thu Jul 01 1999 - 10:37:48 CDT