Anjo, > Give the LGWR its own processor. I have don't once in a > particular benchmark > and reduced the log file sync wait time by a factor of 10.
When you say 'Give the LGWR its own processor' did you mean that processor binding needs to be done? As per my understanding, processor binding makes sure that a particular process is bound to run only on one particular processor and cannot hop across to other processors, even if they are free. As far as I am aware you cannot devote a processor to a specific process. In this case, processor binding would make the situation worse.... In other words, could you explain what you meant? :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
