Which two statements are true regarding the Average Active Sessions chart on the performance page

Question

Options

• AIt shows active aggregate wait class statistics across all the instances In the cluster database.
• BIt shows active aggregate wait class per instance for all the instances In the cluster database.
• CIf the Average Active Sessions chart displays a large number of sessions waiting, indicating
• DIf the Average Active Sessions chart displays a large number of sessions waiting, indicating

• A
  83% (19)
• B
  9% (2)
• D
  9% (2)

Explanation

Chart for Average Active Sessions The Average Active Sessions chart in the Cluster Database Performance page shows potential problems inside the database. Verifying the Interconnect Settings for Oracle RAC Categories, called wait classes, show how much of the database is using a resource, such as CPU or disk I/O. Comparing CPU time to wait time helps to determine how much of the response time is consumed with useful work rather than waiting for resources that are potentially held by other processes. Compare the peaks on the Average Active Sessions chart with those on the Database Throughput charts. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but throughput is high, then the situation may be Oracle Database 2 Day + Real Application Clusters Guide

No community discussion yet for this question.