Re: library cache miss ratio very high - how to find out the rot cause
From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 27 Apr 2008 10:16:35 -0700
Message-ID: <1209316594.400665@bubbleator.drizzle.com>
>
> That is true. Unfortunately, statspack is slowly going out
> and AWR is not free. I hope that Oracle is making enough money
> from the diagnostic pack to offset the ill will and annoyance
> created by charging for something that used to be free. You
> see, AWR is just the next release of statspack.
Date: Sun, 27 Apr 2008 10:16:35 -0700
Message-ID: <1209316594.400665@bubbleator.drizzle.com>
Mladen Gogala wrote:
> On Tue, 22 Apr 2008 07:27:05 -0700, Mark D Powell wrote:
>
>
>> 1 - Use of the AWR requires a tuning pack license.
>
> That is true. Unfortunately, statspack is slowly going out
> and AWR is not free. I hope that Oracle is making enough money
> from the diagnostic pack to offset the ill will and annoyance
> created by charging for something that used to be free. You
> see, AWR is just the next release of statspack.
StatsPack is no more going away than ANALYZE TABLE, DBMS_JOB, and the LONG RAW data type.
Nor do I detect any ill will or annoyance anywhere other than in this group. Those that want to you StatsPack will likely be doing so until the day they retire from our industry.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Apr 27 2008 - 12:16:35 CDT