HPE Community
Operating System - HP-UX
1819832 Members
2905 Online
109607 Solutions
New Discussion

database uptime and downtime report

 
Nirmalkumar
Frequent Advisor

‎05-13-2009 01:50 PM

‎05-13-2009 01:50 PM

database uptime and downtime report

Hello all,

can some one provide me the script to get oracle database uptime and downtime report.

Thanks in advance.


Thanks,
Nirmal
0 Kudos
Reply
1 REPLY 1
avizen9
Esteemed Contributor

‎05-13-2009 05:57 PM

‎05-13-2009 05:57 PM

Re: database uptime and downtime report

Hello Nirmal,
below is sample script to check uptime.

SELECT SYSDATE - logon_time "DB Uptime in Days",
(SYSDATE - logon_time) * 24 "DB Uptime in Hours"
FROM v$session
WHERE program LIKE '%PMON%'

here one line where you can modify as per your requirement
http://www.windows-tech.info/15/2528abe2344ff12d.php
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.