调试Oracle发送的Oracle查询

Question

I have a large PHP program that interacts with an Oracle DB. There are obviously view pages and pages that are more for program logic. Some of my logical pages need to be debugged.

I have Oracle queries being executed from some of these pages. How can you see what queries are being sent to Oracle? Printing queries from these types of pages doesn't seem to work i.e. nothing is printed. Is there some sort of Oracle log file that I can look at?

Thanks very much :).

Answer 1

You can turn on tracing for the session and look at the trace files created in the database's user_dump_dest directory, assuming you have access to the database server and permission to view those. There's an overview of the deprecated sqltrace method, and the docs for that; and the newer DBMS_MONITOR.

I'd start by looking at the application tracing tools Oracle provide.