You are currently viewing How to Enable APEX Session Debugging from the GUI

How to Enable APEX Session Debugging from the GUI

In this Post

A user reported that a search request on an APEX page is taking longer than expected to return the result data. To analyze this specific user session, APEX Session Debugging has to be enabled. This post explains how to enable and disable it in detail.

Issue Faced

p5_issue_fcd

Enabling APEX Session Debugging through GUI

Login in as Workspace Administrator user in APEX.

p5_apx_lgn_pg

Navigate: Administration -> Monitor Activity -> Active Sessions

p5_apex_admn_pg
p5_apex_admn_pg1
p5_apex_admn_pg2

Click on the session with the user logged in.

p5_apex_ses_idf

Set Debug Level to APEX Trace.

Click Apply Changes.

p5_apex_ses_idf1
p5_apex_ses_trc_set
p5_apex_ses_trc_set1

Request user to re-produce the error.

p5_issue_repro_compl

Once done, set Debug Level back to Disabled for the specific session.
Click Apply Changes.

p5_apex_ses_trc_set1
p5_apex_ses_idf1

Scroll down to view the session activities for this session below.

Select and Click on the Debug ID for the request on page that was identified.

p5_apex_ses_debug_id_nw
p5_apex_ses_debug_det

Scroll down to view the collected information for that debug id.

Go to Actions > Columns and add other available columns to Display in Report

Click Apply.

p5_apex_ses_debug_actns
p5_apex_ses_debug_actns1

Navigate to Actions -> Download to download the report in available formats.

p5_apex_ses_debug_actns2

Download the report and provide it to developer/oracle support for evaluation.

p5_apex_ses_debug_actns3

End of Post

Thanks for taking the time to read this post.
Stay tuned for the next post coming soon. . .