Oracle-L: RE: Database Monitoring tool

From: <Govind.Arumugam_at_alltel.com>
Date: Sat, 02 Nov 2002 06:43:31 -0800
Message-ID: <F001.004FAAEF.20021102064331@fatcity.com>

For those who don't know who Anjo Kolk is, please visit www.oraperf.com. Anjo has worked for over 16 years at Oracle (1985-2001).

Many people generate utlbstat/utlestats and statspack reports, but don't know how to interpret the data. People that do look at these are reports also mostly looking at the wrong information and end up making the wrong tuning decisions. That is why the reports are analyzed based on the YAPP method. The YAPP method will show what component of the total response time should be tuned first.

I am a frequent visitor to their web-site to analyze our statspack reports.

Govind
-----Original Message-----

Sent: Friday, November 01, 2002 10:58 PM To: Multiple recipients of list ORACLE-L

Raj,

I am currently in Tokyo. My Japanese is not so good to that I can buy those books. But may be I don't need to ;-)

Anjo.

-----Original Message-----

Rajendra
Sent: Friday, November 01, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L

Anjo ...
you need to buy some (specific) books on Oracle Tuning to understand BCHR ... 8:>
Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----

Sent: Friday, November 01, 2002 9:55 AM To: Multiple recipients of list ORACLE-L

B(uffer) C(ache) H(it) R(atio)
Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Friday, November 01, 2002 9:03 AM To: Multiple recipients of list ORACLE-L

BCHR ???
Anjo ;-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Govind.Arumugam_at_alltel.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 Sat Nov 02 2002 - 08:43:31 CST