Session Tracing

[rpardip]

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.

[ECG]

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.

[rpardip]

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.