System Tables Data Dictionary Oracle PLSQL Tutorial

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