Oracle query to find the server start up time

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.

Related posts

Tags: ,

4 Comments so far

Follow up comments through RSS Feed | Post a comment

  • Las Vegas Web Designer says:

    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.

  • Craig says:

    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.

  • Nick says:

    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.

  • johnkevin says:

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *