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? 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. -- //www.freelists.org/webpage/oracle-l