select Active_State from V$INSTANCE : V_instance « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_instance

select Active_State from V$INSTANCE

   

SQL>
SQL>
SQL> select Active_State from V$INSTANCE;
                                                              

ACTIVE_ST
---------
NORMAL
                    
SQL>
SQL>
SQL>
SQL>








Related examples in the same category

1.select Database_Status from V$INSTANCE
2.V$INSTANCE view provides one row of statistics for each Oracle instance running against the database
3.v$instance.instance_name