Get database uptime
select to_char(startup_time, 'DD-MM-YYYY HH24:MI:SS'),floor(sysdate-startup_time) DAYS from v$Instance;
oracle configurationintermediate
by OracleDba
11 views
📋Steps in this guide1/1
1
Get database uptime
Code/Command (click line numbers to comment):
1
select to_char(startup_time, 'DD-MM-YYYY HH24:MI:SS'),floor(sysdate-startup_time) DAYS from v$Instance;Comments (0)
Please to add comments
No comments yet. Be the first to comment!