Re: Instance Startup History

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

Depending on the version, it may be possible to declare the alert log as an external table, so you can query it like any other table for startups. See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:28805759638277 and
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1352202934074

jg

-- 
@home.com is bogus.
http://www.takeourword.com/current/page1.html