Oracle Real Application Cluster(RAC)

This template contains performance & statistics counters for Oracle RAC Database.

• Prerequisites: Oracle client installed on Orion server. This is available in the SolarWinds Customer Portal, under Additional Downloads. See Configure SAM to monitor an Oracle Database Server.
• Credentials: An Oracle user name and password with read access to the Oracle RAC tables.

MONITORED COMPONENTS

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. For more information, see Understand application monitor thresholds.

• Average MTS response time
  • This component will monitor 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
  • Source:
    • 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 no 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 total no of blocks received.
  • Unit: Count
  • Source:
    • 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 total no of block 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
  • Source:
    • 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
  • Source:
    • 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 no 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 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 dictionary cache hit ratio in percentage for gets and misses. A higher percentage means higher gets and lesser 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 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 which has gone down and 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 no 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 no 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