Oracle Real Application Cluster (RAC)
This SAM template contains performance and statistics counters for an Oracle RAC database.
Review Configure SAM to monitor Oracle database servers and then:
- Install an Oracle driver on the Orion server and any Additional Polling Engines (APEs) in your environment.
- Adjust Oracle User Experience Monitor settings to match the settings for Oracle databases on target servers.
To use this monitor with the Orion agent for Linux, you may need to install and configure ODBC. See Configure Linux/Unix systems for monitoring by the Orion agent.
The account running Orion services has Full Control privileges for files in this default folder:
C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
Oracle server credentials have Read access to Oracle RAC tables.
Oracle server credentials have Read access to the following Oracle views:
Do not use Oracle credentials with limited permissions to run SQL statements defined in the Oracle User Experience Monitor. This will return errors such as:
Table or view doesn't exist.
Component monitors 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 environment. See Manage thresholds in SAM.
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.