Oracle Database Administration 2022 Certified Professional — Question 39

Users complain about slowness and session interruptions. Additional checks reveal the following error in the application log: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
Which file has additional information about this error?

Answer options

• A. Alert log
• B. ASH report
• C. Session trace file SQL trace file automatically generated by the error
• D. SQL trace file automatically generated by the error

Correct answer: D

Explanation

The correct answer is D because the SQL trace file is specifically generated for errors like deadlocks and will contain detailed information regarding the situation. Option A, the Alert log, provides overall system alerts but lacks the granularity needed for this specific error. Option B, the ASH report, gives insights into active sessions but does not focus on deadlock details. Option C is misleading as it describes two different types of files combined, while only the SQL trace file is relevant here.