Nice and renice

[Andrew Stubbs]

I have HPUX 11 running on an HP9000 with 8 cpu with oracle 7.3.4.

All processes run at the default nice level (20), but cron submitted jobs sometimes get a nice level of 22.

Is this an issue for oracle ? and what is doing the renicing ?

Andrew

[Herve BRANGIER]

Hi,

Don't really know Oracle, but sometimes
database use reniced processes to make jobs
which are not really hurry. For example, some
db optimization's processes are launched
everyday (by cron) but there are less
important than other tasks.

(A process with nice=22 is less important than
with 20)...

HTH

Herve

[Andrew Stubbs]

But if a process running at 22 is talking to a process running at 20 it would seem to imply some sort of wait/sleep is possible between the 2 processes. - or have I missed the concept totally

[Rob Smith · Accepted solution]

Hi, cron and batch jobs runs at a lower priority by default. This is not an issue for Oracle and it will not cause any problems. Hope this helps.

Rob