How to trace a database transaction

[StickyBit]

Hi there,

Is there a way to identify the table(s) being used by a particular application? Perhaps, a way to log/audit all transactions made against a particular schema…I have an application that uses a database within my environment, and I would like to know which tables are being updated when a certain procedure is performed. Unfortunately, I don’t have access to the applications source code (otherwise I could easily find out), but I do have full access to the database.

Thanks.

 

[dbtoo2001]

Did you look at sql trace and tkprof?

Chapter 10 of the performance guide.
Using SQL Trace and TKPROF
The SQL Trace facility and TKPROF are two basic performance diagnostic tools that can help you monitor and tune applications running against the Oracle Server.

 

[StickyBit]

Thank you dbtoo2001, I will look at these utilities.