Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
04-29-2021 05:14 AM
I have a requirement for reporting on the performance of a specific query in Oracle. The performance of this query serves as a proxy for the performance of a very old Oracle Forms application. I have been looking for a way to gather this data but so far have not been able to find a way to do it in AppDynamics.
The query needs to be executed every five minutes and performance data needs to be reported on this query. So far, I have looked at the SQL extension and Custom Metrics from the database agent. Both of these options would give me the ability to submit the query, but neither of them seems to gather execution times for these queries. I have looked at trying to write an SQL in Oracle that would return timing for a query but I have not been able to find something that will work.
Does anyone have any suggestions?
Solved! Go to Solution.
05-11-2021 06:17 AM
on MS SQL we use Last Elapsed time parameter for a query.
So we retrieve it by running once in a minute a request for "Procedure X " Last Elapsed Time, recorded by the DB server itself,
Probably Oracle has something similar
06-07-2021 09:01 AM
Thanks for the idea.
Unfortunately, I have not been able to identify functionality in Oracle that returns elapsed time without knowing the SQL_ID of the query.
I am going to keep looking at options.
Thanks!
06-09-2021 07:47 AM
I have experimented with multiple ways of monitoring the time of an SQL execution in Oracle.
I have decided to create my own monitor within the machine agent. My monitor calls a linux shell which in turns calls a Java program that times the execution of the SQL call. This implementation is on machine agent 21.5.x. I have selected this approach so that I can select which Java JRE is invoked and to be able to specify the command line arguments (including classpath to get the Oracle jdbc jar included).
Please feel free to contact me if you would like more details on my approach.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form