Home » SQL & PL/SQL » SQL & PL/SQL » UPTIME Record?
UPTIME Record? [message #247018] Fri, 22 June 2007 18:50 Go to next message
Messages: 25568
Registered: January 2009
Location: SoCal
Senior Member
SQL> select (sysdate-startup_time) uptime from v$instance;


SQL> !uptime
  4:47pm  up 1738 day(s), 18:45,  4 users,  load average: 0.04, 0.02, 0.03

Now no fudging the results!
Re: UPTIME Record? [message #247040 is a reply to message #247018] Sat, 23 June 2007 01:56 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I'm going to send that to our hardware admins, who come every few weeks with their "we have to re-boot the disk clusters now, shut everything dow, dude." Wink
Previous Topic: padding ";" in the table result
Next Topic: Finding missed records and Inserting them in the same table
Goto Forum:

Current Time: Wed Aug 16 10:20:24 CDT 2017

Total time taken to generate the page: 0.08450 seconds