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.
December 4, 2006 4:13 AM
December 4, 2006 5:17 AM