Re: STATSPAK Question

Bryan,

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.

Stephen

On Fri, 18 Feb 2005 12:20:33 -0700, Bryan Wells <bunjibry_at_gmail.com> 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_at_gmail.com
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l