How to Find the Last Startup Time of Oracle Database

 Introduction

Sometimes a DBA needs to know when the Oracle Database was last started. This is very useful for troubleshooting, performance checks, or after a server restart.

SQL Query

Connect to the database as SYSDBA and run:

SELECT STARTUP_TIME FROM v$instance;

👉 This will return the exact date and time when the instance was last started.

Additional Tip

You can also check the database status:

SELECT instance_name, status, database_status FROM v$instance;

This shows if the instance is OPEN, MOUNTED, or STARTED.

Conclusion

With a simple query to v$instance, you can quickly find out when Oracle Database was last restarted. This is an essential check for any DBA.