Oracle Real Application Cluster (RAC)

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

Prerequisites

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.

Credentials

An Oracle user name and password with read access to the Oracle RAC tables

Monitored components

For details on monitors, see SAM 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.

Links herein are from Oracle; © 2019 Oracle, available at http://www.oracle.com/technetwork and https://docs.oracle.com, obtained on May 10, 2019.

Average MTS response time

This component monitors the average MTS server response time for all instances.

Unit: Milliseconds

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1089.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Average MTS wait time

This component monitors the average MTS wait time on all instance.

Unit: Milliseconds.

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30
  • https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_2031.htm

Sort ratio

This component monitors the sort ratio for disk and memory.

Unit: Percentage

Source:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2098.htm
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

MTS UGA memory

This component monitors the MTS UGA memory.

Unit: KB

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2098.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Database file I/O reads

This component monitors data file I/O read operations.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_1089.htm
  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_1089.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

User locks

This component monitors the number of active user locks.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B12037_01/server.101/b10755/dynviews_1123.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2129.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm

Locked users

This component monitors total number of active locked user at any given point.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2113.htm
  • https://docs.oracle.com/cd/B12037_01/server.101/b10755/dynviews_1123.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2129.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm

Global cache service utilization

This component monitors the total number of blocks received.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Global cache block lost

This component monitors the total number of blocks lost in global cache.

Unit: Count

Source:

  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30
  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272

Global cache average block receive time

This component monitors the average block receive time in milliseconds.

Unit: Milliseconds

Sources:

  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Long queries elapsed time

This component monitors elapsed time in seconds for long queries.

Unit: Seconds

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2092.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2129.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm#REFRN30223

Redo logs contentions

This component monitors number of misses in redo logs.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1136.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Active users

This component monitors the number of active users on all instances.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm#REFRN30223
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Buffer cache hit ratio

This component monitors the buffer cache-hit ratio.

Unit: Percentage

Sources:

  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Dictionary cache hit ratio

This component monitors the dictionary cache hit ratio in percentage for gets and misses. A higher percentage means higher gets and fewer misses.

Unit: Percentage

Sources:

  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2144.htm
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Average enqueue timeouts

This component monitors the number of table and row locks that timed out.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Global cache block access latency

This component monitors the end-to-end elapsed time or latency for a block request in milliseconds.

Unit: Milliseconds

Sources:

  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Nodes down

This Component monitors the count of nodes that went down and are not active,

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Long queries count

This component monitors the number of long queries running at that moment.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2129.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm#REFRN30223
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2092.htm
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Database file I/O write operation

This component monitors database file I/O write operations.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1107.htm
  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_1089.htm
  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30

Global cache corrupt blocks

This component monitors the number of corrupt blocks.

Unit: Count

Sources:

  • https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1131.htm#REFRN30105
  • https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm#REFRN30272
  • https://docs.oracle.com/database/121/REFRN/GUID-884B21B1-7C87-41E1-8F97-C4668704AF30.htm#REFRN-GUID-884B21B1-7C87-41E1-8F97-C4668704AF30