Oracle sql statement log
Hi,
We're currently trying to debug an application that is running queries thru jdbc/oci against our oracle 9.2 DB.
While we have no way of finding out what is going on in the application we would like to trace all the sql statements that are run against our database (including 'select' statements). Is there someway we can do a 'snoop' or some logfile we can view that will tell us what queies were run? It is important that we capture plain 'select' statements aswell.
thanks,
pingsc
Software/Hardware used:
Software/Hardware used:
ASKED:
December 4, 2006 4:13 AM
UPDATED:
December 4, 2006 5:17 AM
Answer Wiki:
Hi,
For sure you can either use net trace or sql trace.
With the net trace one can generate log on the client side or the server side.
With the SQL trace you can generate a log only on the server side.
Read the documentation for further details
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
(I suggest the Master Index to start with)
or look for these terms "Oracle tracing" "Oracle net tracing" "oracle sql trace" in your preferred web search site.
Regards,
Kojak
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
