Re: longops vs sql

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 10:13:09 -0700
Message-ID: <1157649186.75167@bubbleator.drizzle.com>

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

Received on Thu Sep 07 2006 - 12:13:09 CDT