Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

renicing processes and Oracle

Inesa Clinko

renicing processes and Oracle

Hi! :)
I have heard,that renicing in HP-UX of
several main processes in Oracle,
like DBWR,LGWR,ARCH and so on...
could improve DB-performnce?
Does anybody know more about it?
Any experiance? Please explain me which processes could be reniced, and which not?
What can be the values?
Excuse me, if it is stupid question.. :))
Graham Cameron_1
Honored Contributor

Re: renicing processes and Oracle


Where did you hear that?
It's a new one on me, and I can't find anything on metalink, but I'm willing to be convinced.

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Valued Contributor

Re: renicing processes and Oracle

yes or no! however, renicing oracle bg processes is totally unsupported. so i wouldn't muck around them.

Steven E. Protter
Exalted Contributor

Re: renicing processes and Oracle

Oracle is designed to work with standard process assignment. It is best not to mess with it.

You can use paid add in products like PRM to tune performance and give oracle higher priority.

But: What happens if you give Oracle too much priority and there aren't enough cycles for I/O?

Answer: Not very much.

Steven E Protter
Owner of ISN Corporation
Hein van den Heuvel
Honored Contributor

Re: renicing processes and Oracle

'It depends'.

If you consider to start turning knobs, be sure to have a measurement in place for feedback. At least 'overall trhoughput', like the run time for a typical batch job.

You may also have a few specific, heavy hitting, statspack timed events in mind (for example log file sync) when you turn a know like the lgwr prio.

As a first stab to playing with priority I'd recommend to add the init.ora param:

Thierry Poels_1
Honored Contributor

Re: renicing processes and Oracle


priorities of Oracle processes, either system or client processes, should not be changed on OS level. This will do more harm than good. Let Oracle take care of itself.

All unix flavours are exactly the same . . . . . . . . . . for end users anyway.