cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Query/Statement Performance Comparison - Oracle Database Insights

Babar_Qayyum
Leader

Dear All,

Is there a way to compare (in the form of a custom chart/or a comparison chart) a Query/Statement monitored by the Oracle Database Insights?

Regards,

Babar

2 REPLIES 2

ryan_ott
Dynatrace Mentor
Dynatrace Mentor

Hi Babar, 

Absolutely - one way would be to use Multidimensional Analysis Chart capabilities to compare performance metrics for database requests. An example of this can be found on the 'Diagnostic Tools' page, under 'Top Database Statements'. This chart can then be filtered on for individual databases, requests, and timeframes.

For side-to-side comparison, there is also the 'Compare' tool. This option can be selected when viewing the database requests for a particular database, as seen in the screenshot below. This then allows you to compare response time, failures, and load for requests during different time frames. This page can also be filtered to individual requests.

Hope this helps.

-Ryan

ryan_ott_0-1626728391668.pngryan_ott_1-1626728401657.png

 

ACE Consultant, Dynatrace Services
Dynatrace Certified Professional

Hello @ryan_ott 

Thank you for your comments.

Basically, I wanted to know the method to compare the statements monitored by Oracle Database Insights and these considered as custom devices.

Regards,

Babar