Oracle PL/SQL Tutorial/System Tables Data Dictionary/V INSTANCE

30. select Active_State from V$INSTANCE

SQL>
SQL>
SQL> select Active_State from V$INSTANCE;
                                                              
ACTIVE_ST
---------
NORMAL
                    
SQL>
SQL>
SQL>
SQL>

30. select Database_Status from V$INSTANCE

SQL> select Database_Status from V$INSTANCE;
                                                              
DATABASE_STATUS
-----------------
ACTIVE

30. V$INSTANCE view provides one row of statistics for each Oracle instance running against the database

SQL> select instance_name, host_name, version,
  2     startup_time, round(sysdate-startup_time) "Days Up",
  3     status from v$instance;
INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T    Days Up STATUS
----------------- --------- ---------- ------------
xe
UBC-1
10.2.0.1.0        26-OCT-09          0 OPEN

SQL>