-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|