Oracle Real Application Cluster (RAC)
This template contains performance and statistics counters for an Oracle RAC database.
To monitor Oracle database servers, you'll need to download and install drivers to support polling by SAM and other SolarWinds products. See Configure SAM to monitor an Oracle Database Server in the SolarWinds Success Center for details.
If you have Additional Polling Engines (APEs), install the Oracle client software on those machines also.
An Oracle user name and password with read access to the Oracle RAC tables
To learn more about component monitors, see Use SAM templates, application monitors, and component monitors.
Components without predetermined threshold values provide guidance such as "Use the lowest threshold possible" or "Use the highest threshold possible" to help you find an appropriate threshold for your application.
Average MTS response time
The average MTS server response time for all instances.
Average MTS wait time
The average MTS wait time on all instances.
The sort ratio for disk and memory.
MTS UGA memory
The amount of MTS UGA memory.
Database file I/O reads
The total number of data file I/O read operations.
The total number of active user locks.
The total number of active locked user at any given point.
Global cache service utilization
The total number of blocks received.
Global cache block lost
The total number of blocks lost in global cache.
Global cache average block receive time
The average block receive time in milliseconds.
Long queries elapsed time
The elapsed time in seconds for long queries.
Redo logs contentions
The number of misses in redo logs.
The number of active users on all instances.
Buffer cache hit ratio
The buffer cache-hit ratio.
Dictionary cache hit ratio
The dictionary cache hit ratio in percentage for gets and misses. A higher percentage means higher gets and fewer misses.
Average enqueue timeouts
The number of table and row locks that timed out.
Global cache block access latency
The end-to-end elapsed time or latency for a block request in milliseconds.
The count of nodes that went down and are not active,
Long queries count
The number of long queries running at that moment.
Database file I/O write operation
The total number of database file I/O write operations.
Global cache corrupt blocks
The number of corrupt blocks.