log file sync Wait

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 01 Jan 2003 22:53:41 -0800
Message-ID: <F001.0052521F.20030101225341@fatcity.com>

What ALL may be Done to Address the Following ? Any /etc/system , init.ora parameter Changes too ? Moving the Online Redo Logfiles onto RAID 1 NOT possible as that may warrant Additional Hardware . Moreover T3+ does NOT Support RAID 1 (Only RAID 1+ )

Concurrent Oracle processes = 1500 Approx. Statspack Taken during Mostly OLTP Operations :-

Top 5 Wait Events

~~~~~~~~~~~~~~~~~                                             Wait     % Total
Event                                               Waits  Time (cs)   Wt Time
-------------------------------------------- ------------ ------------ -------
log file sync                                     970,563    2,597,831   57.46
log file parallel write                           831,141      484,948   10.73

log_buffer = 2MB
Online Redo Logfiles Exist on RAID 1+
Storage Box is T3+
File System = UFS

Application = Banking (Hybrid )
Oracle 8.1.7.4
Solaris 8
Machine Box = SF6800

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Jan 02 2003 - 00:53:41 CST