See http://www.oracle-base.com/articles/10g/SQLTrace10046TrcsessAndTkprof10g.php RF Robert G. Freeman Master Principle Consultant, Oracle Corporation Oracle ACE Author: Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles Blog: http://robertgfreeman.blogspot.com ________________________________ From: Rich <richa03@xxxxxxxxx> To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx> Sent: Mon, March 1, 2010 6:15:45 PM Subject: Tracing a single SQL statement Hi all, This is 64-bit 10.2.0.4 on RHEL 5.1 (kernel 2.6.18-53). Is there any way to set 10046 and/or 10053 tracing on for a single SQL statement in another session without access to the SQL code? Thanks, Rich -- //www.freelists.org/webpage/oracle-l