Tracing Oracle Reports
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tracing Oracle Reports

  1. #1
    Join Date
    May 2002
    Posts
    22
    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??

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    name of the trace file will have the unix pid appended in it
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width