1Z0-997-25 Question 89
Select 2You manage an Oracle Database running on an OCI VM DB System that was previously stable. Recently, queries that used to complete in seconds are taking minutes or longer. You suspect an underlying performance issue impacting the database. Which two actions should you take first to investigate and address the performance degradation?
- A
Review the OCI console for database system metrics like CPU utilization, storage IOPS, and memory usage to pinpoint potential resource bottlenecks.
- B
Immediately scale the DB System shape to a larger one without further investigation.
- C
Generate and analyze an AWR or ADDM report to identify the top wait events and problematic SQL statements.
- D
Terminate the existing DB System and create an entirely new one from a backup.
Show answer and explanation
Correct answers: A, C
Explanation
When Oracle databases experience performance issues on OCI, the recommended approach is to gather diagnostics first. Key steps include examining metrics in the OCI console and generating AWR/ADDM reports to identify resource constraints or SQL inefficiencies. Terminating or scaling the DB System prematurely can hide or destroy evidence of the root cause. Refer to Oracle� documentation on 'Monitoring DB System Performance' and 'Oracle Database Performance Tuning Guide' for best practices and detailed steps on how to properly diagnose and fix performance problems.
- A. Correct.
Correct. Checking database metrics in the OCI console is a crucial first step. It helps confirm if there's a sudden increase in CPU usage, storage I/O bottlenecks, or memory pressure, which can guide further investigation.
- B. Incorrect.
Incorrect. Scaling up might temporarily mask the underlying performance issue but doesn�t address the root cause. Proper diagnosis should precede any resource expansion.
- C. Correct.
Correct. AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) reports quickly provide insights into top SQL statements, wait events, and performance bottlenecks, making them an essential diagnostic tool.
- D. Incorrect.
Incorrect. Terminating and recreating the entire DB System is a drastic measure. It discards crucial diagnostic information and is not a recommended first step. Thorough troubleshooting should occur before considering system re-creation.