Oracle-L: RE: Log file synch / direct path writes

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Fri, 21 Jun 2002 16:08:22 -0800
Message-ID: <F001.00484AC9.20020621160822@fatcity.com>

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: john.kanagaraj_at_hds.com

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: ListGuru_at_fatcity.com (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). Received on Fri Jun 21 2002 - 19:08:22 CDT