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
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
B or C ??
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 🙂
the answer is B