Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
How to determine Oracle uptime (Read 6834 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
How to determine Oracle uptime
16.11.06 at 08:19:31
 
How to determine Oracle uptime
 
To determine when the database was last restarted you can look at the logon time of the PMON process from V$SESSION:
 
SELECT to_char(logon_time,'DD/MM/YYYY HH24:MI:SS')
FROM   v$session
WHERE  sid=1
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1