Hot off the heels of my previous post of new Server & Application Monitor content for Microsoft SQL and Exchange, as well as SAP HANA, we also now have some new and enhanced content for monitoring your Oracle databases.   As mentioned in my previous blog post, this will be a steady drumbeat of releasing new and enhanced monitoring content for SAM, so please keep an eye out on THWACK® and I will keep you up to date via the product blog as well.

 

First off, as of today, these templates still require the additional components be installed and added to the Orion® Server and/or poller that these databases are being monitored from. We have documentation about this already in the Success Center here - https://support.solarwinds.com/Success_Center/Server_Application_Monitor_(SAM)/Knowledgebase_Articles/Configure_SAM_to_monitor_an_Oracle_Database_Server


Oracle Database: 
https://thwack.solarwinds.com/docs/DOC-203309

This template contains newly added performance and statistics counters for Oracle Database.

 

Prerequisites: Oracle client installed on Orion APM server. This is available from the SolarWinds customer portal under Additional Downloads.

Credentials: An Oracle username and password with read access to the Oracle 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 http://knowledgebase.solarwinds.com/kb/questions/2415.

 

  • SGA Size

     This component monitor returns the System Global Area (SGA) as the part of the system memory (RAM) shared by all the processes belonging to a single Oracle database instance.

     Unit: Bytes

     Source: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3028.htm#REFRN30233

  • PGA Size

     Program Global Area (PGA) is a private memory region that contains the data and control information for a server process. Only a server process can access the PGA. Oracle Database reads and writes information in the PGA on behalf of the server process. Oracle Database automatically sizes the PGA by dynamically adjusting the portion of the PGA memory     

     dedicated to work areas, based on 20% of the SGA memory size. The minimum value is 10MB.

     PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process)

     Unit: Bytes

     Source: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2098.htm#REFRN30186

  • Buffer Pool Size

     This component monitors the buffer pool size for the Oracle Database. The default buffer pool size is determined by the DB_CACHE_SIZE initialization parameter.

     Unit: Bytes

     Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-BUFFER_POOL.html#GUID-1E70B05F-6E52-44B0-AFB3-5ADDA620008D

  • Shared Pool Size

     This component monitors the shared pool area size. The shared pool is a RAM area within the RAM heap that is created at startup time, a component of the System Global Area (SGA). The size depends on the size of your RAM.

     Unit: Bytes

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2106.htm#REFRN30238

  • Buffer Pool Response Time

     This component monitors the buffer pool response time. The value should be low for good performance.

     The query below calculates response time for logical reads per second from buffer within an interval of 15 seconds.

     Unit: Seconds

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3090.htm#REFRN30343

  • Single block read response time

     This component monitors the cumulative single-block read response time at the file level in seconds. This value should be low. A high value means a high latency.

     Unit: Seconds

     Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-FILESTAT.html#GUID-9DF61EA4-EF94-4F60-B966-D1B9AFEFF3E0

  • Multi block read response time

     This component monitors the cumulative multi-block read response time at file level in seconds. This value should be low. A high value means a high latency.

     Unit: Seconds

     Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-FILESTAT.html#GUID-9DF61EA4-EF94-4F60-B966-D1B9AFEFF3E0

  • Log write response time

     This component monitors log write response time. The response time here includes write time + wait time that log writer spent waiting.

     Unit: Seconds

     Source: https://docs.oracle.com/cd/E18283_01/server.112/e17110/statviews_4061.htm

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3177.htm

  • Physical I/O total rate

     This component monitors the physical I/O total rate. The total rate includes read rate + write rate per sec.

     A high value means a better performance.

     Unit: Bytes/second

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3090.htm

  • Physical I/O read rate

     This component monitors the physical I/O read rate per sec.

     A high value means a better performance.

     Unit: Bytes/second

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3090.htm

  • Physical I/O write rate

     This component monitors the physical I/O write rate per sec.

     A high value means a better performance.

     Unit: Bytes/second

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3090.htm

  • Commit latency

     This component monitors latency for commits by all users. If the value is null that means the number of commits per second is 0.

     Unit: Seconds

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3090.htm

  • SQL*Net receive rate

     This component monitors SQL*Net receive rate (clients + dblinks). In other words, bytes received via SQL*Net from client + bytes received via SQL*Net from dblink.

     Unit: Bytes/second

     Source: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm

  • SQL*Net send rate

     This component monitors SQL*Net send rate (clients + dblinks). In other words, bytes sent via SQL*Net to client + bytes sent via SQL*Net to dblink.

     Unit: Bytes/second

     Source: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm

  • Active sessions total

     This component monitors the total number of active sessions at any moment.

     Unit: Count

     Source: - https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm

  • Active sessions waiting

     This component monitors the number of active sessions waiting to be run.

     Unit: Count

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htmCPU.

  • Active sessions working

     This component monitors the total number of active sessions currently executing on CPU.

     Unit: Count

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm

  • Blocked sessions

     This component monitors the total number of sessions blocked by other sessions.

     Unit: Count

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3017.htm

  • Connections

     This component monitors the total number of active connections at any point.

     Unit: Count

     Sources:

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2129.htm

     https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2098.htm

  • Request rate

     This component monitors the total number of incoming request per second. A high number of requests might be a reason for slow response.

     Unit: Count/second

     Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3090.htm

  • Database Size (size of all tablespaces)

     This component monitors the total database size (size of all table spaces) of the Oracle Database. The default value is fetched in bytes.

     Unit: Bytes

     Sources:

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3122.htm

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3083.htm

  • Database Used Space (amount actually used)

     This component monitors the total database used space.

     Unit: Bytes

     Sources:

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3122.htm

     https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3083.htm

  • SQL Parse to execute ratio

     This component monitors SQL parsing to execute ratio.

     The query below will calculate the ratio by dividing parse count by execution count.  A higher ratio means better performance.

     Unit: Percent

     Source: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm

 

 

