|
|
 Re: Trace file not generated in apps [message #113436 is a reply to message #112917] |
Sun, 03 April 2005 05:52  |
vaddadi_cisco
Messages: 3
Registered: April 2005
Location: india
|
Junior Member |
|
|
The following information would be useful in case you need to take a trace file for your concurrent program.
->In the System Administrator responsibility, check the checkbox 'Enable Trace' for the concurrent program.
Run the concurrent program from apps and note down the request id.
Run the following query
select oracle_process_id
from fnd_concurrent_requests
where request_id = &Your_request_id;
This would return the process id/session id for your concurrent program.
Now go to the trace directory ( in SJDV11 the trace files are stored in /oracle/admin/SJDV11/udump). There would be a file in this directory having the process id as a part of its file name.
Usually the file name would be
ora_<oracle_process_id>_<instance_name>.trc (for eg ora_12345_sjdv11.trc)
After this you can do a tkprof for the trace file to get the explain plan and time statistics.
Hope you find this information useful.
Rgds
A
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
