Re: Statspack snapshot triggers

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 11 May 2004 21:16:02 -0600
Message-ID: <BCC6F312.14D4E%tim@sagelogix.com>

I think it's a good idea to create a BEFORE SHUTDOWN trigger to capture any as-yet-uncaptured statistics. After all, why lose them if you don't have to? Those last few minutes prior to instance shutdown might have the most interesting data, after all. I've not experienced any problems with shutdown from it and besides, nothing outwits SHUTDOWN ABORT if the instance has to come down. Certainly, there is no possible threat to recoverability imposed by PL/SQL code.

Source for the BEFORE SHUTDOWN trigger is posted online at "http://www.EvDBT.com/tools.htm", in the script "sp_shutdown.sql"...

Hope this helps...

on 5/10/04 3:43 PM, Aaron Sentell at asentell1_at_cox.net wrote:

> I am in the midst of implementing hourly statspack snapshots in our databases
> and am wondering what other people's thoughts are about creating startup and
> shutdown triggers to snapshot the database. I'm leaning towards not doing it
> unless there is a good reason to do it. It seems to me like it could add
> complexity in recovering and shutting down a database. Any thoughts?
>
> Thanks,
> Aaron

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 11 2004 - 22:12:02 CDT