RE: missed Anjo's webcast..

>> Oddly enough, no complaints from users.  

I signed up for but missed the presentation because I got pulled into a meeting with a manager of an
application who was complaining about his database buffer hit ratio...  

ok.. not really, but I did get pulled into a meeting. I assume that one of the points
of the presentation was that the users are one gauge of performance and I'd agree
with that. Also, there is no criticism intended in this post, just a thought or two.  

I'd like to make the point that sometimes users just get used to lousy performance,
and after a while they just stop complaining because they are ignored or management does
not push this information forward...(or perhaps the work environment is not conducive
to user feedback) so the users figure out how to live with it. So, sometimes,
we don't get that feedback. Then there is the issue of defining what slow is... the user
tells me the application is slow, but what does that really mean? So many times I've gotten
this type of response that it's slower this week than last week but when you try to get them
to quantify the statement they can not.  

That being the case, we need a few thermometers to alert us to potential performance improvement opportunities. It is in the class of a thermometer that
I put the buffer cache hit ratio. It's just one of many indicators. By itself it means little or nothing,
but accompanied by additional evidence that there are some performance improvements
to be gained, it is useful.  

I'll be looking up the archived presentation soon!!  

RF  

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)

The avalanche has begun, It is too late for the pebbles to vote.  

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

Someone send me this after the presentation. He got the point:  

FYI: My production SAP system has a BHR of 65%. The only complaints are from SAP analysts that say it's too low. Oddly enough, no complaints from users. :)

• Original Message ----- To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list 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: Freeman, Robert
  INET: Robert_Freeman_at_csx.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).