Re: buffer cache

Hi Carly ;)

How would you describe the book ?

Is it the SF thriller that it sounds or does it contain a romantic angle suitable the wife ? I heard that it has a real twist at the end but the evil villain (Niemiec I believe is the name) comes to a gruesome end....

Looking forward it :)

Richard
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, May 09, 2003 8:20 AM

> Yep, July. It's not on amazon.com yet, but it *is* listed at www.bn.com
> (which, for personal reasons, is where I'd encourage you to buy your books
> anyway). However, my name is [still] hideously misspelled "Carly Milsap."
>
> Stats on the book (assuming that bn.com got everything right except for
the
> authors' names):
>
> Optimizing Oracle Response Time
> by Cary Millsap with Jeff Holt
> O'Reilly & Associates
> ISBN 059600527X
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic 101 in London, Reykjavik, Ottawa, Dallas, Washington,
> Denver, Sydney
> - Visit www.hotsos.com for schedule details...
>
>
> -----Original Message-----
> Sent: Thursday, May 08, 2003 4:44 PM
> To: Multiple recipients of list ORACLE-L
>
> July!?? I'm assuming that this isn't "Basic for the IBM PC" from '87, as
> this is the only hit I get on Amazon.
>
> So, title? Publisher? Discounts for those of us who can't convice
> management that attendance to your clinics should be mandatory? (had to
> try...)
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
>
> > -----Original Message-----
> > From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]
> > Sent: Thursday, May 08, 2003 2:13 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: buffer cache
> >
> >
> > :)
> >
> > Mine should be available for purchase in July. I'll be
> > finishing up within
> > the next couple of weeks.
> >
> > I'm waiting for Jonathan's next book too. The more
> > encouragement he gets
> > from everyone, the more likely he'll consider taking it on as
> > a project.
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> >
> > Upcoming events:
> > - Hotsos Clinic 101 in London, Reykjavik, Ottawa, Dallas, Washington,
> > Denver, Sydney
> > - Visit www.hotsos.com for schedule details...
> >
> >
> > -----Original Message-----
> > Landrum
> > Sent: Thursday, May 08, 2003 1:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > I'm ready for Jonathon's next book.
> > Along those lines, I think Amazon is going to start charging me for
> > frequent searches to see if your book is available for pre-order yet.
> >
> > >>> cary.millsap_at_hotsos.com 05/08/03 11:52AM >>>
> > High BCHR is not *necessarily* bad, as Zhu Chao says. But, a
> > systemwide
> > BCHR
> > in excess of 95% or so is often an indication of one or more
> > inefficiencies
> > that can result in greatly improved performance if corrected:
> >
> > - SQL that motivates excessive numbers of unnecessary LIO calls
> > (consistent
> > gets, db block gets, buffer is pinned count, buffer is not pinned
> > count,
> > etc. [Thanks, Jonathan Lewis for teaching me about the "pinned"
> > statistics.])
> > - Applications that fetch one row at a time instead of using array
> > fetch
> > technology [thanks again to Jonathan for bringing this to my attention
> > too].
> > - Applications that roll back more often than they should [Jonathan
> > again].
> >
> > For more information, see my "Why a 99% buffer cache hit
> > ratio is *not*
> > ok",
> > and perhaps Jonathan will tell you how to access his "The database
> > gets
> > better but the metrics look worse" article that he presented at IOUG.
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> >
> > Upcoming events:
> > - Hotsos Clinic 101 in London, Reykjavik, Ottawa, Dallas, Washington,
> > Denver, Sydney
> > - Visit www.hotsos.com for schedule details...
> >
> >
> > -----Original Message-----
> > Sent: Thursday, May 08, 2003 3:32 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi,stephane,
> > Though BCHR tuning method is widely critiqued, high buffer cache
> > hit
> > ratio is not necessary bad either, right?
> > Maybe high cache hit ration and v$bh with a lot of free/cr block
> > means
> > too big data buffer.
> > Here is an example of too big data buffer:
> >
> >
> > 15:29:44 SQL> select /*+rule*/ status,count(*) from v$bh group by
> > status;
> >
> > STATU COUNT(*)
> > ----- ----------
> > cr 55120
> > free 54656
> > scur 17696
> > xcur 24549
> >
> > 4 rows selected.
> >
> > Elapsed: 00:00:01.32
> > While in another database with large sga,I think this buffer cache
> > is
> > not too big:
> >
> > 15:27:05 perfstat_at_BIDDB.EACHNET.COM> select /*+rule*/ status,count(*)
> > from
> > v$bh group by status;
> >
> > STAT COUNT(*)
> >
> > ---- ----------
> >
> > cr 11162
> >
> > read 1
> >
> > xcur 1037413
> >
> >
> > Regards
> > zhu chao
> > msn:chao_ping_at_163.com
> > www.cnoug.org(China Oracle User Group)
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, May 05, 2003 7:11 PM
> >
> >
> > > High BCHR, V$BH ...
> > >
> > > >----- ------- Original Message ------- -----
> > > >From: Arvind Kumar <arvindk_at_sqlstarintl.com>
> > > >To: Multiple recipients of list ORACLE-L
> > > ><ORACLE-L_at_fatcity.com>
> > > >Sent: Mon, 05 May 2003 02:41:36
> > > >
> > > >Dear All,
> > > >
> > > > how can i check if my buffer cache is bigger
> > > >than necessary ?oracle db
> > > >version is 8.1.7.
> > > >
> > > >
> > > >Thanks
> > > >
> > > >
> > > >Arvind
> > > >
> > > >
> > > >--
> > > >Please see the official ORACLE-L FAQ:
> > > >http://www.orafaq.net
> > > >--
> > > >Author: Arvind Kumar
> > > > INET: arvindk_at_sqlstarintl.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).
> > > >---------------------------------------------------
> > > >------------------
> > >
> > > Regards,
> > >
> > > Stephane Faroult
> > > Oriole
> > > --
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.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.net
> --
> 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.net
-- 
Author: Richard Foote
  INET: richard.foote_at_bigpond.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).