> I am able to locate the session. I enable the trace, have some sql > executed and then disable the trace. No trace file is produced. > Tracy, There are several methods to enable extended SQL trace in another session. I suggest you download 'How to Activate Extended SQL Trace' from www.hotsos.com, and try the other methods. I have at times found that one method would not work for me, while another one would. The symptoms were the same as you describe, no trace file produced. HTH Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------