Tuning Global Cache - Expert Oracle RAC Performance Diagnostics and Tuning - page 410

Figure 13-11. Dynamic re-mastering statistics
Objects that have been mastered and remastered on the various instances can be determined from the
GV$GCSPFMASTER_INFO view. The following output illustrates the current master (identified by CM column) and
previous master (identified by PM column) instances for a few of the objects. The output has been sorted on the
objects that have been remastered the highest number of times (identified by the CNT column) since the instances
were started.
Script Name: MVRACPDnTap_findhotobjmasters.sql
SELECT inst_id INT,
owner,
GCSPF.data_object_id OBJID,
object_name ONAME,
subobject_name SONAME,
Decode(object_type, 'TABLE PARTITION', 'TP',
'TABLE SUBPARTITION', 'TSP',
'TABLE', 'T',
'INDEX SUBPARTITION', 'ISP',
'INDEX PARTITION', 'IP',
'CLUSTER', 'C',
'SEQUENCE', 'S',
'INDEX', 'I') OT,
gc_mastering_policy GC_MP,
decode(CURRENT_MASTER,'0','1','1','2','2','3','3','4','4','5','5','6','6','7','7','8','8',
'9','9','10') CM,
decode(PREVIOUS_MASTER,'0','1','1','2','2','3','3','4','4','5','5','6','6','7','7','8','8',
'9','9','10','32767','NO') PM,
remaster_cnt CNT
FROM gv$gcspfmaster_info GCSPF,
dba_objects DO