Oracle Automatic Storage Management:
https://thwack.solarwinds.com/docs/DOC-203310

This template contains newly added performance and statistics counters for Oracle ASM.

 

Prerequisites: Oracle client installed on the Orion SAM server. This is available from the SolarWinds customer portal[TK5] under Additional Downloads.

Credentials: An Oracle username and password with read access to the Oracle 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 http://knowledgebase.solarwinds.com/kb/questions/2415.

 

  • Average Write Throughput

     This component monitor fetches the value for average write throughput for all disks under ASM disk group. The returned value will only show the results since the last polling period.

     Unit: MB/second

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170

  • Average Read throughput

     This component monitor fetches the value for average read throughput for all disks under ASM disk group. The returned value will only show the results since the last polling period.

     Unit: MB/second

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170

  • Average write latency

     This component monitor fetches the value for average write latency per MB for all disks under ASM disk group, at any time. The returned value will only show the results since the last polling period.

     Unit: Milliseconds

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170

  • average read latency

     This component monitor fetches the value for average read latency per read request for all disks under ASM disk group, at any time. The returned value will only show the results since the last polling period.

     Unit: Milliseconds

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170

  • average i/o read request

     This component monitors average number of I/O read requests for the disk group. The returned value will only show the results since the last polling period.

     Unit: Count.

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170

  • average i/o write request

     This component monitors average number of I/O write requests for the disk group. The returned value will only show the results since the last polling period.

     Unit: Count.

     Source: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170

 

 

Oracle Dataguard:
https://thwack.solarwinds.com/docs/DOC-203308

This template contains performance and statistics counters for Oracle Dataguard.

 

Prerequisites: Oracle client installed on the Orion SAM server. This is available from the SolarWinds customer portal[TK6] under Additional Downloads.

Credentials: An Oracle username and password with read access to the Oracle 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 http://knowledgebase.solarwinds.com/kb/questions/2415

 

  • LOG APPLY GAP

     This component monitors the number of logs the secondary server has not yet applied.

     The greater the value, the lower the protection. The returned value will only show the results since the last polling period.

     Unit: Count

     Source:

     https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1126.htm

     https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1011.htm

     https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1015.htm

     https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1054.htm

  • Log Apply LAG

     This component monitors how long it is taking the secondary to apply logs.

     The returned value will only show the results since the last polling period.

     Unit: Seconds

     Source:

     https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1126.htm

     https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1011.htm

     https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1015.htm

     https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1054.htm

  • Log Destination error.

     This component monitors the count of error(s) that have occurred on any of the destinations while applying redo logs.

     Unit: Count

     Source:

     https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1061.htm

     https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1011.htm

 

The SolarWinds trademarks, service marks, and logos are the exclusive property of SolarWinds Worldwide, LLC or its affiliates.  All other trademarks are the property of their respective owners.