Monday, January 28, 2013

Oracle EBS Tracing



1)Tracing form based form:
->open the form:help:diagnostics:trace:trace with waits
-Trace will be generated in udump.
- perform some transaction
->Disable the trace
help:diagnostics:trace:notrace
->Use tkprof to convert the trace file to understandable format.
$cd $ORACLE_HOME/admin/PROD_node11/udump
2)Tracing html based form:
->Enable Diagnostic menu
nav:profile:system
profile: FND_Diagnostics
Site: Yes

->To trace html based application.
Click on diagnostics
Diagnostics: Set Trace Level
* Trace with waits
* Disable trace
-> Go to Udump & use tkprof
3)Tracing Concurrent Program:

nav: Concurrent:Program:Define (Query the CP. ex: Active Users)
* Enable Trace & save
- Run the CP
- Disable the trace & save
- Go to udump & use tkprof utility.

No comments: