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

INT PARAMETER GETS MISSES PCT_SUCC_GETS UPDATES
---- ----------------------- --------- -------- ------------- ----------
1 dc_sequences 188898 85715 54.6 188,898
dc_segments 44272 2602 94.1 618
dc_rollback_segments 3148291 3842 99.9 211
dc_tablespace_quotas 1427 907 36.4 198
dc_objects 4108120 1686 100.0 78
outstanding_alerts 6229 5348 14.1 68
2 dc_sequences 45823 35608 22.3 45,823
dc_rollback_segments 7862462 3946 99.9 1,229
dc_segments 201841 23098 88.6 1,036
dc_tablespace_quotas 991 417 57.9 675
dc_objects 260138 1304 99.5 56
dc_object_ids 422596 1285 99.7 55
3 dc_sequences 248253 85714 65.5 248,252
dc_segments 3418039 42533 98.8 1,357
dc_rollback_segments 3105105 4643 99.9 219
dc_tablespace_quotas 1343 911 32.2 191
dc_objects 3853521 1577 100.0 151
dc_object_ids 4978860 1938 100.0 55
4 dc_sequences 43384 34685 20.1 43,384
dc_segments 215692 32954 84.7 1,141
dc_rollback_segments 8011288 3294 100.0 1,099
dc_tablespace_quotas 1107 417 62.3 577
outstanding_alerts 6237 5338 14.4 68
dc_objects 243894 1500 99.4 55
Apart from the columns displayed above, GV$ROWCACHE also contains columns to provide instruction on requests
and contentions across various instances in the cluster. The output below illustrates the DLM (distributed lock
manager) related columns. The DLM_* columns are populated only in a RAC environment.
Script: MVRACPDnTap_dlmrowcache.sql
SELECT inst_id int
, parameter
, sum(dlm_requests) requests,
, sum(dlm_conflicts) conflicts
, sum(dlm_releases) releases
FROM GV$ROWCACHE
WHERE gets > 0
AND 6 > 0
GROUP BY INST_ID, parameter
ORDER BY inst_id,
6 desc;