What diagnostic output will you send to My Oracle Suppo…

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?

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?

A.
pkginfo

B.
oswatcher

C.
AWR

D.
v$session output

E.
list of database users



Leave a Reply 3

Your email address will not be published. Required fields are marked *


mo

mo

B I think, if database hangs, no AWR snapshot may be written, while oswatcher is independant process.
From other side oswatcher provides details only about OS, not DB.
In ideal case both B and C must be submitted 🙂

Sergiy V Avramych

Sergiy V Avramych

the answer is B