RE: Time to read 6000 (block size 2k) blocks

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 6 Aug 2004 10:19:01 -0400
Message-ID: <42BBD772AC30EA428B057864E203C9998AC396@MSGBOSCLF2WIN.DMN1.FMR.COM>

Five millisecond is not bad for single block sequential read.

Waleed

-----Original Message-----

From: jaysingh1_at_optonline.net [mailto:jaysingh1_at_optonline.net]=20 Sent: Friday, August 06, 2004 9:49 AM
To: oracle-l_at_freelists.org
Subject: Time to read 6000 (block size 2k) blocks

Hi All,

The question may be wispy.
We have 14 CPU sun box,8i 2 node OPS. Not under heavy load.

In our case it is taking 21.86 sec for 6126 blocks (from disk)

db file sequential read                      6126        0.29

21.86

Approximately how long it should take to read 6000 blocks?

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

---

Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 11.39 41.98 6126 18805 0 1
------- ------ -------- ---------- ---------- ---------- ----------

---

total 4 11.40 41.99 6126 18805 0 1

db file sequential read                      6126        0.29

21.86

Thanks
Sami

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Aug 06 2004 - 09:17:28 CDT