set head off
set feed off
select instance_name||' Database UP Time ' from v$instance;
select 'CURRENT DATE ===>> '|| to_char(sysdate,'dd-mon-yyyy hh24:mi') from dual;
select 'DB START DATE ===>> '|| to_char(startup_time,'dd-mon-yyyy hh24:mi') from v$instance;
select 'Database UP Time in Days Hours Minutes Seconds' from dual;
set head on
select rtrim(ltrim( (cast(sysdate as timestamp) - cast (STARTUP_TIME as timestamp)),'+000000000'),'000000') "DD HH:MI:SS" from v$instance;
set feed off
select instance_name||' Database UP Time ' from v$instance;
select 'CURRENT DATE ===>> '|| to_char(sysdate,'dd-mon-yyyy hh24:mi') from dual;
select 'DB START DATE ===>> '|| to_char(startup_time,'dd-mon-yyyy hh24:mi') from v$instance;
select 'Database UP Time in Days Hours Minutes Seconds' from dual;
set head on
select rtrim(ltrim( (cast(sysdate as timestamp) - cast (STARTUP_TIME as timestamp)),'+000000000'),'000000') "DD HH:MI:SS" from v$instance;
Comments