> Look. Our buffer hit ratio is 100%!
>
> DATE: August 13, 2002 Buffer Cache Ratio for AMDEV
>
> LOGICAL_READS PHYSICAL_READS HIT_RATIO
> ---------------- -------------- ----------
> 1,919,442,737 564,223 100
>
> ('course, the fact that a single sql statement did nearly 2 billion
> logical reads isn't important. What's important is that it did it all
> from memory!!!)
>
>From Tim Gorman's TOP_STMT:
Date: 08/13/02 08:48:24 Page 1
Database startup: 08/07/02 23:52:23
First load time: 2002-08-12/16:53:15
.
SQL Statement Text
0 SELECT /*+ INDEX(CDT PK_CDT) */ ROWID,CDT_KEY,REC_TYPE,CATEGORY
1 ,NEW_CATEGORY,LST_TRANS,OPEN_BF,CUST_TELE_AREA,CUST_TELE_EXCHANG
2 E,CUST_TELE_LOCAL,CUST_TELE_EXT,RISK_CODE,DUNN_BRAD_RATING,BILL_
.......
: Disk Buffer Load
: Reads Gets Sorts Runs Loads
Factor
: ----- ------ ----- ---- -----
------
: 164,600 1,901,376,073 0 103,929 2
1917836.1
: (29.174%) (99.722%)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: bbaker_at_denvernewspaperagency.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).
Received on Tue Aug 13 2002 - 12:05:03 CDT
