Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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

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>