Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shared Pool: Can it be filled *over* 100% ?

Re: Shared Pool: Can it be filled *over* 100% ?

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 14 Aug 2004 19:17:25 -0700
Message-ID: <9711ade0.0408141817.341c55a9@posting.google.com>


"omlet" <notrolls_at_notrolls.omlet.org.notrolls> wrote in message news:<716fc3aafefe2c796d134e7794bf86de_at_localhost.talkaboutdatabases.com>...
> Opt for a script-less world! Leave the monitoring for the profs!
>

Take your own advice and leave the monitoring to the professionals who know what they are doing. You'll be much better off, and so will we.

> Get a copy of OMLET now! or be sqaured. "There ain't no SQL now near here
> now you hear"
>

That is an interesting statement. You're saying you have absolutely NO SQL queries hitting any database you monitor. If that is true, why do you 'need' copies of many of the x$ views, duplicating data already found in the database? Would not synonyms suffice? Or are synonyms not 'professional' enough for you? Your omlet$ views add nothing to the values found in the corresponding x$ views, so why do you create them? I tried your OMLET, with your views and with synonyms in place of them and found no difference in performance. Of course, there wasn't much in the way of performance to begin with. But I did prove your omlet$ views worthless to the application. I can only imagine they are the fruit of arrogance and necessary for your self-importance. But, that should be obvious to all who have read your posts.

Oh, I've since trashed your OMLET as worthless. As have many others who have downloaded it and found it disappointing at best.

David Fitzjarrell Received on Sat Aug 14 2004 - 21:17:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US