| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost PERFSTAT bridge scripts Found it
Sure Tim. Thank you for all your great scripts and code. Just saw
sphistory.sql at http://www.evdbt.com/tools.htm and I'm going to take a look
at that.
I think he occasionally got a :"ORA-04092: cannot COMMIT in a trigger".
Isn't the startup for the same reason? That is, to collect stats from startup to when your scheduled snap runs.
Thanks Larry
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Gorman
Sent: Friday, July 30, 2004 4:38 AM
To: oracle-l_at_freelists.org
Subject: Re: Lost PERFSTAT bridge scripts Found it
Larry,
Thanks for the post of Mr Hurley's material. Especially useful is the use
of AUTONOMOUS TRANSACTION pragma, although I've not found it to be
necessary...
I can understand performing a STATSPACK.SNAP before database shutdown, to "flush" any values to disk before they are lost, but I am at a loss to understand the reason to perform a STATSPACK.SNAP in an AFTER STARTUP database-event trigger?
-Tim
on 7/29/04 1:49 PM, Wolfson Larry - lwolfs at lawrence.wolfson_at_acxiom.com wrote:
> Guess I didn't get specific enough on Google the first time.
>
> Sorry
>
> http://www.quest-pipelines.com/pipelines/dba/tips03.htm#january
>
> January's Tip of the Month
>
> Automatic Statspack Snapshots at Shutdown and Startup
> Compliments of Darryl Hurley, Pipeline SYSOP (dhurley_at_mdsi.bc.ca)
>
> Oracle?s Statspack utility provides a straightforward method of monitoring
> database performance statistics. The process is simple; take interval
> snapshots of performance indicators and then run reports to see how much
the
> indicators have changed during the interval(s).
>
> Problems arise when intervals span an Oracle shutdown because comparing
> interval values across them is illogical. Here?s an example:
>
> 10:00 PM Statspack Snapshot #33 shows Physical Reads = 100000
> 10:15 PM Database Shutdown
> 10:20 PM Database Restarted
> 11:00 PM Statspack Snapshot #34 shows Physical Reads = 100
>
> At this point a StatsPack Report comparing snapshot #33 to snapshot #34
> would claim that ?99900 physical reads had occurred. Actually the report
> would begin with this self-explanatory text:
>
> ERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALID
>
> It?s impossible to report across a shutdown, but it is possible to reduce
> the lost periods of time (10:00 to 10:15 and 10:20 to 11:00 in our
example)
> by automatically performing snapshots before shutdown and after startup.
> It?s easily done with BEFORE-SHUTDOWN and AFTER-STARTUP triggers.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ---------------------------------------------------------------- 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 Fri Jul 30 2004 - 11:49:52 CDT
 |
 |