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

From: joel garry <joel-garry_at_home.com>
Date: Tue, 29 Apr 2008 09:07:04 -0700 (PDT)
Message-ID: <a7712c4c-2905-4468-98a3-9e4397aa4d3c@z24g2000prf.googlegroups.com>


On Apr 29, 12:03 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Mon, 28 Apr 2008 11:28:26 -0700, joel garry wrote:
> > 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).
>
> Well, that's going to change. Nobody has commented on the elephant in
> the room and that would be the fact that Google, as one of the largest and
> most aggressive high-tech companies in the world, is not using Oracle.
> So, there is life without Oracle. I learned PgSQL and I am not sorry. I
> can even sell consulting for conversion of small databases from Oracle to
> PgSQL.
> With a problem like Google, Oracle doesn't need disloyalty and ill will
> among the consultants who used to be its loudest proponents and the most
> effective sales force. I only hope that Google will adopt PgSQL and renew
> the sense of competition among the databases.
>
> --
> Mladen Gogalahttp://mgogala.freehostia.com

Funny about that google. I was poking about last night on the Brad Templeton remembrances about spam (30th anniversary Thursday!) and the early days of usenet. I was kind of bummed that some of the links he posted were bad. Eventually I landed on the google page that has links to memorable early posts they had posted when they first absorbed dejanews, and was a bit surprised to find they didn't work either. Trying them several times, I would get different error messages like page does not exist, message such-and-such doesn't exist, then suddenly they would. I'm guessing they have a gradation of off-line-ed-ness, and don't really handle the error messages of the various changing states correctly. Or maybe they're just stupid. Since they are giving the messages, the messages change, it's their links, and it sometimes doesn't work and then does (without me emptying cache or anything), I can't see how it possibly can be something I'm doing wrong.

Remember that the next time someone wants to do something important with some competition-enhancing db. Someone posted on comp.risks about getting their neighbors tax info from some online tax software, and I've posted somewhere about getting and changing someone else's online Oracle DBA resume (not a domain/IP sharing issue, they were on a different ISP). Un-freaking-believable is all I can say.

Doesn't anybody have any definitive knowledge on what google uses for their financials? Could it be... http://storagemojo.com/2007/07/27/508/ the cheapest Oracle implementation ever?

jg

--
@home.com is bogus.
http://www.templetons.com/brad/spamreact.html#msg
Received on Tue Apr 29 2008 - 11:07:04 CDT

Original text of this message