Version 1

    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