Re: Statspack 9.2

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 23 Aug 2006 20:08:39 +0100
Message-ID: <pd2dnVqp180qOnHZRVnygQ@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.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/

Received on Wed Aug 23 2006 - 14:08:39 CDT