System Tables Data Dictionary Oracle PLSQL Tutorial

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