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')