Oracle Automatic Storage Management
This SAM template assesses the status and performance of an Oracle Automatic Storage Management (ASM) volume manager and file system by retrieving performance data from the built-in Oracle views.
Review Configure SAM to monitor Oracle database servers and then:
- Install an Oracle driver on systems where SAM is running, including the Orion server and any Additional Polling Engines (APEs) in your environment.
- Adjust Oracle User Experience Monitor settings to match the settings for Oracle databases on target servers.
Add the disk group name to all SQL queries by changing the last line of the SQL query in all component monitors,
WHERE A.NAME LIKE 'DISK_GROUP_NAME'
- To find disk group names, run this command from the Oracle SQL*Plus utility:
SELECT NAME FROM V$ASM_DISKGROUP;
DISK_GROUP_NAMEwith the disk group to be monitored.
WHERE A.NAME LIKE 'DATA'
To use this template with the Orion agent for Linux, you may need to install and configure ODBC. See Configure Linux/Unix systems for monitoring by the Orion agent.
The account running Orion services has Full Control privileges for files in this default folder:
C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
Oracle server credentials have Read access to the
Oracle server credentials have Read access to the following Oracle views:
Do not use Oracle credentials with limited permissions to run SQL statements defined in the Oracle User Experience Monitor. This will return errors such as:
Table or view doesn't exist.
Component monitors 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 environment. See Manage thresholds in SAM.
Returns the status of the disk relative to group mounts.
- 0 – Opened - Disk is present in the storage system and being accessed by Automatic Storage Management (ASM). 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 ASM 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 ASM.
- 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 determined that the membership claimed by the disk header is no longer valid.
- 5 – Missing - ASM metadata indicates that the disk is known to be part of the ASM disk group, but no disk in the storage system was found with the indicated name.
- 6 – Unknown
Returns status of the disk as seen by Discovery.
- 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 ASM.
- 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 ASM software version.
- 6 – Conflict - ASM disk was not mounted due to a conflict.
- 7 – Unknown - ASM disk header was not read.
Returns status about which kinds of I/O requests are allowed to the disk.
- 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 - ASM disk mode is not known (typically the disk is not mounted).
Returns with state of the disk with respect to the disk group.
Possible values include:
- 0 – Normal - Disk is online and operating normally.
- 1 – Adding - Disk was added to a disk group, but is pending validation by all instances that have the disk group mounted.
- 2 – Dropping - Disk was manually taken offline so space allocation or data access for the disk stopped. 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 was fully expelled from the disk group.
- 4 – Forcing - Disk was 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 - The ASM disk state is unknown, usually because the disk is not mounted.
Used Space (%)
Returns the percentage of the used capacity of the disk group.
Used Space (MB)
Returns the used capacity of the disk group (in MBs).
For the remaining component monitors in this template, note that the "Count statistic as difference" option is enabled by default, so returned values only show results since the last polling period.
- Read Requests: Returns the total number of I/O read requests for the disk.
- Write Requests: Returns the total number of I/O write requests for the disk.
- Failed Read Requests: Returns the total number of failed I/O read requests for the disk.
- Failed Write Requests: Returns the total number of failed I/O write requests for the disk.
- Bytes Read: Returns the total number of bytes read from the disk.
- Bytes Written: Returns the total number of bytes written to the disk.