select FILE_ID, -- FILE_ID NUMBER DATA_OBJECT_ID, -- DATA_OBJECT_ID NUMBER GC_MASTERING_POLICY, -- GC_MASTERING_POLICY VARCHAR2(11) CURRENT_MASTER, -- CURRENT_MASTER NUMBER PREVIOUS_MASTER, -- PREVIOUS_MASTER NUMBER REMASTER_CNT -- REMASTER_CNT NUMBER from GV$GCSPFMASTER_INFO where inst_id = USERENV('Instance')