-
What's the easiest and fastest way to trace sessionS of a particular user ???
I have a user schema in the DB and lot of concurrent sessions would be opened
and closed simultaneously. I want to trace all the SQLs generated by
this user shcema.
Thanks in advance.
-
select the sid and serial# from v$session.
THen, connect as sys. Execute dbms_system.set_sql_trace_in_session(sid, serial#, 'TRUE');
The trace file is created in the user_dump_dest directory specified in the init.ora file.
execute the same command with FALSE to stop tracing.
-
ECG, thanks for replying. However, I knew this method and also the method to perform instance tracing.
Here, I am specifically referring to tracing of simultaneous sessions (as user SCOTT). For eg: a typical web based application.
Any help would be appreciated.