Re: STATSPAK Question

  • From: Stephen Andert <andert@xxxxxxxxx>
  • To: bunjibry@xxxxxxxxx
  • Date: Fri, 18 Feb 2005 14:15:30 -0700


We usually do 1 hour intervals.  If we have a problem, we will take
more often snaps for awhile until we identify the problem.

I don't use Win for Oracle, but you should be able to use dbms jobs to
schedule this and that should be a good way to do it.  I use crontab
in unix.


On Fri, 18 Feb 2005 12:20:33 -0700, Bryan Wells <bunjibry@xxxxxxxxx> wrote:
> All...
> I am finally getting around to using this utility.  I have a 200+gb DW
> on w2k.  My question is there a good interval to use initialy?  i know
> doc id 149121.1 suggests one hour intervals but, since I am still a
> Newbie, Jr. whatever, I want to identify as much as possible to begin
> with, trouble shoot, fix, etc... then move my interval out.  is this a
> good thing to do?  bad?  is there a way outside of AT to schedule this
> so, durrng the day I use a 1hour interval, and durring nightly loads i
> use say a 15min or less interval?
> Thank you in advance for your suggestions
> --
> Bryan S Wells - DBA Newbie
> bunjibry@xxxxxxxxx
> --

Other related posts: