Session Tracing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Session Tracing

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    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.

  2. #2
    Join Date
    Oct 2000
    Posts
    21
    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.

  3. #3
    Join Date
    Sep 2000
    Posts
    155

    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
  •  


Click Here to Expand Forum to Full Width