Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Applications Tracing

Applications Tracing

From: Robert M. Kopf <rkopf_at_mapmobile.com>
Date: Tue, 03 Aug 1999 17:31:15 GMT
Message-ID: <7o7913$qer$1@nnrp1.deja.com>


Is there a way to trace all SQL that is being sent between an Oracle Applications client and the database server? I have tried to use the Trace functionality on the Apps Help menu with little success. Specifically, I am trying to trace the queries executed when a report is run. I have copied the SQL out of the report and run it in SQL*Plus with the same parameters as wehn run from Applications. However, I receive no rows of data.

Any assistance is greatly appreciated.

--
Robert Kopf
Map Mobile Communications, Inc.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 12:31:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US