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)"
<Mike.Hately_at_npowernorthern.com> 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: 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).
>
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: hamcdc_at_yahoo.co.uk
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 - 06:29:11 CST