Database Reference
In-Depth Information
INT BLK SRV TIME BLK SRVD PREP TIME
---- ------------ -------- ---------
1 1447970 7271960 5.02
2 936210 9382593 10.02
3 1252730 5337366 4.26
4 900880 4810821 5.34
5 90650 636710 7.02
6 2435470 23721688 9.74
7 453510 1347489 2.97
8 1085640 9456850 8.71
8 rows selected.
From the preceding output, the prepare time is significantly high on all the instances in the cluster. Before we
analyze the situation further, let's look at the transfer time on these servers.
Step 2
The following queries help us compute these values to determine what is slowing down the process:
Script: MVRACPDnTap_ blksndtime.sql
SELECT
B1.INST_ID INT,
((B1.VALUE/B2.VALUE ) *10) "Avg CR BRT(ms)",
((B3.VALUE/B4.VALUE ) *10) "Avg CUR BRT(ms)"
FROM GV$SYSSTAT B1,
GV$SYSSTAT B2,
GV$SYSSTAT B3,
GV$SYSSTAT B4
WHERE B1.NAME = 'gc cr block receive time'
AND B2.NAME = 'gc cr blocks received'
AND B3.NAME = 'gc current block receive time'
AND B4.NAME = 'gc current blocks received'
AND B1.INST_ID = B2.INST_ID
AND B1.INST_ID = B3.INST_ID
AND B1.INST_ID = B4.INST_ID
ORDER BY 1
/
INT Avg CR BRT(ms) Avg CUR BRT(ms)
---- -------------- ---------------
1 1.75 1.71
2 1.11 .67
3 1.24 .52
4 1.42 .47
5 1.28 .66
6 .91 .52
7 .87 .50
8 .82 .51
8 rows selected.
Search WWH ::
Custom Search