How to generate Form Level Trace and AR Debug log for diagnoses

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to generate Form Level Trace and AR Debug log for diagnoses


Solution:



How to generate Form Level Trace and AR Debug log for diagnoses:

Step 1 Setup AR Debug log per Note 152164.1 How To Create A Debug Log File
In An AR Form.

Step 2 Setup Form Level trace

a) Navigate to the form where problem occurs. Begin duplication steps but
Stop steps just before problem occurs.

Goto menubar, Help/Diagnostics/Trace, Select 'With binds and waits'

b) Continue with steps to recreate problem/error. Then Immediately turn
off trace. Goto menubar, Help/Diagnostics/Trace, Select "No trace"

c) How to obtain Trace file if no location/filename were provided when
enabled Trace:

Run script in SQLPlus for trace file location:

SELECT value FROM v$parameter
WHERE name='user_dump_dest';

d) Upload raw and TKprof'd Trace and AR Debug log to this Service Request

References:


Note 152164.1

Get Oracle Certifications for all Exams
Free Online Exams.com