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

From: <J.Velikanovs_at_alise.lv>
Date: Fri, 6 Aug 2004 17:22:07 +0300
Message-ID: <OFC6BE2406.2C4B2BF8-ONC2256EE8.004E71D2-C2256EE8.004FB020@alise.lv>

UUUUUps!!!
!(21.86/6126)*1000 = 45,7ms/pio.!
Forget that I have told you. It is complicit rubbish. I don’t know how I got 45,7.

The correct is 3,56 ms.
And it is looks definitely better then 45 ms. Do not rush to sysadm ;) You need to look on the different optimization area.

Please excuse my fault.
It is seems late Friday syndrome

Jurijs
+371 9268222 (+2 GMT)

Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

J.Velikanovs_at_alise.lv
Sent by: oracle-l-bounce_at_freelists.org
06.08.2004 17:08
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        Re: Time to read 6000 (block size 2k) blocks

(21.86/6126)*1000 = 45,7ms/pio.
By my experience everything what is below 20ms in general is OK. High end need to be quicker ~10ms.
We have HP EVA solution implemented.
The response time is 5 ms, even in high load situations (There 12 CPU, RAC

configuration).
.
In your case 45 ms can be the problem.
I would discuss this with system administrators or supplier representatives.
.
PS Do not forget about throughput of channels 180Mbit/s, 320Mbit/s, 1Gbit/s. Check sum of IO stream volumes.

Jurijs
+371 9268222 (+2 GMT)

Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

jaysingh1_at_optonline.net
Sent by: oracle-l-bounce_at_freelists.org
06.08.2004 16:48
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        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


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





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

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:26:53 CDT