From oracle-l-bounce@freelists.org Mon Mar 8 17:02:38 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i28N2cL25938 for ; Mon, 8 Mar 2004 17:02:38 -0600 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 i28N2Xo25928 for ; Mon, 8 Mar 2004 17:02:34 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C64D8395045; Mon, 8 Mar 2004 18:02:12 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 08 Mar 2004 18:00:57 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id F1C65394DE1 for ; Mon, 8 Mar 2004 18:00:50 -0500 (EST) Received: (qmail 352 invoked from network); 8 Mar 2004 22:58:42 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 8 Mar 2004 22:58:42 -0000 Message-ID: <003701c40561$4ecd9900$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: References: Subject: Re: optimizer_index_cost_adj and optimizer_index_caching Date: Mon, 8 Mar 2004 19:00:15 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0034_01C4053F.979E29A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 135 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_0034_01C4053F.979E29A0 Content-Type: text/plain; charset="WINDOWS-1250" Content-Transfer-Encoding: quoted-printable RE: optimizer_index_cost_adj and optimizer_index_cachingIn windows I set = DB_FILE_MULTIBLOCK_READ_COUNT to 16 (guy harrison suggestion) which would be the value for MREADTIM in 9i. And which is the complete name for MREADTIM and SREADTIM please. :) According to the Metalink note you can even achieve 8.1.7 behavior when = you set MREADTIM =3D 1.2 * SREADTIM and MBRC=3D8, but I haven't tested = this. And finally I haven't heard for a negative feedback till now and = this counts as well. But as usual happens in real life also the system = stats is not solving all problems.=20 ------=_NextPart_000_0034_01C4053F.979E29A0 Content-Type: text/html; charset="WINDOWS-1250" Content-Transfer-Encoding: quoted-printable RE: optimizer_index_cost_adj and = optimizer_index_caching
In windows I set DB_FILE_MULTIBLOCK_READ_COUNT  = to 16=20 (guy harrison suggestion)
which would be the value for MREADTIM in = 9i.
 
And which is the complete name for MREADTIM and = SREADTIM=20 please.
:)
 
 
According to the Metalink note you can even achieve = 8.1.7=20 behavior when you set MREADTIM =3D 1.2 * SREADTIM and MBRC=3D8, but I = haven't tested=20 this. And finally I haven't heard for a negative feedback till now and = this=20 counts as well. But as usual happens in real life also the system stats = is not=20 solving all problems.
 
 
 
------=_NextPart_000_0034_01C4053F.979E29A0-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------