Re: library cache miss ratio very high - how to find out the rot cause

From: DA Morgan <>
Date: Sun, 27 Apr 2008 10:16:35 -0700
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sun Apr 27 2008 - 12:16:35 CDT

Original text of this message