Re: 10g System statistics - single and multi

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 18 May 2005 07:49:10 +0800
Message-ID: <5e30486205051716491ec80df2@mail.gmail.com>

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 <breitliw_at_centrexcc.com> 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_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 17 2005 - 19:53:48 CDT