Which two statements about ADDM are true?

Question

Options

• AReal-Time ADDM uses AWR snapshots of the last 10 minutes.
• BReal-Time ADDM uses ASH recent activity from SGA data.
• CReal-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
• DRegular ADDM uses AWR snapshots that are not yet purged.

• A
  13% (7)
• B
  81% (42)
• C
  6% (3)

Explanation

Real-Time ADDM Analysis Introduced in Oracle Enterprise Manager Cloud Control 12c, Real-Time ADDM helps you to analyze and resolve problems in unresponsive or hung databases that traditionally require you to restart the database. Real-Time ADDM runs through a set of predefined criteria to analyze the current performance of the database. After analyzing the problem, Real-Time ADDM helps you to resolve the identified issues-such as deadlocks, hangs, shared pool connections, and other exception situations-without having to restart the database. Real-Time ADDM Connection Modes Depending on the database state, Real-Time ADDM uses two different types of connection modes when connecting to the database using Enterprise Manager: - Normal connection - In this mode, Real-Time ADDM performs a normal JDBC connection to the database. This mode is intended to perform extensive performance analysis of the database when some connectivity is available. - 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 Real-Time ADDM Triggers Starting with Oracle Database 12c, Real-Time ADDM proactively detects transient database performance issues. To do this, Real-Time ADDM runs automatically every 3 seconds and uses in-memory data to diagnose any performance spikes in the database. Real-Time ADDM triggers an analysis automatically when a performance problem is detected. - Real-Time ADDM unlike Emergency Monitoring is used to analyze the root cause of the hung. - Real-Time ADDM works like the normal ADDM but access only the last 10 minutes of Active Session History (ASH) data to provide recommendations. - Because Real-Time ADDM only uses data from memory you can still access it when the database is hung. - You can use Real-Time ADDM triggers to proactively monitor the performance of an instance. - Over-allocated memory - Interconnect bound - Deadlock detected - To manually generate a report you can use the following procedure - SQL> select dbms_addm.real_time_addm_report() from dual; - You can also generate an ADDM report using the EM Database Express by going to the performance hub. Real-Time ADDM provides an innovative way to analyze problems in unresponsive or hung Using a normal and a diagnostic mode connection Real-Time ADDM runs through a set of predefined criteria to analyze the current performance and helps the DBA to resolve deadlocks, hangs, shared pool contentions and many other exception situations that today forces the administrator to bounce their databases, causing significant loss of revenue. Real-Time ADDM is the only tool available in the market today that can log into a hung database, analyze the problem and recommend a resolution Regular ADDM builds upon the data captured (snapshots) in AWR.

No community discussion yet for this question.