| From: | Steve Adams |
| Date: | 13-Oct-2000 14:55 |
| Subject: | Real time priority for LGWR process |
|
|
This is answered in my book, so I'll just quote the relevant paragraphs.
Many operating system scheduling algorithms adjust the execution priority of processes in proportion to the amount of CPU time that they have consumed recently. In very busy Oracle environments, this has the unfortunate effect of degrading the execution priority of key background processes, such as LGWR, DBWn, LCKn, and LMDn. This causes an increase in scheduling latencies for those processes, and can in the extreme make the entire instance bottleneck on the services of the affected background processes.
|
![]() |
In one of your answers you have mentioned that the LGWR can be assigned real time priority, but the SA's in my company (they work on Sun Solaris v 2.6) say that real time priority should never be given to database processes -- now I am sure that they are (blindly) telling me something which they have read from some manual and that there is some intricate reason behind your suggestion. Can you please enlighten me on this when you find the time.
|