1Z0-997-25 Question 86
Select 2You are administering a mission-critical Oracle Database on a Bare Metal DB System in Oracle Cloud Infrastructure. During regular peak hours, users report significant slowdowns, and you notice high concurrency waits in the database. Which two approaches should you take to effectively diagnose and troubleshoot the concurrency issues?
- A
Use the Performance Hub in the Oracle Cloud Console to analyze top SQL statements and identify sessions with high concurrency waits.
- B
Generate AWR reports and leverage ADDM to pinpoint concurrency bottlenecks and suggest remedial actions.
- C
Downsize the DB System shape to decrease CPU resources, thereby reducing the chances of concurrency conflicts.
- D
Disable Transparent Data Encryption (TDE) to eliminate encryption overhead and reduce concurrency issues.
Show answer and explanation
Correct answers: A, B
Explanation
In Oracle Cloud Infrastructure, diagnosing concurrency problems involves gathering performance statistics, identifying locking or blocking sessions, and analyzing query execution patterns. Tools such as the Performance Hub, AWR, and ADDM are integral for discovering the root causes of concurrency waits. Correctly pinpointing the issue often leads to appropriate remediation steps�like query tuning or adjusting database configurations�rather than reducing resources or disabling critical security features. Refer to Oracle� documentation on Performance Tuning and OCI Database Management for detailed best practices and troubleshooting guidelines.
- A. Correct.
Option 1 is correct. The Performance Hub provides detailed insights into real-time performance, highlighting top SQL statements and session activity. By focusing on concurrency waits, you can quickly identify problematic sessions, lock contention, and blocking sessions to narrow down culprit queries or code segments.
- B. Correct.
Option 2 is correct. Automatic Workload Repository (AWR) snapshots and Automatic Database Diagnostic Monitor (ADDM) are valuable for long-term or historical performance analysis. ADDM recommendations often guide you toward addressing specific concurrency issues, such as indexing strategies or SQL profile usage.
- C. Incorrect.
Option 3 is incorrect. Reducing CPU resources typically worsens performance issues during peak load rather than alleviating them. Concurrency waits often require tuning or identifying bottlenecks, not limiting available resources further.
- D. Incorrect.
Option 4 is incorrect. Transparent Data Encryption (TDE) does not inherently cause concurrency conflicts. Disabling TDE can pose security risks and is unlikely to resolve the concurrency bottlenecks in this scenario.