Newsgroups: comp.databases.oracle.server Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Instance Startup History In-Reply-To: <1160411400.009328.15470@c28g2000cwb.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-53.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1160411400.009328.15470@c28g2000cwb.googlegroups.com> Mime-Version: 1.0 Date: Tue, 10 Oct 2006 14:27:09 GMT Lines: 30 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276926 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@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