Home » Oracle » 1z0-070 » Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?
You applied patches to both the storage servers and the database servers in your Exadata X6 Database Machine.
You use Database Replay for a 90-minute workload to verify that there are no performance regressions after applying the patches.
Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?
A. cellcli list metriccurrent
B. SQL Access Advisor
C. cellcli list alerthistory
D. SQL trace using dbms_monitor
E. cellcli list metrichistory
Correct Answer: ABD
Explanation/Reference:
Reference:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html#GUID-9003D6A0-2113-4846-9471-572A0CFBAD9E https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/introduction-to-sql-tuning.html#GUID-B237A2A2-7CA2-4AC9-B81C-71C5757C20B2
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/performing-application-tracing.html#GUID-33FA4E54-C759-480B-A075-CF75E6D85CAD
Download Printable PDF. VALID exam to help you PASS.
|
|