| Soumya |
Posted: Dec 20, 2007 03:14:59 AM |
Total Post: 56
Joined: Mar, 2006
|
Hi,
How do I check databse uptime in days & hours.
Plz let me know for any quires or views.
Thanx |
|
|
 Murtuja |
| Posted: Dec 20, 2007 04:18:53 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
SELECT SYSDATE - logon_time "DB Uptime in Days",
(SYSDATE - logon_time) * 24 "DB Uptime in Hours"
FROM v$session
WHERE program LIKE '%PMON%'
|
|
|
|
|
| Ratnaker |
| Posted: Dec 20, 2007 07:31:29 AM | |
|
Total Post: 136
Joined: Apr, 2007
|
Hi Murtuja,
Its very usefull query.
thank you,
K P Ratnaker
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 21, 2007 11:55:20 PM | |
|
Total Post: 694
Joined: Jul, 2007
|
You can also check it through OEM main page.
|
|
|
|
|
| Soumya |
| Posted: Dec 22, 2007 12:11:22 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
|
|
|
|
| Soumya |
| Posted: Dec 22, 2007 12:11:52 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
|
|
|
|
| Soumya |
| Posted: Dec 22, 2007 12:12:32 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
|
|
|
|
| Sabdar Syed |
| Posted: Dec 24, 2007 04:16:10 AM | |
|
Total Post: 35
Joined: Mar, 2007
|
SELECT to_char(startup_time, 'DD-MON-YYY HH:MI:SS') FROM V$INSTANCE;
Regards,
Sabdar Syed.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
