Oracle sql statement log

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

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following