Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> multiblock read count question

multiblock read count question

From: Rob K <robkato_at_earthlink.net>
Date: Wed, 20 Jun 2001 14:14:08 GMT
Message-ID: <Qc2Y6.21823$aV1.2190988@newsread1.prod.itd.earthlink.net> 






Why would I be getting the same response time on full scans if the
multiblock read count is set to 2 or 32?



System:


Oracle 8.1.7 block size 8k



Sun 4500


2-5200 drives


Veritas


stripe = 4 drives with 256k interleave size = 1M stripe size.
max i/o = 1M



I change the user sessions multiblock read count to 2 and do a full scan on
a table and sum up a column.


It takes aprox 9 min to scan 60,043,128 rows 430080 blocks.



I change the user sessions multiblock read count to 32 run the same query
and it takes about the same time.
Received on Wed Jun 20 2001 - 09:14:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US