cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Oracle Database.apm-template

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-1E70B0...

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-...

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-...

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

Labels (1)
Attachments
Version history
Revision #:
1 of 1
Last update:
‎09-04-2018 09:09 AM
Updated by: