Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.s-kddi1.home.ne.jp!news.home.ne.jp!newsfeed2.kddnet.ad.jp!newsfeed2.kddnet.ad.jp!news-east.rr.com!news.rr.com!newscon06.news.prodigy.com!prodigy.net!newsdst02.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!a25fe021!not-for-mail
From: Mladen Gogala <gogala@sbcglobal.net>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: executable to fix data doesn't appear to be doing anything..help
References: <1152277531.552150.89220@m79g2000cwm.googlegroups.com>   <1152279399.130211.148410@p79g2000cwp.googlegroups.com> <1152279931.394775.80960@s16g2000cws.googlegroups.com>
In-Reply-To: <1152279931.394775.80960@s16g2000cws.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 10
Message-ID: <LRurg.60691$Lm5.31263@newssvr12.news.prodigy.com>
NNTP-Posting-Host: 69.177.150.48
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr12.news.prodigy.com 1152285163 ST000 69.177.150.48 (Fri, 07 Jul 2006 11:12:43 EDT)
NNTP-Posting-Date: Fri, 07 Jul 2006 11:12:43 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: F[O]RY[ETBUQBFD[LZKJOPHAWB\^PBQLGPQRZ\YIJYWZUYICD^RAQBKZQTZTX\_I[^G_KGFNON[ZOE_AZNVO^\XGGNTCIRPIJH[@RQKBXLRZ@CD^HKANYVW@RLGEZEJN@\_WZJBNZYYKVIOR]T]MNMG_Z[YVWSCH_Q[GPC_A@CARQVXDSDA^M]@DRVUM@RBM
Date: Fri, 07 Jul 2006 15:12:43 GMT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270576

buccellik wrote:
> I did run the 10046 trace, and the trace file only contained all of the
> waits, as shown above.

What level? To see binds, you must use at least level 8. Maximum level 
is 12. Try with that. If you're on 10g, look into DBMS_MONITOR, it has
arguments signifying whether to show binds or not. If you're on 9i,
you can install DBMS_SUPPORT ($ORACLE_HOME/rdbms/admin/dbmssupp.sql)
which also contains the necessary information how to turn on binds.
Playing with the raw events is not for the fainthearted.