If you've enjoyed this post, you might want to subscribe my RSS feed or email alerts for free updates. Thanks for visiting and come back again.

The following query works well with Oracle 9i. i’ve no clue whether this works with others too or not.

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
FROM sys.v_$instance;

even there is possiblity to find the startup time by quering logon_time from sys.v_$session view.