for a front row seat at this gunfight, I will gladly buy at least one
round :)
- Tim Gorman <Tim_at_SageLogix.com> wrote:
> ...turn your back on this list for a few days and look what happens
> (besides
> 440 new emails to scan-and-delete)...
>
> Well Jared, I can't think of any more potent weapon than single-malt
> scotch.
> Shotglasses at sunset...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, November 27, 2002 12:44 PM
>
>
> > they'll both be here in two weeks, I'm selling tickets to the fight
> now
> > :)
> >
> >
> > --- "Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> > > You best be careful, Jared. You KNOW how uptight and evil Tim can
> be!
> > > :)
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, November 27, 2002 9:56 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Oh boy, is my face red!
> > >
> > > I remembered that of course, as soon as I saw this.
> > >
> > > I need to keep better track of who I'm plagierizing. :)
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Cary Millsap" <cary.millsap_at_hotsos.com>
> > > Sent by: root_at_fatcity.com
> > > 11/26/2002 03:05 PM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > cc:
> > > Subject: RE: LGWR using lots of CPU time, low CPU
> > > usage
> > >
> > >
> > > The ultimate sincerest form of flattery is for someone to
> attribute
> > > something smart to you that you wish you had done but, alas, did
> not
> > > actually do.
> > >
> > > (It was Tim Gorman who posted the excellent analogy.)
> > >
> > >
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > >
> > > Upcoming events:
> > > - Hotsos Clinic, Dec 9-11 Honolulu
> > > - Hotsos Clinic 101, Jan 7-9 Knoxville
> > > - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
> > > - 2003 Hotsos Symposium, Feb 9-12 Dallas
> > >
> > >
> > > -----Original Message-----
> > > Jared.Still_at_radisys.com
> > > Sent: Tuesday, November 26, 2002 4:07 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > > >And "old school" is still right about not putting RedoLogs
> onto
> > > RAID5.
> > >
> > > > From what I'm being told, this is not your father's RAID5.
> This is
> > > what
> > >
> > > >they tell me:
> > >
> > > > The CPU hands the IO to the disk controller and rather than do
> the
> > > > physical disk IO while the process waits, the disk controller
> > > caches
> > > > it to local memory and says done. Therefore, effectively there
> is
> > > no
> > > > wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1,
> > > > the system is NOT waiting for the IO. He said the only time
> there
> > > might
> > > > be a delay is during the cache's battery refresh times. I
> checked
> > > your
> > > > dates and it was not occurring during those times. Also, if you
> > > look
> > > > at the iostat statistics under the 'wait' and '%w' headers you
> will
> > > > see all zeros.
> > >
> > > Debi,
> > >
> > > That is true, up to a point.
> > >
> > > Think of the cache as a water tank. You have a garden hose
> > > filling up the tank. You can keep increasing the water
> > > pressure for a while.
> > >
> > > But the outlet at the other end of the tank has a fixed
> > > capacity. It flows 10 GPM, and no more.
> > >
> > > What happens when you increase the flow at the intake to
> > > 20 GPM?
> > >
> > > The tank fills up.
> > >
> > > When the tank fills up, your intake flow will need to decrease,
> > > because you can only flow 10 GPM at the outlet.
> > >
> > > Now, think of the outlet as writing to disk, the RAID5 cache
> > > is the water tank, and your database is the inlet that wants
> > > to run at 20 GPM.
> > >
> > > If your database activity will never be intensive enough to
> > > stress the cache like this, no problem. But 'never' is a
> > > very long time.
> > >
> > > If any of this sound familiar, Cary Millsap posted a very similar
> > > explanation a few weeks ago.
> > >
> > > Plagierism is the sincerest form of flattery. :)
> > >
> > > Jared
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Jared.Still_at_radisys.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).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Cary Millsap
> > > INET: cary.millsap_at_hotsos.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).
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Jared.Still_at_radisys.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
>
=== message truncated ===
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 Nov 28 2002 - 19:43:46 CST
