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

From: joel garry <joel-garry_at_home.com>
Date: Mon, 28 Apr 2008 11:28:26 -0700 (PDT)
Message-ID: <934e9b83-0cda-4db3-af1e-88dee70f9b88@m1g2000pre.googlegroups.com>


On Apr 27, 10:16 am, DA Morgan <damor..._at_psoug.org> 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).

jg

--
@home.com is bogus.
http://www.marilynvossavant.com/articles/logic.html
Received on Mon Apr 28 2008 - 13:28:26 CDT

Original text of this message