How to use SQL Tracker for SQL Statements issued by an Oracle Apex Application

Toad for Oracle & DevOps Toolkit
1

Hi All,

Does anyone know if / how to use SQL Tracker to see all the SQL Statements issued by an Oracle Apex Application?

I'm using Toad for Oracle 2025 R1 (25.1.20.5192) and database is Oracle 19c. Using APEX version 22.1.7

Thanks

2

SQL Tracker will only record apps that connect using an Oracle client. I don't know how APEX apps connect, but that could be the problem if it's not working.

3

Oracle APEX apps run through the Web Browser such as Chrome or Edge.

4

Oh yeah, that's right. Do they connect with Java? I don't think SQL Tracker can track that.

5

Denis,
I believe the APEX debugger is your best route. Set the debug level such that you get the actual SQL.