Which two statements are true regarding the Active Session History (ASH) reports for RAC?
Correct Answer: A,C
Explanation/Reference:
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