Re: STATSPACK in 10g
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 9 Feb 2010 15:12:03 -0800
Message-ID: <a9c093441002091512r2914d558v21e34c699f93b54c_at_mail.gmail.com>
In early releases of 10.1 or 10.2 (cant quite recall) there were bugs related to running both AWR and STATSPACK that could cause contention for certain latches in the sql area. This was exacerbated by the fact that both snapshots ran at exactly the same time; at the top of the hour. Thus it was advised not to run both of them. I believe that these bugs have been all resolved in 11g.
Date: Tue, 9 Feb 2010 15:12:03 -0800
Message-ID: <a9c093441002091512r2914d558v21e34c699f93b54c_at_mail.gmail.com>
In early releases of 10.1 or 10.2 (cant quite recall) there were bugs related to running both AWR and STATSPACK that could cause contention for certain latches in the sql area. This was exacerbated by the fact that both snapshots ran at exactly the same time; at the top of the hour. Thus it was advised not to run both of them. I believe that these bugs have been all resolved in 11g.
On Tue, Feb 9, 2010 at 10:07 AM, Kellyn Pedersen <kjped1313_at_yahoo.com> wrote:
>
> "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!
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 09 2010 - 17:12:03 CST