OCP CBT Question 520

Please solve the following question.

A critical application on your database experiences frequent timeouts and hangs during peak hours, often leading to manual instance restarts. You have generated an ADDM report covering a period of high load. The report highlights "CPU utilization" as the top finding, recommending investigating "SQL Tuning" and "Parallel Execution". Additionally, it shows "Log File Sync" and "Concurrency" as significant wait events. Which action should you prioritize to diagnose the underlying cause of the "hangs" rather than just the "timeouts"?

ADDM Report SnippetFINDING 1: 50% impact. CPU utilization is the top finding. RECOMMENDATION 1: Investigate application SQL tuning for high CPU queries.FINDING 2: 25% impact. Log File Sync waits. RECOMMENDATION 2: Optimize redo log configuration and storage.FINDING 3: 15% impact. Concurrency waits. RECOMMENDATION 3: Investigate application design for hot blocks.## Additional Observations- Users report the database "freezing" intermittently.- `V$SESSION` shows many sessions in `WAITING` state, often on `enq: TX - row lock contention` or `library cache lock`.

Focus on SQL tuning for high CPU queries to reduce overall load.

Review V$ACTIVE_SESSION_HISTORY (ASH) for sessions stuck on specific wait events during the hang periods.

Increase the size of redo log files to reduce Log File Sync waits.

Disable parallel execution for the application queries as recommended by ADDM.