Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost PERFSTAT bridge scripts Found it

RE: Lost PERFSTAT bridge scripts Found it

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Fri, 30 Jul 2004 11:32:01 -0500
Message-ID: <433A07749711884D8032B6A0AB115262C2BCDB@conmsx07.corp.acxiom.net>


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.



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
-----------------------------------------------------------------


**********************************************************************
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US