RE: missed Anjo's webcast..

I think I will side with Anjo on this one, if my users are happy with 1 second response times and 99.9% of the data is coming completly through PIO that is fine with me. Of course that is an exageration but you get the point. Keep the customers happy and work on other things. I also think the point is to be a bit reactive about the Oracle tuning manual and training. I do recall at some point in my formative Oracle years as being a bit obsessed with my BCHR and really missing the big picture.

Ethan Post
perotdba (AIM), epost1 (Yahoo)

-----Original Message-----
Sent: Thursday, August 08, 2002 3:31 PM
To: Multiple recipients of list ORACLE-L

Well, I guess that I disagree. Buffer hit radio does matter as one of the performance indicators, but
certainly not the only one. Your and Mr. Milsap thesis is that LIO also is very expensive and its cost
is far from being negligible, so having gazillion of LIOs instead of 100 times smaller number of PIOs will
not make our system run faster. BHR alone cannot be used to judge to overall health of the system, but
thebn again, there is no such thing as the "overall health of the system". It's the users of the system who
will say whether the performance is satisfactory or not, and I'm usually tuning an application, not an
imaginary "overall system". Low cache hit ratio usually tells me that I do have a hog who is using lots
of PIOs. By my experience, it usually is a very good indicator that something is wrong, at least on an OLTP
 system. So, after all, I do find BHR a useful indicator, but by no means the only one or the most important
one. Event 10046, SQL_TRACE (level 1 of 10046), explain plan and v$session_event still are the tools
I need most, but I still do need BHR as an indicator.

Mladen Gogala
Oracle DBA
Phone: (203) 459-6855
Email: mgogala_at_oxhp.com

-----Original Message-----
Sent: Thursday, August 08, 2002 1:05 PM
To: Multiple recipients of list ORACLE-L

Moi wrong ;-) Jeeh, human after all  

To summarize the webcast:
db-block-buffers do mattter. Too many LIO do matter. Too many PIO do matter. But Buffer Cache Hit ratio doesn't matter ....... End user satisfaction does matter.  

I am always willing to clarify any points that I made, you just have to ask me l ....  

Anjo.    

• Original Message -----

To: Multiple recipients of list <mailto:ORACLE-L_at_fatcity.com> ORACLE-L Sent: Thursday, August 08, 2002 5:43 PM

Guys,

I had this dream that I missed the webcast - which I did. However, someone said it wasn't very interesting but the conversation of the people (gurus) left over was very interesting as there was good solid evidence that he was incorrect and db_block_buffers do matter. Kind of inline with the discussion about redos yesterday and my indexing/partition issues - hmmm.

-----Original Message-----
<mailto:mgogala_at_adelphia.net> ]
Sent: Thursday, August 08, 2002 1:38 AM To: Multiple recipients of list ORACLE-L

Www.precise.com, go to Events->webcasts... On 2002.08.08 00:53 Madhusudhanan Sampath wrote:
> Are transcript documents available anywhere?
>
> Regards
> Madhusudhanan S
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
<http://photos.msn.com/support/worldwide.aspx>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
> --
> Author: Madhusudhanan Sampath
> INET: madhulist_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>

-- 
Mladen Gogala 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>  
-- 
Author: Mladen Gogala 
  INET: mgogala_at_adelphia.net 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California        -- Public Internet access / Mailing Lists 
-------------------------------------------------------------------- 
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: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).