RE: Hitachi 9000 (was RE: 2GB or not 2GB )

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Mon, 11 Sep 2006 15:40:49 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AFC4@ex2.ms.polyserve.com>

 >>>I check my data and found it is actually 102 GB in 66

>>>minutes for a rate of 26 MB/sec for a full table scan.
>>>"Sequential reads" are much slower, around 8-10 MB/sec.
>>>

You should not be scanning data with db file sequential read though. Is PQO broken on your setup? In my experience, having a single forground process suck up 26MB/s is pretty good considering the size of I/O requests those are. I'd work this out until you get direct path reads and also ensure your multiblock read count is set so that the direct path reads will be a minimum of 1MB.

>>> 2 HBA per SAN. I think 1Gb, but not sure
>>> Veritas file system

uh, quickIO or ODM? or just normal ?

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 11 2006 - 17:40:49 CDT