Set Process Priority Help

[Steven Chen_1]

Hi,

I would like to see if there is way to set Oracle import process into Unix priority. Unix is 11i 64bit, no other processes exist. But it takes a long time to complete. I would like to make it faster.

Could that be done? Would that be nice command?

Thanks,

Steven

[harry d brown jr · Accepted solution]

If the process is already running, thne do a renice:

renice -n -20 pid

if you want to start it that way, do this:

nice -n -20 command

[James R. Ferguson]

Hi Steven:

The 'nice' and 'renice" commands set and alter process priorities. Take a look at the man pages for both.

You say that your Oracle import is taking a long time and you want to make it run faster. CPU starvation may not be the only cause. What does your entire system look like during the import? Are the disks involved in the import particularly busy? Is there a high CPU run queue?

You could gather a better idea here by running 'glance' during the import process and looking not only at the import task but also other processes and global metrics.

Regards!

...JRF...

[Ted M Johnson_1]

...and Steven, if this is a really high priority for your commpany, you might want to look into the Process Resource Manager product. Then, you can not only set the priority higher, but you can turn other things down, and do this all automagically ;-)

-ted

[Eugen Cocalea]

Hi

nice -

priority can be from -20 to 20 so you can

nice --20 #highest

to

nice -20 #lowest

E.