Re: Instance Startup History

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 10 Oct 2006 14:27:09 GMT
Message-ID: <J6xC5A.Bp8@igsrsparc2.er.usgs.gov>

Johne_uk wrote:
> Hi,
>
> Is there a system view in Oracle that will provide historic data for
> the number of times an instance as been restarted over a specified
> period.
>
> Thanks in advance
> John
>

You might want to create a system trigger that logs startups and shutdowns in a table somewhere for you to recall later.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Tue Oct 10 2006 - 09:27:09 CDT