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

30. select Active_State from V$INSTANCE

   <source lang="sql">

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

ACTIVE_ST

---

NORMAL

SQL> SQL> SQL> SQL></source>

30. select Database_Status from V$INSTANCE

   <source lang="sql">

SQL> select Database_Status from V$INSTANCE;

DATABASE_STATUS

---

ACTIVE</source>

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

   <source lang="sql">

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></source>