Oracle 1Z0-1111-23 Exam Questions

Two actions that can be performed using the Database Management Service in OCI are:

Compare Database performance across different time periods or perform real-time monitoring of SQL statements. Database Management Service provides various tools and dashboards that let you compare and monitor the performance of your databases and SQL statements. You can use Performance Hub to view real-time and historical performance data of your databases. You can also use SQL Monitor to view real-time and historical execution details of your SQL statements.

Analyze and Tune SQL performance issues of Oracle Databases on-premises, OCI and Multi-Cloud environment. Database Management Service provides various features and functions that let you analyze and tune SQL performance issues of your databases across different environments. You can use SQL Tuning Advisor to get recommendations for improving SQL performance. You can also use SQL Performance Analyzer to compare the performance of SQL statements before and after a change.

To quickly identify the details of all users who were active in the last six hours along with any REST API calls that were executed, you can use Audit Analysis Dashboard. Audit Analysis Dashboard is a feature of Audit service that provides a graphical representation of audit events and trends. You can use Audit Analysis Dashboard to view charts and tables that show various metrics and dimensions of audit events, such as user activity, resource activity, operation types, or error codes.

Two functions that the Trace Explorer allows you to do in APM are:

View the details of specific spans. Trace Explorer is a tool that lets you view and analyze the traces and spans collected by APM. You can use Trace Explorer to drill down into the details of specific spans, such as duration, status, tags, logs, and errors.

Select pre-defined queries for common use cases. Trace Explorer also provides a set of pre-defined queries that can help you find traces and spans based on common use cases, such as slowest traces, error traces, or traces by service name.

After Management agents are set up and resources are discovered, metric data is immediately collected. Management agents are lightweight processes that collect and send metric data from your resources to OCI services, such as Monitoring, Logging, or Stack Monitoring. Once the resources are discovered by the discovery service, the metric data is immediately collected and available for monitoring and analysis.

The different metric namespaces used for APM are oracle_apm_rum, oracle_apm_synthetics, and oracle_apm_monitoring. A metric namespace is a unique name that identifies the source of the metrics. For APM, there are three metric namespaces that correspond to the three features of APM: Real User Monitoring (oracle_apm_rum), Synthetic Monitoring (oracle_apm_synthetics), and Application Performance Monitoring (oracle_apm_monitoring). You can use these metric namespaces to query and analyze metrics from APM. For more information, seeAPM Metrics.