| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: log file sync Wait
Yes, the lessons I took from that presentation were to use a shorter piece
of string and buy larger bottles of gin though I'm willing to admit that I
may have got the wrong end of the stick.
=)
Cheers,
Mike
-----Original Message-----
Sent: 02 January 2003 09:24
To: Multiple recipients of list ORACLE-L
First of all I'd like to have the full picture of your performance: Log file sync might be 57% of the wait time, but how much of the response time is wait time?
Second, Log File Sync means Commit; So if your system is waiting a lot for commits there are two things you can do: Fewer commits (changes to applications) or faster commits (hardware striping, etc.).
No changes to the log buffer will help here (except perhaps making it smaller, as Connor McDonald so brilliantly showed during the funniest presentation I've ever seen in my life at UKOUG in Birmingham). If the log buffer is being flushed constantly, it's better to make it small so that it doesn't have to go through the whole thing every time.
Mogens
VIVEK_SHARMA wrote:
>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
>-------------------------------------------- ------------ ------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: mln_at_miracleas.dk 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: Mike.Hately_at_npowernorthern.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 - 04:18:39 CST
 |
 |