Re: STATSPACK in 10g

From: Kellyn Pedersen <>
Date: Tue, 9 Feb 2010 10:07:11 -0800 (PST)
Message-ID: <>

"You have to use AWR and disable STATSPACK. "

Why do you have to disable statspack if you are licensed for AWR?  I had both running at a previous company.  I preferred the AWR reports, being the new DBA and the other DBA was into his statspack reports, (I work with him again here at I-behavior, so he's since converted to AWR... :))  The snapshot ID's are completely different for each, use different views and I never had them interfere with each other in anyway in regards to reporting purposes...  
Please elaborate, I'm curious... Thanks!

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
"Go away before I replace you with a very small and efficient shell script..."

  • On Mon, 2/8/10, Surachart Opun <> wrote:

From: Surachart Opun <> Subject: Re: STATSPACK in 10g
Cc:, "" <>, "" <> Date: Monday, February 8, 2010, 8:59 PM

>If licensed for Diagnostics Pack, does it make sense to run both AWR & STATSPACK?
You have to use AWR and disable STATSPACK.

and AWR have more feature than STATSPACK.

Surachart Opun

On Tue, Feb 9, 2010 at 2:45 AM, Jonathan Intner <> wrote:

Hi All:

Not meaning to "hijack" this thread, but I have a question/comment that I think is related. The question is:

If licensed for Diagnostics Pack, does it make sense to run both AWR & STATSPACK? I would actually argue that if AWR is available STATPACK is redundant. I'd love to hear what other folks think. If I get a number of private replies, I'll summarize the results for the list.

Thanks in advance,


On Mon, Feb 8, 2010 at 11:25 AM, Allen, Brandon <> wrote:

Statspack works great in 10g – I’ve used it extensively.  


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Tue Feb 09 2010 - 12:07:11 CST

Original text of this message