Re: Statspack snapshot triggers

From: Terry Sutton <terrysutton_at_usa.net>
Date: Mon, 10 May 2004 15:05:18 -0700
Message-ID: <039401c436db$30541110$6200000a@TerrySutton>

I can't imagine a reason to do it. If hourly snapshots are sufficient (and they generally are, unless you're digging into a specific performance problem), having an extra snapshot from DB startup to first hourly isn't going to give you very useful info.

--Terry

Original Message ----- From: "Aaron Sentell" <asentell1_at_cox.net> To: <Oracle-L_at_freelists.org> Sent: Monday, May 10, 2004 2:43 PM Subject: Statspack snapshot triggers

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

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

Received on Mon May 10 2004 - 17:04:27 CDT