Which Oracle Management Cloud service and function can …

Which Oracle Management Cloud service and function can help diagnose past performance of a SQL
statement?

Which Oracle Management Cloud service and function can help diagnose past performance of a SQL
statement?

A.
Log Analytics: Resource Analytics > Database calls

B.
Application Performance Monitoring: Display SQL > Top SQL Hogs

C.
IT Analytics: Performance Analytics > Database

D.
IT Analytics: Data Explorer

E.
Application Performance Monitoring: Resource History > Top SQL

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

M

M

Answer: C
resource: https://docs.oracle.com/en/cloud/paas/management-cloud/itacs/introduction-it-analytics.html#GUID-26BAEC5F-09C0-4345-8F46-722DBD5267A2

Performance Analytics:
Database Performance Analytics: Perform a historical, comparative analysis to find any bottlenecks affecting enterprise-wide database performance. With Performance Analytics: Database, you can determine the root cause of recurring systemic problems, identify the performance profile and activity types for CPU or I/O intensive database activities, and analyze SQL queries across multiple databases to identify which SQL statements consume the most database time and to help understand the trend of each query’s performance.

Reply