Re: Incompetent Test Manager---Phoenix---jobid G2121

From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: Fri, 8 Oct 2010 00:46:40 -0700 (PDT)
Message-ID: <a80912ea-4e11-47f8-b397-3133a54cd3ba_at_d25g2000yqc.googlegroups.com>

On 4 okt, 23:45, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Mon, 04 Oct 2010 21:15:07 +0200, Gerard H. Pille wrote:
> > Oh yes you did, with your unicellular brain.
>
> Now, if I had to decide who has a unicellular brain, you or Nuno, my vote
> goes to you, without a moment of hesitation. You are number one. In this
> case, that is not a compliment.
>
> --http://mgogala.byethost5.com

ah, Mladen, if you've got nothing better to do, please correct this script on your mentor's website, if you can find the errors (apart from the missing or unusable quotes, the select contains two syntax and one logical error)
It can be found on page t_session_cached_cursors_optimal_size.htm I wonder why you guys publish such monsters. Would anyone seeing this, ask you for consultancy?

col c1 heading “SID”
col c2 heading “Cache|Hits”
col c3 heading “All Parsing”
col c4 heading Un-used Session|Cached Cursors”

select

   sid         c1,
   stat1.value c2,
   stat2.value c3,

   stat2.value c4
from

   v$sesstat  stat1,
   v$sesstat  stat2,
   v$statname name1,
   v$statname name2

where

   stat1.statistic# = name1.statistic#
and

   name1.statistic# = name2.statistic#;
and

   name1.name = 'session cursor cache hits' and

   stat2.statistic#=name2.statistic#
and

   name2.name= 'parse count (total)'
and

   stat2.sid= stat1.sid Received on Fri Oct 08 2010 - 02:46:40 CDT