![]() The startup history is listed from the latest to the oldest one. SQL> select startup_time open_time from dba_hist_database_instance order by 1 desc To view all startup history of the database, we may extend the above query. If you found the difference of your case is only a few seconds, this is very normal for starting a database from idle to completely open. ![]() SQL> select max(startup_time) open_time from dba_hist_database_instance Īs you can see, the database open time was lagged about 10 minutes behind the instance startup time in this case. Here we wait for about 10 minutes, then open the database. Database Startup Timeįor database, the startup time is actually the open time. SELECT tochar (startuptime,'DD-MON-YYYY HH24:MI:SS') 'DB Startup Time' FROM sys. We always require to check the periodic daemon for a PMON or SMON process.The startup time and shutdown time are written in the alert logs. It doesn't require an admin user, although SELECT access to the vinstance table. It's the same except the state is MOUNT now. The problem here is to calculate the shutdown time. SQL> select status, startup_time from v$instance ![]() SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss' Oracle Database - Enterprise Edition - Version 12.1.0. To check instance startup time, here we can query the instance under NOMOUNT state.įirst of all, we format the date time of current session. Additionally, we also check the startup history of the database in the last section of this post. ![]() Tomcat takes 3-5 seconds to start up, and 10-15 seconds to deploy a medium-sized projects. However, I've recently had the opportunity to use Tomcat for some side projects, and I am struck by the incredible difference in speed. To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time. Answer: Startup information is stored in vinstance.startuptime, and uptime can be easily computed as sysdate - startuptime, but shutdown data is problematic. At my work, we use Weblogic Server to host an enterprise portal. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |