RE: CBO irregularity

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Mon, 7 Jun 2004 23:39:02 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B109740D37C332@ie10-sahara.hiso.honeywell.com>

Thanx Cary and Satheesh,  

Why wud the no. of blocks read be less than DB_FILE_MULTBLOCK_READ_COUNT?  

Is it dependent on the I/O sub-system?  

Regards
Naveen  

True. The Oracle kernel also collects this information when you use dbms_stats.gather_database_stats.  

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jun 08 2004 - 01:30:40 CDT