Re: STATSPAK Question

  • From: stephen booth <stephenbooth.uk@xxxxxxxxx>
  • To: bunjibry@xxxxxxxxx
  • Date: Fri, 18 Feb 2005 22:10:07 +0000

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

Other related posts: