Tracing Oracle Reports

[scottie]

I'm having problems with a query running in Oracle Reports ver 6. I want to be able to trace this session to find out what exactly its doing. ANY HELP??

[stecal]

Include the following line in the report binary:
dbms_session.set_sql_trace(true);
(don't forget to recompile)

Where to put it? In Forms, I may place it in the form when-new-form-instance trigger. If I have a better idea of where a problem is occurring, I'll put it in a procedure so as to minimize the size of the trace file.

Where do you find the trace file? If you haven't set the dump dest parameter, you can find the trace file in ORACLE_HOME/rdbms/log.

What is the name of the trace file? Good guess, but if you sort or list the files in that directory, more than likely it will be the newest file.

[stmontgo]

name of the trace file will have the unix pid appended in it