Oracle Automatic Storage Management

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

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

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