Hi All, I am trying to trace another users session (10046 trace) by using DBMS_SYSTEM as mentioned in Cary's book my problem is though everything runs out fine the resulting trace file only shows the last line of my current SQL and doesnt report any SQL of the application I am trying to trace.I am enabling the trace form SQLPLUS while the application is Oracle Forms 6i.Any ideas the steps I have followed is exact replica of one shown in hotsos.Thanks Regards Arghadeep Chatterjee DBA "KSPL" ---------------------------------------------------------------- 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 -----------------------------------------------------------------