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: Statspack 9.2

Re: Statspack 9.2

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Wed, 23 Aug 2006 21:32:42 GMT
Message-ID: <_P3Hg.16763$rP1.15283@news-server.bigpond.net.au>


"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:pd2dnVqp180qOnHZRVnygQ_at_pipex.net...
> Richard Foote wrote:
>> <rajesh_choprauk_at_yahoo.co.uk> wrote in message
>> news:1156326346.844663.42560_at_m79g2000cwm.googlegroups.com...
>>> All,
>>>
>>> Does anyone know if it is possible to exclude SYS/Statspack SQL from
>>> statspack report?
>>>
>>
>> Hi Rajesh
>>
>> Why ?
>>
>> If it's SYS/statspack SQL that's causing a problem wouldn't you want to
>> know and if it isn't then statspack won't highlight it and so what's the
>> problem again ?
>
> Perhaps because doing anything about recursive SQL in 9.2 can be somewhat
> limited? Admittedly I can think of lots of cases where recursive SQL
> points up bad design, but there will be cases where all you can do (in a
> supported way) is say
>
> "yep that's the problem right there". and that's it.
> --

Hi Niall

But if recursive SQL is showing up in your statspack reports and is potentially a system-wide problem, wouldn't you want to know about it rather than having a statspack report that misses vital data and going "I've no idea what the problem is, it's *not* right there".

If it gives you the ability to actually go, "yep that's the problem right there", then that's justification for wanting to keep it the way it is.

Also recursive SQL is caused by "something", you might not be able to directly change the recursive code but you would most certainly be interested in knowing in what that "something" is perhaps and do something about the "something" (or something like that ;)

Cheers

Richard Received on Wed Aug 23 2006 - 16:32:42 CDT

Original text of this message

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