select Database_Status from V$INSTANCE : V_INSTANCE « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. V_INSTANCE
SQL> select Database_Status from V$INSTANCE;
                                                              

DATABASE_STATUS
-----------------
ACTIVE








30.115.V_INSTANCE
30.115.1.V$INSTANCE view provides one row of statistics for each Oracle instance running against the database
30.115.2.select Active_State from V$INSTANCE
30.115.3.select Database_Status from V$INSTANCE