Tuning the Database - Expert Oracle RAC Performance Diagnostics and Tuning - page 279

INT EQ EQ_NAME TR TW SR FR CWT
---- -- ---------------- --------- --------- --------- ------ ---------
1 TM DML 62988023 2139 62978829 756 9350
TX Transaction 28637660 761 28641102 0 68020
SQ Sequence Cache 57822 47278 57603 0 1917370
TX Transaction 30156 13808 30156 0 224340
2 TM DML 64071069 3368 64062637 941 8430
TX Transaction 29342805 727 29345321 0 79440
TX Transaction 75258 47680 75013 0 1949500
SQ Sequence Cache 31992 15276 31992 0 204590
TX Transaction 1720 177 1719 0 140
3 TM DML 65880848 2390 65872229 983 8020
TX Transaction 30045006 765 30048075 0 71130
TX Transaction 57838 48805 57640 0 2013050
SQ Sequence Cache 31585 14806 31585 0 205760
4 TM DML 33551829 5331 33548976 990 10980
TX Transaction 15844925 15836560 15852182 0 8912800
TX Transaction 538237 518908 538238 0 24403760
SQ Sequence Cache 510114 510094 510104 0 18639440
TX Transaction 44172 1619 44172 0 73730
Step 2
Based on the enqueue statistics collected, the next step is to check on the rowcache for the sequences. This is done by
querying the GV$ROWCACHE view.
Script: MVRACPDnTap_rowcache.sql
SELECT inst_id int
, parameter
, sum(gets) gets
, sum(getmisses) misses
, 100*sum(gets - getmisses) / sum(gets) pct_succ_gets
, sum(modifications) updates
FROM GV$ROWCACHE
WHERE gets > 0
AND 6 > 0
GROUP BY INST_ID, parameter
ORDER BY inst_id,
6 desc;