Get database uptime - Oracle Database Script. SELECT to_char(startup_time, 'DD-MM-YYYY HH24:MI:SS'), floor(sysdate-startup_time) DAYS FROM v$Instance;
SELECT to_char(startup_time, 'DD-MM-YYYY HH24:MI:SS'), floor(sysdate-startup_time) DAYS FROM v$Instance;