From oracle-l-bounce@freelists.org Tue Jun 8 01:45:29 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i586jEO11562 for ; Tue, 8 Jun 2004 01:45:24 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i586j4611524 for ; Tue, 8 Jun 2004 01:45:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2A80A72C28B; Tue, 8 Jun 2004 01:30:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11059-100; Tue, 8 Jun 2004 01:30:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70FEC72C0C3; Tue, 8 Jun 2004 01:30:53 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Jun 2004 01:29:29 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0A3072C347 for ; Tue, 8 Jun 2004 01:29:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11291-42 for ; Tue, 8 Jun 2004 01:29:28 -0500 (EST) Received: from relay2.iflexsolutions.com (unknown [202.144.91.165]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3303B72C343 for ; Tue, 8 Jun 2004 01:29:27 -0500 (EST) Received: from fmgrt.rt.i-flex.com (pppserver [192.168.50.2]) by relay2.iflexsolutions.com (8.12.3/8.12.3) with ESMTP id i58CGJbv006279 for ; Tue, 8 Jun 2004 12:16:19 GMT Received: from fmgrt.rt.i-flex.com ([192.168.50.2]) by fmgrt.rt.i-flex.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 8 Jun 2004 12:22:42 +0530 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C44D25.31C727C6" Subject: RE: CBO irregularity X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Date: Tue, 8 Jun 2004 12:22:41 +0530 Message-ID: <10898BE7CA96D611988B000802255AAF069B1FD6@fmgrt.rt.i-flex.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: CBO irregularity Thread-Index: AcRNIzEFFljsqwVJTwWrA/oyeEyzdQAAX4jw From: To: X-OriginalArrivalTime: 08 Jun 2004 06:52:42.0013 (UTC) FILETIME=[31EF94D0:01C44D25] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2213 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Satheesh.Babu@iflexsolutions.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C44D25.31C727C6 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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).=20 =20 Thanks and Regards, Satheesh Babu.S Bangalore =20 _____ =20 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Naveen, Nahata (IE10) Sent: Tuesday, June 08, 2004 12:09 PM To: oracle-l@freelists.org Subject: RE: CBO irregularity =20 Thanx Cary and Satheesh, =20 Why wud the no. of blocks read be less than DB_FILE_MULTBLOCK_READ_COUNT? =20 Is it dependent on the I/O sub-system? =20 Regards Naveen =20 True. The Oracle kernel also collects this information when you use dbms_stats.gather_database_stats. =20 ------_=_NextPart_001_01C44D25.31C727C6 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Naveen, Nahata (IE10)
Sent: Tuesday, June 08, = 2004 12:09 PM
To: oracle-l@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.

 

------_=_NextPart_001_01C44D25.31C727C6-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------