select
  INSTANCE_NUMBER,                         -- INSTANCE_NUMBER NUMBER
  INSTANCE_NAME,                           -- INSTANCE_NAME VARCHAR2(16)
  HOST_NAME,                               -- HOST_NAME VARCHAR2(64)
  VERSION,                                 -- VERSION VARCHAR2(17)
  STARTUP_TIME,                            -- STARTUP_TIME DATE
  STATUS,                                  -- STATUS VARCHAR2(12)
  PARALLEL,                                -- PARALLEL VARCHAR2(3)
  THREAD#,                                 -- THREAD# NUMBER
  ARCHIVER,                                -- ARCHIVER VARCHAR2(7)
  LOG_SWITCH_WAIT,                         -- LOG_SWITCH_WAIT VARCHAR2(15)
  LOGINS,                                  -- LOGINS VARCHAR2(10)
  SHUTDOWN_PENDING,                        -- SHUTDOWN_PENDING VARCHAR2(3)
  DATABASE_STATUS,                         -- DATABASE_STATUS VARCHAR2(17)
  INSTANCE_ROLE,                           -- INSTANCE_ROLE VARCHAR2(18)
  ACTIVE_STATE,                            -- ACTIVE_STATE VARCHAR2(9)
  BLOCKED                                  -- BLOCKED VARCHAR2(3)
from
  GV$INSTANCE
where
  inst_id = USERENV('Instance')