Make sure that the LGWR runs freely on a processor, without interference from other foreground processes. On sun you can create processor sets for example.
Anjo. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 2:08 AM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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).