SQL> select * from gv$sysstat where name like 'gcs %';
INST_ID STATISTIC# NAME CLASS VALUE STAT_ID
---------- ---------- ---------------------------------------------------------------- ---------- ---------- ----------
2 50 gcs messages sent 32 50360522 2765451804
1 50 gcs messages sent 32 941459 2765451804
SQL> select * from gv$sysstat where name like 'ges %';
INST_ID STATISTIC# NAME CLASS VALUE STAT_ID
---------- ---------- ---------------------------------------------------------------- ---------- ---------- ----------
1 51 ges messages sent 32 501427 1145425433
2 51 ges messages sent 32 5046029 1145425433
SQL> show parameter gc_files_to_locks;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
gc_files_to_locks string
SQL> select b1.inst_id, b2.value "RECEIVED",
2 b1.value "RECEIVE TIME",
3 ((b1.value / b2.value) * 10) "AVG RECEIVE TIME (ms)"
4 from gv$sysstat b1, gv$sysstat b2
5 where b1.name = 'gc cr block receive time' and
6 b2.name = 'gc cr blocks received' and b1.inst_id = b2.inst_id;
INST_ID RECEIVED RECEIVE TIME AVG RECEIVE TIME (ms)
---------- ---------- ------------ ---------------------
1 15034 2132 1.41811893
2 1260491 363117 2.88075837
SQL>