Re: LGWR using lots of CPU time, low CPU usage

...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
> > 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: Fink, Dan
> > INET: Dan.Fink_at_mdx.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).
> >
>
>
> __________________________________________________
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).