Re: Statspack 9.2

From: delcenserie christophe <tof_at_debian.linux>
Date: Thu, 24 Aug 2006 20:00:17 +0200
Message-Id: <pan.2006.08.24.18.00.16.763752@debian.linux>

Le Thu, 24 Aug 2006 08:36:15 +0000, Richard Foote a écrit :

> "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

I did not know. I will look at that. Thank you for your help.

Christophe Received on Thu Aug 24 2006 - 13:00:17 CDT