15 Jul 2021
09:17 AM
- last edited on
12 Nov 2021
01:02 PM
by
Karolina_Linda
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
Solved! Go to Solution.
19 Jul 2021 10:00 PM
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
20 Jul 2021 08:58 AM
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