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: delcenserie christophe <tof_at_debian.linux>
Date: Thu, 24 Aug 2006 07:00:18 +0200
Message-ID: <pan.2006.08.24.05.00.17.443301@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 Christophe Received on Thu Aug 24 2006 - 00:00:18 CDT

Original text of this message

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