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

    UPTIME
----------
808.090463

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
ThomasG
Messages: 3189
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 Dec 07 12:30:00 CST 2016

Total time taken to generate the page: 0.18386 seconds