From oracle-l-bounce@freelists.org Tue May 17 19:53:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4I0rm5Q015475 for ; Tue, 17 May 2005 19:53:48 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4I0rm4Z015470 for ; Tue, 17 May 2005 19:53:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 000F819470F; Tue, 17 May 2005 18:50:58 -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 05529-05; Tue, 17 May 2005 18:50:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A17F194CD7; Tue, 17 May 2005 18:50:58 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=DZpifCMXX+tord87Q7BXkVx5tz2uoc6bgVAY1gCKW27Vlo/o//ybz6OK6YENriIZ15KScs2K1O2XA1YG/XQxDBbl0TDXDi6ShbYHk6pf1/6iF+bDuzDWQz4Zgle92q9gWz2InHQmdvbUt1Rsax+P45tRRNq5J39scNrSVMCYcfs= Message-ID: <5e30486205051716491ec80df2@mail.gmail.com> Date: Wed, 18 May 2005 07:49:10 +0800 From: Connor McDonald To: oracle-l Subject: Re: 10g System statistics - single and multi In-Reply-To: <6.2.1.2.2.20050517171232.102022e0@pop.centrexcc.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <52a152eb0505171232556f3711@mail.gmail.com> <428A57C7.7040002@centrexcc.com> <52a152eb05051713544f014099@mail.gmail.com> <428A5D27.40908@centrexcc.com> <52a152eb0505171516306c0ac8@mail.gmail.com> <6.2.1.2.2.20050517171232.102022e0@pop.centrexcc.com> X-archive-position: 19815 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mcdonald.connor@gmail.com Precedence: normal Reply-To: mcdonald.connor@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 I logged a tar with Oracle a while back about why SREAD > MREAD was an "stopper" for using the system stat MBRC, and their reply was that if this was allowed then "under some circumstances it would make costs go negative" Cheers Connor On 5/18/05, Wolfgang Breitling wrote: >=20 > Whether it makes sense or not, that's the current rules. There are many > more "sanity checks" and assumptions in the CBO, some of which I would > question much more than this one. >=20 > Regards >=20 > Wolfgang Breitling > Centrex Consulting Corporation > http://www.centrexcc.com >=20 > -- --=20 Connor McDonald =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D email: connor_mcdonald@yahoo.com web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- http://www.freelists.org/webpage/oracle-l