-
HI..
JUST A QUERY CAN ANY BODY HELP ME
I WANT TO SEE THE SQL QUERIES FROM AN APPLICATION
WHICH ARE EXECUTED IN THE ORACLE DATABSE
IS THERE ANY WAY TO SEE WHAT ALL QUERIES ARE EXECUTING ON THE DATABASE FROM A PERTICULER APPLICATION FOR A PERTICULER USER
PLEASE GET BACK
THANKS AND REGARDS
BAKSHI
-
you can join v$session and v$sqltext
-
Or, you can attach a trace to the session once the application has already started by using dbms_system.set_sql_trace_in_session. See http://otn.oracle.com/docs/products/...4_str.htm#8760 for details...
