Ben wrote:
> 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"
The disk on my laptop is spinning at 7500RPM. The disks on my NetApp are
spinning at 15K RPM. Am I reading on the outside of the platter or the
inside? Is the data cached? How is the data being fetched stored? Is it
on a single drive or striped across many? I wouldn't do anything without
based on someone's rule of them. Even if it were my own.
--
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 21:10:15 CDT
