Re: longops vs sql

From: Ben <balvey_at_comcast.net>
Date: 7 Sep 2006 12:02:09 -0700
Message-ID: <1157655728.946608.320780@d34g2000cwd.googlegroups.com>

DA Morgan wrote:
> Ben wrote:
>
> > Sorry, that is assuming that 300 disk I/Os can be performed per second.
> > That is just an estimate.
>
> Bad assumption. Are you familiar with running
> DBMS_STATS.GATHER_SYSTEM_STATS?
>
> Morgan's Library
> www.psoug.org
> click on SYSTEM STATISTICS
>
> This will give you accurate information. For my IBM ThinkPad:
>
> CPUSPEEDNW 1364.342
> IOSEEKTIM 13.923
> IOTFRSPEED 4096
> SREADTIM 5.714
> MREADTIM 5.903
> CPUSPEED 1378
> MBRC 13
>
> Not a 300 in sight.
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group

Well, I was basing that from "Oracle SQL Tuning: Pocket Reference" by Mark Gurry. He claims that those times are "typical of a medium to high end machine" Received on Thu Sep 07 2006 - 14:02:09 CDT