OraFAQ Forum: SQL & PL/SQL » UPTIME Record?

Home » SQL & PL/SQL » SQL & PL/SQL » UPTIME Record?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UPTIME Record? [message #247018]

Fri, 22 June 2007 18:50

BlackSwan
Messages: 26766
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!

Report message to a moderator

Re: UPTIME Record? [message #247040 is a reply to message #247018]

Sat, 23 June 2007 01:56

ThomasG
Messages: 3212
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

Report message to a moderator

Previous Topic:	padding ";" in the table result
Next Topic:	Finding missed records and Inserting them in the same table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 08:04:30 CST 2024