How to track all queries submitted to Oracle DB from app server? [duplicate]

Question

Possible Duplicate:
Oracle: is there a tool to trace queries, like Profiler for sql server?

I am using JDBC to talk to Oracle. Are there any ways or external tools that I can track all SQL queries submitted to Oracle DB server from app server during one session? This should be very great debug / bug tracking tool.

Answer 1

You can use JDBC (Enabling and Using JDBC Logging) logging feature.

Answer 2

You can try JProfiler. Its JDBC probe shows you all SQL statements in the events view:

It works for all JDBC drivers, including Oracle's. Also, the hot spots view of the probe is useful to determine which queries take most of the time.

Disclaimer: My company develops JProfiler