The last 10 startup times of the database along with timezone.
Sometimes we have to find when the database is started with which timezone especially when the database is getting reboot unknowingly.
The below query gives the output of the last 10 start times of the database along with the timezone, Click here for sample output.
SET SPACE 1 LINESIZE 80 PAGES 1000 SELECT * FROM ( select inst_id,to_char(ORIGINATING_TIMESTAMP,'YYYY/MM/DD HH24:MI:SS TZH:TZM') from V$DIAG_ALERT_EXT WHERE trim(COMPONENT_ID)='rdbms' and MESSAGE_TEXT like ('PMON started with%') order by inst_id,originating_timestamp desc ) WHERE rownum < 11; prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Key points to remember:
1. V$DIAG_ALERT_EXT fetches data from XML based alert log in the ADR (Automatic Diagnostic Repository) i.e from database alert log.
2. In RAC database execute on each instance according to your requirements.
We always encourage the technical person to visit section SCRIPTS to get more daily usage SQL commands.
Hope so you like this script!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.
440 total views, 1 views today
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?
Hello and welcome to DBsGuru,
DBsGuru is a group of experienced DBA professionals and serves databases and its related community by providing technical blogs, projects, training.
Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on.
Thanks for the visits!
Share Learn Grow!