Infrastructure (Server, Network, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I monitor the performance of a specific Oracle query?

Dale.Chapman
Producer

How can I monitor the performance of a specific Oracle query?

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?

How can I monitor the performance of a specific Oracle query?