檢查Oracle INSTANCE狀態

9i:

select 'The instance ' || db.name || ' is on line' || ' (machine ' ||
       machine || ', started ' ||
       TO_CHAR(ses.logon_time, 'DD - MON - YYYY HH24 :MI :SS') || ')'
  from v$database db, v$session ses
 where ses.sid = 1;

 10g:

select 'The instance ' || db.name || ' is on line' || ' (machine ' ||
       machine || ', started ' ||
       TO_CHAR(ses.logon_time, 'DD-MON-YYYY HH24:MI:SS') || ')'
  from v$database db,
       (SELECT T.MACHINE, MIN(T.LOGON_TIME) LOGON_TIME
          from v$session t
         WHERE T.TYPE = 'BACKGROUND'
         GROUP BY T.MACHINE) ses;