Obviously you weren't listening attentively enough. The main thing you should have gleaned from the presentation was that if you bash an ugly squirrel with a hammer hard enough, then ....
... its still an ugly squirrel :-) Cheers Connor --- "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> wrote: > 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 > >-------------------------------------------- > ------------ ------------ > ------- > >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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > 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: [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.net > -- > Author: Hately, Mike (NESL-IT) > INET: [EMAIL PROTECTED] > > 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: [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). > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [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).