V$POLICY_HISTORY definition in Oracle Database 11.2
V$POLICY_HISTORY

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

home |  up