Which two statements are true regarding the Active Session History (ASH) reports for RAC?

Question

Options

• AThey provide details about Oracle databases for all current sessions, and history of past session
• BThey provide statistics about Oracle databases for the active sessions on all the RAC nodes.
• CThey report on data captured for active sessions. The volume of data is directly related to the
• DThey report on data captured for active sessions. The volume of data is directly related to the

• A
  14% (8)
• B
  78% (46)
• D
  8% (5)

Explanation

ASH report statistics provide details about Oracle Database session activity. Oracle Database records information about active sessions for all active Oracle RAC instances and stores this data in the System Global Area (SGA). Any session that is connected to the database and using CPU is considered an active session. The exception to this is sessions that are waiting for an event that belongs to the idle wait class. ASH reports present a manageable set of data by capturing only information about active sessions. The amount of the data is directly related to the work being performed, rather than the number of sessions allowed on the system. Oracle Real Application Clusters Administration and Deployment Guide

No community discussion yet for this question.