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 Commands: