Oracle sql statement log

Pingsc
pts.
Tags:
Oracle
Oracle administration
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
Asked: Last updated:
Related Questions

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: