V$INSTANCE view provides one row of statistics for each Oracle instance running against the database : V_instance « System Tables Views « Oracle PL / SQL






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

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>








Related examples in the same category

1.select Active_State from V$INSTANCE
2.select Database_Status from V$INSTANCE
3.v$instance.instance_name