Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Capture Service Execute Time - sys_refcursor

Chad BoomOct 15 2021 — edited Oct 15 2021

We have services that return a ref cursor which then ORDS converts the output to JSON. We have some services that we are looking to capture start and end times. We added custom log procedures to the ORDS layer, but it appears that the ref cursor is being executed AFTER the parameter is returned. Is there any logging that we can enable to capture run time of an ORDS service? Specifically looking to capture the TTFB number that shows in the network tab of the browser.

image.png

Comments
Post Details
Added on Oct 15 2021
5 comments
122 views