LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (https://www.linuxquestions.org/questions/programming-9/)
-   -   ORACLE - Tacking SQL all sessions for 1 user ? (https://www.linuxquestions.org/questions/programming-9/oracle-tacking-sql-all-sessions-for-1-user-731613/)

czezz 06-09-2009 04:49 AM

ORACLE - Tacking SQL all sessions for 1 user ?
 
I am trying to find out what SELECT is made by application. This application uses user: USER11.

I decided to turn on Tacking SQL and capture all SQL querys in particullar session for particular user.
The problem is that when I displayed all sessions for USER11 it displayed me 11 rows:

Code:

SQL> select sid, serial#, username from v$session where username like 'USER11';

      SID    SERIAL# USERNAME
---------- ---------- ------------------------------
        54      13146 USER11
        65        24 USER11
        71        241 USER11
      120      26345 USER11
      123      15818 USER11
      133      7428 USER11
      140      4998 USER11
      149      53796 USER11
      152      31046 USER11
      155      18639 USER11
      156      51703 USER11

It makes me really hard to find out which is used by me.
What I think it would be much easier to me to track all sessions for USER11. It would be even more desired.
But I dont know how to do it ?


All times are GMT -5. The time now is 03:26 PM.