Re: STATSPAK Question

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?

Your best bet might be to schedule your daytime snapshots hourly then ammend your load scripts to delete the job at the start, spawn a SQL*Plus session and do a snapshot as needed, then recreate the job at the end.

Stephen

-- 
It's better to ask a silly question than to make a silly assumption.
--
http://www.freelists.org/webpage/oracle-l