To get resonable results from the reports, your timing interval should
be around 10 to 30 minutes. As running statspack collection every that often
is likely to produce far too much data than you want to have space for, I
always recommend running statspack collection in a system like this
level 0 and level 5 as well as child-latch information.
Level 5 is the default.
Hope this helps.
Shaibal
From: Joe Raube <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: STATSPACK impact?
Date: Wed, 06 Feb 2002 13
Title: STATSPACK impact?
Just curious, but if your shop uses STATSPACK, could you tell me how frequently you run it,
particularly in your OLTP databases; and whether you've noticed any performance issues with
generating frequent STATSPACK snapshots?
Thanks
I have run it as frequently as once per hour,
often times just 2 or 3 times per day - morning, noon, close of business.
I have never seen any performance impact, and I don't believe there
will be any unless you change the default level of statistics gathering.
-Joe
On Wed, 06 Feb 2002
