Re: Can you change a priority of the query?

From: tmgn <tmgn_at_excite.com>
Date: Tue, 24 Aug 1999 10:20:10 -0400
Message-ID: <37C2AA1A.694A3A7C@excite.com>

Oracle advises running all the Oracle processes at the Same OS priority for stability purposes and hence do not 'nice' them ..

You should SQL Trace U'r Query and see if it is going for the best execution path and/or run any Long runnng queries at off-peak time to minimise the impact on the System..

-Thiru

comtrex_inc_at_my-deja.com wrote:

> Hi,
> I would like to know if it is possible to manage priority of a running
> query.
> I would like to be able to control the impact of the jobs on the
> responsivnes of the system.
> thanks a lot
> robert
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Aug 24 1999 - 09:20:10 CDT