Oracle Service Cloud Developer — Question 14

You notice that a database node has hung, so you open a Service Request via My Oracle Support.
What diagnostic output will you send to My Oracle Support by default?

Answer options

• A. pkginfo
• B. oswatcher
• C. AWR
• D. v$session output
• E. list of database users

Correct answer: C

Explanation

The correct answer is C, AWR, as it provides detailed performance data and diagnostics for the database. The other options, while potentially useful, do not offer the comprehensive insights that AWR provides, making it the default choice for such situations.