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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 31 Dec 2003 15:08:14 +0800
Message-ID: <3FF275DD.3F0@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 Received on Wed Dec 31 2003 - 01:08:14 CST