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'; 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. |