You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?
A.
by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
B.
by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
C.
by using Active Session History (ASH) data and performing hang analysis
Answer is D
https://docs.oracle.com/database/121/TGDBA/pfgrf_diag.htm#TGDBA94243
"Diagnostic connection
In this mode, Real-Time ADDM performs a latch-less connection to the database. This mode is intended for extreme hang situations when a normal JDBC connection is not possible."
Should be A sorry, REAL-TIME ADDM analysis from the SGA
upvoted 2 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sugar
4 years, 6 months agoNorthKorean
4 years, 7 months agoNorthKorean
4 years, 7 months agoJake
5 years, 6 months agoJake
5 years, 6 months ago