Thursday, February 4, 2010

How to calculate average time for consistent read block requests for the instance in milliseconds?

How to calculate average time for consistent read block requests for the instance in milliseconds

Global Cache Block Transfer Rate=(gc cr block receive time * 10) / (gc cr blocks received)


SELECT
 gc_cr_block_receive_time AS "Receive Time",
 gc_cr_blocks_received AS "Blocks Received",
 (gc_cr_block_receive_time * 10) /
 gc_cr_blocks_received AS "Average Latency (MS)"
 FROM
 (
 SELECT value AS gc_cr_block_receive_time FROM v$sysstat
 WHERE name = 'gc cr block receive time'
 ),
 (
 SELECT value AS gc_cr_blocks_received FROM v$sysstat
 WHERE name = 'gc cr blocks received'
 );

Sample query output: 
Receive Time            Blocks Received                            Average Latency (MS)
------------              ---------------                               --------------------
5305                        2179                                              24.3460303

Julian Dyke - "Pro Oracle Database 10g RAC on Linux" - p692
"The latency of a consistent block request is the time elapsed between the original request and
the receipt of the consistent block image at the local instance. Using a Gigabit Ethernet interconnect,
this value should normally be less than 5 ms and should not exceed 15 ms, although this can be
affected by system configuration and volume."

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home