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

• Post for FREE via your newsreader at post.usenet.com ****

Hi Sybrand

> Apparently you still contradict there is a cartesian product in the
> original query. This is telling about your lack of knowledge of SQL,

I really don't see why a cartesian product between two row sources with 1 row (ok, in one case after a sum) can lead to wrong computation. Please, explain me, I would really like to understand. I'm serious about that, please, explain me!

> and also about your audacity to keep contradicting someone with 15
> years experience in Oracle, when you could have known you are just
> plain wrong.

If you think because you have 15 years of experience you can't be contradicted, you missed something important in your job: modesty. I'm working with Oracle since 1995, but I like to be contradicted and challenged every single day! This is the only way to get better.

Therefore, I'm sorry. Simply saying that I'm wrong without proving why, it's not the way to go.... I mean, if the statement is wrong, it should not be difficult to execute it along with some others and post the result.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=