Hi All,
We're trying to capture tkprof of APEX page process to get complete picture of what's happing from APEX page to DB and would like to understand the complete picture.
following things we tried but its only capturing the APEX page query but not the process code which is calling DB API.
- Enable Full trace from APEX
- Perform SAVE action which calling DB API to save the record.
- try to see the debug log but we have only found report SQL with explain plan but nothing from DB API which is calling on SAVE button.
we need full picture from DB API as well in APEX debug logs to solve performance issue otherwise every time we need to goto SQL developer and run DB API separately.
Please suggest if anything we can do here to get tkprof from APEX page process to get full picture from APEX and DB both.
you can take any example like one button on APEX page lets say SAVE and on click of SAVE its calling process which basically calling db api to save the record. in my case db api is having very huge code and calling multiple pkgs inside.
APEX version: 21.1
DB version: 19c
Thanks