Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

Script to display uptime By: Sanjay Tiwari Mar 02 2007 Display database uptime in days and hours   REM: Display database uptime in days and hours REM: REM: Author: Sanjay Tiwari REM: Date Submitted: 02-28-2007 REM: Date Posted: 03-13-2007 REM: REM:***************************************** REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE. REM: Author will not be responsible for any damage that may be cause by this script. REM:***************************************** select SYSDATE-logon_time \"Days\", (SYSDATE-logon_time)*24 \"Hours\" from sys.v_$session where sid=1 /* this is PMON */

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor