Re: Last startup and shutdown time of an instance

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Tue, 30 Mar 2004 19:06:02 GMT
Message-ID: <uyjac.29028$wg1.13221@edtnps84>

Rahan, le fils des âges farouches wrote:

> Hans Forbrich wrote:
>

>> Rahan, le fils des âges farouches wrote:
>> 
>>> Hi!
>>> I would like to know where are logged the last startup and shutdown time
>>> of an oracle instance.
>>> Thanks for your help.
>> 
>> Logged, or available for query?  That kind of info is in the Alert log,
>> which your DBA should be looking at regularily.
>> 
>> /Hans

>
> Thanks,
> I've the information I was ooking for in the Alert log.
> Could you also tell me in which table this information is available for
> query ?

As Sybrand mentions, startup time is in v$instance.

/Hans Received on Tue Mar 30 2004 - 13:06:02 CST