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 -> Skipping internal statements in Statspack??

Skipping internal statements in Statspack??

From: Shailesh <shailesh.saraff_at_gmail.com>
Date: 12 Apr 2006 04:01:35 -0700
Message-ID: <1144839695.455443.65500@t31g2000cwb.googlegroups.com>


Hello,

We are using Oracle 10.1.0.2 on windows 2000 SP 4. Statspack reports generated show lot of Oracle internally issued statements, I would like to know how to skip these statements and take only those which are executed by our application. TKprof has parameter SYS=NO to skip internal statements. Is there something in statspack?

Please let me know.

Thanks & Regards,

Shailesh Received on Wed Apr 12 2006 - 06:01:35 CDT

Original text of this message

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