log sql queries?
queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 17, 2009 5:14 PM
UPDATED:
April 17, 2009 7:55 PM
Answer Wiki:
Try this:
<pre>SELECT
username users, sql_text, Executions, loads, users_executing
FROM
sys.v_$sqlarea a, dba_users b
WHERE
a.parsing_user_id = b.user_id
AND b.username LIKE UPPER('%&user_name%');</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
