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

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

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

A.
It shows active aggregate wait class statistics across all the instances In the cluster database.

B.
It shows active aggregate wait class per instance for all the instances In the cluster database.

C.
If the Average Active Sessions chart displays a large number of sessions waiting, indicating
internal contention, but the throughput is high, then the situation may be acceptable.

D.
If the Average Active Sessions chart displays a large number of sessions waiting, indicating
internal contention, but the throughput is low, then the CPU needs to be upgraded

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 acceptable.
Oracle Database 2 Day + Real Application Clusters Guide



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right. the performance shows stats rolled up across all instances
B is wrong. not per instance
C is right. contention, but throughput high ok
D is wrong.

So A.C. are correct