Re: How to tell how long an instance has been running

In Oracle 8 and above you can use the V$INSTANCE view to determine startup time. However, in earlier versions of Oracle the "STARTUP_TIME" column did not exist in V$INSTANCE. The easiest way to determine the startup time of the instance is to grab the earliest logon time from the V$SESSION view.

select min(logon_time) from v$session;

This column exists in both Oracle 7 and 8. The earliest login time will be assoicated with one of the background processes such as LGWR or DBWR and will have started at the same time the instance has started.

• Ethan Post

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:993156118.20183.1.nnrp-13.9e984b29_at_news.demon.co.uk...
>
>
> Here's a nice short one for the FAQ - any volunteers, please.
>
> --
> Jonathan Lewis
>
> Host to The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
> See http://www.jlcomp.demon.co.uk/book_rev.html
>
> Seminars on getting the best out of Oracle
> See http://www.jlcomp.demon.co.uk/seminar.html
>
>
>
>
>
>
> Peter Shankey wrote in message
> <20010619.18045600_at_wando.charlestoncounty.org>...
> Is there a v$ which tells how long a instances has been running in both 7
> and 8?
>
> Thanks
> Pete
>
>
Received on Fri Jun 22 2001 - 01:03:05 CDT