tag:blogger.com,1999:blog-1945348621162143792.post2006851064130648698..comments2013-01-18T13:22:14.910-06:00Comments on Rodger's Notes: Oracle database tuning and being "nice"Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1945348621162143792.post-85934615761413812612010-02-10T22:14:08.335-06:002010-02-10T22:14:08.335-06:00Reminds me of a horrible story that I've encou...Reminds me of a horrible story that I've encountered a couple of times in my travels. People renice-ing Oracle processes of low-priority business tasks so that the Oracle processes of higher-priority business tasks could run faster.<br /><br />...Except that those low-priority processes that were sitting in the runqueue not running were holding the cache buffers chains latches that the higher-priority processes needed to complete. The higher-priority processes were getting all the CPU time they needed to spin for latches that weren't available. CPU utilization was way up there.<br /><br />Nothing could get done.<br /><br />Ugly.Cary Millsaphttps://www.blogger.com/profile/16697498718050285274noreply@blogger.comtag:blogger.com,1999:blog-1945348621162143792.post-11238876856905701592010-02-10T21:14:50.087-06:002010-02-10T21:14:50.087-06:00In an older post called "Nice Processes Finis...In an older post called "Nice Processes Finish Last" I explained that even the nicest process still uses CPU time and other processes will spend some time waiting for it.<br /><br />You were correct and your admin did not know nice as well as I'd expect from a unix admin.Anonymousnoreply@blogger.com