Re: Statspack 9.2

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Thu, 24 Aug 2006 08:36:15 GMT
Message-ID: <3ydHg.17125$rP1.5512@news-server.bigpond.net.au>

"delcenserie christophe" <tof_at_debian.linux> wrote in message news:pan.2006.08.24.05.00.17.443301_at_debian.linux...
> Le Wed, 23 Aug 2006 21:35:48 +0000, Richard Foote a écrit :
>
>> "delcenserie christophe" <tof_at_debian.linux> wrote in message
>> news:pan.2006.08.23.17.39.08.742119_at_debian.linux...
>>> Le Wed, 23 Aug 2006 02:45:46 -0700, rajesh_choprauk a écrit :
>>>
>>>> Does anyone know if it is possible to exclude SYS/Statspack SQL from
>>>> statspack report?
>>>
>>> show tkprof sys=no
>>>
>>
>> Hi Christophe
>>
>> You know how to tkprof a statspack report !!
>>
>> Hey that's really cool, imagine having a nicely formatted statspack
>> report
>> !!
>>
>> Care to share to us all how you perform this technological feat ?
>>
>> Cheers
>>
>> Richard
>
> Richard
>
> No whith statspack.
> alter session set sql_trace=true or package
> DBMS.SYSTEM.SET_SQL_TRACE_IN_SESSION
>

Hi Christophe

So it doesn't really help the OP much does it, since he specifically asked about eliminating recursive SQL from statspack (thread title rather gives it away).

I would also recommend DBMS_SUPPORT (or DBMS_MONITOR with 10g) rather than the DBMS_SYSTEM for tracing purposes. See metalink notes 377204.1 and 62294.1 for details.

Cheers

Richard Received on Thu Aug 24 2006 - 03:36:15 CDT