Discussions
Categories
- 382.6K All Categories
- 2.1K Data
- 213 Big Data Appliance
- 1.9K Data Science
- 448.4K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 541 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 499 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.8K Development
- 9 Developer Projects
- 130 Programming Languages
- 290.5K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 200 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 293 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 Portuguese
Capture Service Execute Time - sys_refcursor
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.
Answers
-
but it appears that the ref cursor is being executed AFTER the parameter is returned.
Not sure I quite understand. Can you explain in more detail what you're trying to achieve?
-
Below is an example of one of our services where we are returning a ref cursor. We are trying to capture how long the service is taking to execute. We attempted to put some custom logging at the start and end of this pl/sql block but the timings that returned were not accurate as the query in the ref cursor must be executed internally by ORDS. I know there are APM tools where you can monitor service performance, but we were trying to handle this without purchasing something.
-
There's two things you could be monitoring, the performance of the API call, so you could just simply look at the HTTPS response time, AND the database performance itself.
And you're asking about the database blocks running? If so, the Database already offers performance features for tracking these sorts of things. Active Session History could tell you quite a bit.
-
Thanks Jeff! Taking a look at active session history looks to be very promising so I really appreciate that tip!
Any tips or tricks on how to log and/or monitor https response time? Looking at devtools in the browser helps when working with a specific user at the time of the issue, but that doesn't allow us to go back and look at what has historically happened.
-
enable logging in jetty as Kris shows here
https://krisrice.io/2017-01-12-how-to-add-ncsa-style-access-log-to/
You would need to look into adding response times
https://stackoverflow.com/questions/5095835/how-to-enable-response-time-logging-in-jetty-7
