Documentation forServer & Application Monitor

Oracle Real Application Cluster (RAC)

This SAM template contains performance and statistics counters for an Oracle RAC database.

This template includes a predefined SAM component monitor, the Oracle User Experience Monitor, that does not support polling via Orion Remote Collectors (ORCs).

Prerequisites

To monitor Oracle database servers, install an additional driver on systems where SAM is running, including the Orion server and Additional Polling Engines (APEs) in your environment. See Configure SAM to monitor Oracle database 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.

Adjust Oracle User Experience Monitor settings to match the settings for Oracle databases on target servers. See Configure Oracle User Experience monitor settings.

Credentials

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:

  • dba_data_files
  • dba_free_space
  • dba_temp_files
  • v$librarycache
  • v$rowcache
  • v$session.
  • v$sgastat
  • v$sysstat

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

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.

Unit: Milliseconds

Average MTS wait time

The average MTS wait time on all instances.

Unit: Milliseconds.

Sort ratio

The sort ratio for disk and memory.

Unit: Percentage

MTS UGA memory

The amount of MTS UGA memory.

Unit: KB

Database file I/O reads

The total number of data file I/O read operations.

Unit: Count

User locks

The total number of active user locks.

Unit: Count

Locked users

The total number of active locked user at any given point.

Unit: Count

Global cache service utilization

The total number of blocks received.

Unit: Count

Global cache block lost

The total number of blocks lost in global cache.

Unit: Count

Global cache average block receive time

The average block receive time in milliseconds.

Unit: Milliseconds

Long queries elapsed time

The elapsed time in seconds for long queries.

Unit: Seconds

Redo logs contentions

The number of misses in redo logs.

Unit: Count

Active users

The number of active users on all instances.

Unit: Count

Buffer cache hit ratio

The buffer cache-hit ratio.

Unit: Percentage

Dictionary cache hit ratio

The dictionary cache hit ratio in percentage for gets and misses. A higher percentage means higher gets and fewer misses.

Unit: Percentage

Average enqueue timeouts

The number of table and row locks that timed out.

Unit: Count

Global cache block access latency

The end-to-end elapsed time or latency for a block request in milliseconds.

Unit: Milliseconds

Nodes down

The count of nodes that went down and are not active,

Unit: Count

Long queries count

The number of long queries running at that moment.

Unit: Count

Database file I/O write operation

The total number of database file I/O write operations.

Unit: Count

Global cache corrupt blocks

The number of corrupt blocks.

Unit: Count