> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).