In article <6vdmf5$afb$1_at_nnrp1.dejanews.com>, f.faravelli_at_cbim.it writes
>Can I force Oracle to execute an SQL instruction
>(a big UPDATE,INSERT etc.) with one priority level lower than
>that one of all the other active processes on the server ?
>
disclaimer: ideas only, not checked in the manuals.
A few options here, you might want to play with the oracle user profiles
and limit cpu use by user, that might help. Failing that you
could use the "nice" command if HP-UX has it to:
nice --someval sqlplus ....
You should also be able to set the priority within a pro*c etc
program, the "nice" man page should have a see also bit referring
to the programatic interface. Its years ago I did this kinda
stuff so sorry for the fuzzy details. Hopefully some pointers here
anyway.
Steve
P.S
I doubt you'll see much difference anyway. I guess you have a background
job running and don't want to upset users. I don't like this suggestion
but you could always sleep after each x rows...
--
Please remove nospam from my address to Reply.
Received on Tue Oct 06 1998 - 17:05:10 CDT
