Re: Controlling the Priority of Oracle Sessions

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
>
>
Received on Wed Jun 30 1999 - 23:51:18 CDT