Oracle Automatic Storage Management

Version 2

    This template assesses the status and performance of an Oracle Automatic Storage Management by retrieving performance data from the built-in Oracle views.


    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: v_$asm_diskgroup and v_$asm_disk.

    Note: For issues connecting to Oracle databases using this monitor, see the following SolarWinds knowledgebase article: http://knowledgebase.solarwinds.com/kb/questions/2067/.


    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.

    Note: Before using this template you should provide the correct disk group name in all SQL queries. You can do this by changing the last line of the SQL query in all monitors:

    WHERE A.NAME LIKE 'DISK_GROUP_NAME'
    where DISK_GROUP_NAME – disk group name which you want to monitor. For example:
    WHERE A.NAME LIKE 'DATA'

    To get the names of disk groups, run the following command from the Oracle SQL plus utility:
    SELECT NAME FROM V$ASM_DISKGROUP;

     

    Mount Status

    This component monitor returns the status of the disk relative to group mounts.

    Possible values:
    0 – Opened - Disk is present in the storage system and is being accessed by Automatic Storage Management. This is the normal state for disks in a database instance which are part of a Disk Group being actively used by the instance.

    1 – Cached - Disk is present in the storage system, and is part of a disk group being accessed by the Automatic Storage Management instance. This is the normal state for disks in an Automatic Storage Management instance which are part of a mounted disk group.

    2 – Closing - ASM is in the process of closing this disk.

    3 – Closed - Disk is present in the storage system but is not being accessed by Automatic Storage Management.

    4 – Ignored - Disk is present in the system, but is ignored by ASM because of one of the following:
    the disk is detected by the system library, but is ignored because an ASM library discovered the same disk; ASM has determined that the membership claimed by the disk header is no longer valid.

    5 – Missing - Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management disk group, but no disk in the storage system was found with the indicated name.

    6 – Unknown.

     

    Header Status

    This component monitor returns the status of the disk as seen by discovery.

    Possible values:
    0 – Member - Disk is a member of an existing disk group. No attempt should be made to add the disk to a different disk group. The ALTER DISKGROUP statement will reject such an addition unless overridden with the FORCE option.

    1 – Former - Disk was once part of a disk group but has been dropped cleanly from the group. It may be added to a new disk group with the ALTER DISKGROUP statement.

    2 – Provisioned - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement. The PROVISIONED header status is different from the CANDIDATE header status in that PROVISIONED implies that an additional platform-specific action has been taken by an administrator to make the disk available for Automatic Storage Management.

    3 – Candidate - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement.

    4 – Foreign - Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks.

    5 – Incompatible - Version number in the disk header is not compatible with the Automatic Storage Management software version.

    6 – Conflict - Automatic Storage Management disk was not mounted due to a conflict.

    7 – Unknown - Automatic Storage Management disk header has not been read.

     

    Mode Status

    This component monitor returns the status about which kinds of I/O requests are allowed to the disk.

    Possible values:
    0 – Online - Disk is online and operating normally. Reads and writes are attempted.

    1 – Offline - Disk is offline and access to data is not permitted. Reads and writes are not attempted. An offline disk remains logically part of its disk group.

    2 – Unknown - Automatic Storage Management disk mode is not known (typically the disk is not mounted).

     

    State

    This component monitor returns the state of the disk with respect to the disk group.

    Possible values:
    0 – Normal - Disk is online and operating normally.

    1 – Adding - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted.

    2 – Dropping - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group.

    3 – Dropped - Disk has been fully expelled from the disk group.

    4 – Forcing - Disk is being removed from the disk group without attempting to offload its data. The data will be recovered from redundant copies, where possible.

    5 – Hung - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped.

    6 – Unknown - Automatic Storage Management disk state is not known (typically the disk is not mounted).

     

    Used Space (%)

    This component monitor returns the percentage of the used capacity of the disk group.

     

    Used Space (MB)

    This component monitor returns the used capacity of the disk group (in megabytes).

     

    Read Requests

    This component monitor returns the total number of I/O read requests for the disk.

    Note: By default, this monitor has the Count statistic as difference box checked. The returned value will only show the results since the last polling period.

     

    Write Requests

    This component monitor returns the total number of I/O write requests for the disk.

    Note: By default, this monitor has the Count statistic as difference box checked. The returned value will only show the results since the last polling period.

     

    Failed Read Requests

    This component monitor returns the total number of failed I/O read requests for the disk.

    Note: By default, this monitor has the Count statistic as difference box checked. The returned value will only show the results since the last polling period.

     

    Failed Write Requests

    This component monitor returns the total number of failed I/O write requests for the disk.

    Note: By default, this monitor has the Count statistic as difference box checked. The returned value will only show the results since the last polling period.

     

    Bytes Read

    This component monitor returns the total number of bytes read from the disk.

    Note: By default, this monitor has the Count statistic as difference box checked. The returned value will only show the results since the last polling period.

     

    Bytes Written

    This component monitor returns the total number of bytes written to the disk.

    Note: By default, this monitor has the Count statistic as difference box checked. The returned value will only show the results since the last polling period.

     

    Potions of this document are based on the following and courtesy of Oracle, copyright 2013:
    - http://docs.oracle.com/cd/B12037_01/server.101/b10755/dynviews_1019.htm
    - http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm