This template contains newly added performance & 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 user name 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) is 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 (the SGA). Size depends on 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. Value should be low for good performance.
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 file level in seconds. Value should be low. 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. Value should be low. 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. 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. Total rate includes read rate + write rate per sec.
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.
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.
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 value is null that means no 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). I.e. 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). I.e. 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 total no 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 no of active sessions which are 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 total no of active sessions which are 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 total no of sessions which are blocked by other sessions.
Unit: Count
Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3017.htm
Connections
This component monitors total no 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 total no of incoming request per seconds. High no of requests might be 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 total database Size (size of all table spaces) of 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 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.
Query below will calculate the ratio by dividing parse count by execution count. A higher ratio means a better performance.
Unit: Percent
Source: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3086.htm