Re: Statspack snapshot triggers

  • From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 10 May 2004 17:59:13 -0400

Hi Aaron, definetively no,
You must remember to take this report for a short time, otherwise the
statistics are averaged and lose sense. The time should be, the time the
problem is present; if it the problem is present all the time, ten minutes,
should be enough.

Even more when you want to compare one snapshot with another, you have to
compare snapshosts related to the same process being run , or database
worload being processed.

Juan Carlos Reyes Pacheco
Database 9.2 Standard Edition

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: