1Z0-997-25 Question 87
Select 2You have recently deployed an Oracle Autonomous Data Warehouse instance on Oracle Cloud Infrastructure to support your organization� business analytics. Over the past week, end users have complained that queries are taking significantly longer to complete. As the OCI Architect responsible for the database, you need to diagnose and resolve the performance issues. Which two actions should you take first to isolate and address the root cause? (Choose two.)
- A
Use the Performance Hub in the Autonomous Database Console to review CPU usage, wait events, and top SQL statements.
- B
Drop and recreate all indexes without reviewing current query execution plans.
- C
Evaluate Automatic Indexing recommendations in the database console (if enabled) to identify potential index improvements.
- D
Export the database to object storage and redeploy it on a new Autonomous Database instance.
- E
Scale the Autonomous Database compute resources immediately without conducting further diagnostics.
Show answer and explanation
Correct answers: A, C
Explanation
When troubleshooting Autonomous Database performance issues, you should first collect and analyze performance metrics, SQL statements, and wait event data using tools like Performance Hub. If you have Automatic Indexing enabled for your Autonomous Data Warehouse, evaluating those recommendations is a proven best practice for query optimization. Making drastic changes without investigation�such as blindly dropping indexes, scaling resources prematurely, or redeploying the entire database�can add unnecessary overhead, cost, and potential downtime without guaranteeing a resolution. Refer to OCI documentation on 'Using Performance Hub with Autonomous Databases' and 'Managing Automatic Indexing in Autonomous Database' for detailed guidance.
- A. Correct.
Option 1 is correct. Performance Hub provides DBS Performance data, top SQL statements, and wait event details that help you quickly identify bottlenecks. Reviewing CPU, I/O usage, and active SQL allows you to pinpoint issues before making changes.
- B. Incorrect.
Option 2 is incorrect. Dropping and recreating all indexes without diagnostic data could add unnecessary downtime and may not resolve the real cause of the performance degradation. Blindly managing indexes is not a recommended approach.
- C. Correct.
Option 3 is correct. If Automatic Indexing is enabled, the system can recommend or create indexes automatically. Evaluating these recommendations in the console can help address missing or suboptimal indexes identified as performance bottlenecks.
- D. Incorrect.
Option 4 is incorrect. Exporting and redeploying the database is a disruptive approach and should only be considered if there are fundamental provisioning issues. It does not directly aid in diagnosing the immediate performance problem.
- E. Incorrect.
Option 5 is incorrect. Scaling compute without further diagnostics may temporarily mask or persist the actual cause. Proper investigation should precede any scaling decision.