Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: executable to fix data doesn't appear to be doing anything..help
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. Received on Fri Jul 07 2006 - 10:12:43 CDT