How to track all queries submitted to Oracle DB from app server? [duplicate]
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