-
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...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|