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

From: joel garry <>
Date: Mon, 28 Apr 2008 11:28:26 -0700 (PDT)
Message-ID: <>

On Apr 27, 10:16 am, DA Morgan <> wrote:
> 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.

You haven't looked. I am not the only one who thinks AWR should be free, commie-pinko-socialist as that may sound, and many more think it should be available to SE customers, some to the point of writing open letters to Larry and starting online petitions. I can't think of any commercial soft wares that have not been obsolete when declared "stable." (I'm not using any funny economics definition of obsolete, I mean the one generally used in this context).


-- is bogus.
Received on Mon Apr 28 2008 - 13:28:26 CDT

Original text of this message