V$INSTANCE

Columns
   ___________________________
 
   VERSION
   STARTUP_TIME
   THREAD#
   HOST_NAME
   STATUS
   INSTANCE_ROLE
   DATABASE_STATUS
   SHUTDOWN_PENDING
   LOGINS
   LOG_SWITCH_WAIT
   ARCHIVER
   PARALLEL
   INSTANCE_NUMBER
   INSTANCE_NAME

Related Views:

V$ACTIVE_INSTANCES 
V$BGPROCESS 
V$BH 
V$COMPATIBILITY 
V$COMPATSEG 
V$COPY_CORRUPTION 
V$DATABASE 
V$DATAFILE 
V$DATAFILE_COPY 
V$DATAFILE_HEADER 
V$DBFILE 
V$DBLINK 
V$DB_PIPES 
V$LICENSE 
V$OFFLINE_RANGE 
V$OPTION 
V$SGA 
V$SGASTAT 
V$TABLESPACE 
V$VERSION