V$ACTIVE_INSTANCES definition in Oracle Database 11.2
V$ACTIVE_INSTANCES

select
  INST_NUMBER,                             -- INST_NUMBER NUMBER
  INST_NAME                                -- INST_NAME VARCHAR2(60)
from
  GV$ACTIVE_INSTANCES
where
  inst_id = USERENV('Instance')

home |  up