Note: Available for Oracle 10.2 and later.
The Services | Resources page show recent statistics for the resource loads associated with the services deployed on the Oracle RAC cluster.
To open the Resources page
Click Services | Resources.
Charts on the Resources page
CPU Utilization shows the rate (in milliseconds per second) at which CPU time has been consumed by each service for the Oracle RAC cluster. Among the services deployed are:
|DB Time||DB Time shows the rate (in milliseconds per second) at which elapsed time is spent in database user calls by the specified services for the Oracle RAC cluster.|
Logical Reads shows the rate (in IO/s) of logical reads by the specified services for the Oracle RAC cluster.
A logical read occurs when Oracle finds data in the local buffer cache of an instance without needing to read the data from physical disk.
Physical Reads shows the rate (in reads/s) of physical reads by the specified services for the Oracle RAC cluster.
A physical read occurs when a database instance retrieves data from datafiles on the shared disk subsystem, and occurs every time a logical read fails to find the requested page in local or global cache.