GV$GCSPFMASTER_INFO definition in Oracle Database 11.2

GV$GCSPFMASTER_INFO

select
  INST_ID,                                 -- INST_ID NUMBER
  KJDRPCMPFID,                             -- FILE_ID NUMBER
  KJDRPCMPOID,                             -- DATA_OBJECT_ID NUMBER
  decode(                                  -- GC_MASTERING_POLICY VARCHAR2(11)
    KJDRPCMPTYPE, 0, 'Affinity', 1, 'Read mostly'),
  KJDRPCMPFCMAS,                           -- CURRENT_MASTER NUMBER
  KJDRPCMPFPMAS,                           -- PREVIOUS_MASTER NUMBER
  KJDRPCMPFRMCNT                           -- REMASTER_CNT NUMBER
from
  x$kjdrpcmpf

home | up