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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Aug 2006 10:00:10 +0200
Message-ID: <t2nqe21l98p3n002bg95tofggtcnsofubb@4ax.com>


On Thu, 24 Aug 2006 07:00:18 +0200, delcenserie christophe <tof_at_debian.linux> wrote:

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

You are aware the data tkprof produces are session specific and statspack is database wide?
Don't you think you are confusing apples for pears?

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Aug 24 2006 - 03:00:10 CDT

Original text of this message

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