select
inst_id, -- INST_ID NUMBER
policy_event, -- POLICY_EVENT VARCHAR2(20)
data_object_id, -- DATA_OBJECT_ID NUMBER
target_instance_number, -- TARGET_INSTANCE_NUMBER NUMBER
event_date -- EVENT_DATE VARCHAR2(20)
from
gv$policy_history
where
inst_id = USERENV('Instance')