Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Buffer cache statistics (ratios) and CBO SQL optimization?

Re: Buffer cache statistics (ratios) and CBO SQL optimization?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 31 Dec 2003 05:07:01 -0800
Message-ID: <1efdad5b.0312310507.2505dbdd@posting.google.com>


Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3FF275DD.3F0_at_yahoo.com>...
> Frank van Bortel wrote:
> >
> > Niall Litchfield wrote:
> >
> > > That first sentence should have read
> > >
> > > it just so happens that I have on my 9204 laptop a trace file that when run
> > > through tkprof shows.... The trace file did *not* come from the laptop.
> > >
> > Too bad - I'd loved a laptop with a RAID-5 configuration
> > for christmas ;-). And I'd reconfigure it for RAID 1+0
> >
> > --
> > A prosperous 2004,
> > Regards,
> > Frank van Bortel
>
> Some figures from machines I've played with in the past
>
> Machine LIO/sec PIO/sec
> Home PC, 500Mhz 34,950 340
> HP, 266 Mhz 26,770 650
> HP, 650 Mhz 74,850 2780
> HP, 750 Mhz, 83,150 2840
> Compaq, 700Mhz 66,470 3380
>
> Cheers
> Connor

Connor-- how did you calculate LIOs/second? you run a query etc... but how do you know how many/second? Do you just pick a long running query to do this? Received on Wed Dec 31 2003 - 07:07:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US