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 ?