Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: STATSPAK Question

Re: STATSPAK Question

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 18 Feb 2005 22:11:49 +0000
Message-ID: <7765c8970502181411348fcd0b@mail.gmail.com>


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

Give us 3 days and I'll write up scheduling stuff on Windows on my site.

Meantime, I'd ask what the purpose of the snapshots were, if its to trend performance of the SYSTEM then an hour is fine, if its to diagnose problems I'd use a different method.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 18 2005 - 17:15:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US