RE: CBO irregularity

From: <Satheesh.Babu_at_iflexsolutions.com>
Date: Tue, 8 Jun 2004 12:22:41 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF069B1FD6@fmgrt.rt.i-flex.com>

It's os dependent. First oracle will not complain if this value is set more than value allowed for the operating system. Oracle will set this value to maximum allowed in a os or db_buffer_cache/4 (if your cache size is less than 4 times the maximum allowed value).  

Thanks and Regards,

Satheesh Babu.S

Bangalore  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Naveen, Nahata (IE10)
Sent: Tuesday, June 08, 2004 12:09 PM
To: oracle-l_at_freelists.org
Subject: RE: CBO irregularity  

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:45:29 CDT