Re: Statspack snapshot triggers
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 May 2004 21:16:02 -0600
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@xxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
