One of my colleagues showed me this gem in Oracle and I thought of documenting it here so that it will be useful for everyone and also I can find it next time I need it by just searching my blog instead of Google. 🙂 Using this query you can find out the start time of the Oracle database server.
SELECT * FROM V$INSTANCE
In addition to the start time the query also returns other useful information like instance name, version, hostname etc. The hostname is particularly useful when TNSNAMES.ORA is playing tricks with you.
Using this query you can find out the start time of the Oracle database server. The hostname is particularly useful when TNSNAMES. Please wait a few minutes and refresh this page.Great post. I was checking constantly this blog and I am impressed! Extremely helpful information specially the last part I care for such information much. I was seeking this certain information for a long time. Thanks and good luck.
Taking it one step further, is there a method to detemine startup time of an instance WITHOUT the use of v$ view. V$INSTANCE access has to be granted, or used by sys/system.
A fine quality educational blog! I like the way blogger presented information regarding the concerned subject. Thanks for posting such a nice blog about web developer companies.
I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.