On 2/26/07, William Wagman <wjwagman@xxxxxxxxxxx> wrote:
Greetings, I am trying to turn tracing on for another users session in order to track down some difficulties. The session is coming from a web application which will allow updates to data within the database. I can see the users session and the osuser displayed in the v$session view is NETWORK?SERVICE. I turn on tracing for this session using dbms_system.set_sql_trace_in_session, the user proceeds, receives an ORA-00942 but no trace file appears. Quite understand what is going on and am hoping someone can shed some light on the situation. Thanks. Bill Wagman Univ. of California at Davis IET Campus Data Center wjwagman@xxxxxxxxxxx (530) 754-6208 -- //www.freelists.org/webpage/oracle-l
It could be either that you are tracing the wrong session or dbms_system.set_sql_trace_in_session is not working in your case. I've heard reports that it does not work when a session is active. Try oradebug, I use it quite frequently. Pete has a good writeup on various ways to set trace: http://www.petefinnigan.com/ramblings/how_to_set_trace.htm -- Anurag Varma