Forum Stats

  • 3,781,116 Users
  • 2,254,481 Discussions


Capture Service Execute Time - sys_refcursor

Chad Boom
Chad Boom Member Posts: 130 Blue Ribbon

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.