Foglight for Oracle (Cartridge) 5.9.2.1


Metric	Description
Balanced IO	The extent, in percents, to which the I/O activity is balanced across the ASM diskgroups. NOTE: This information is unavailable for Oracle 10.1
Balanced Time	The extent, in percents, to which the I/O time is balanced across the ASM diskgroups. NOTE: This information is unavailable for Oracle 10.1
Group Number	The number assigned to an ASM disk group.

ASM Disks

Purpose

The ASM Disks collection collects storage and activity data regarding ASM disks.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	300
Online	300
Offline	900

Metric Descriptions


Metric	Description
Average Service Time	The service time for each disk. Service time is the response time of a disk, plus any wait time experienced during disk operations.
Create Date	The date and time when the disk was added to the disk group.
Disk Free Space	The unused capacity of the ASM disk.
Disk Name	The name of the disk.
Disk Number	The number assigned to an ASM disk within its disk group.
Disk Path	The disk’s path, as indicated on the operating-system.
Disk Size	The total capacity of the ASM disk.
Disk State	The state of the disk, regarding its ASM disk group (UNKNOWN, NORMAL, ADDING, DROPPING, HUNG, FORCING, or DROPPED).
Fail Group	The name of the failure group that contains the disk.
Group Number	The number assigned to an ASM disk group.
Header Status	The status of the disk at the discovery stage (UNKNOWN, CANDIDATE, INCOMPATIBLE, PROVISIONED, MEMBER, FORMER, CONFLICT, or FOREIGN).
Label	The label portion of the disk name at the discovery stage.
Mode Status	The access type granted to the disk (UNKNOWN, ONLINE, or OFFLINE). Read/write access is only granted to ONLINE disks; OFFLINE disks still remain part of their disk group.
Mount Date	The date and time when the disk was first mounted.
Mount Status	The mount status of the disk (MISSING, CLOSED, OPENED, CACHED, IGNORED, or CLOSING).
Read Errors	The total number of failed I/O read requests for the disk. Such failures can result from a loss of access to the entire disk, or media corruptions on a generally healthy disk.
Read Time	The total time spent on I/O read requests.
Redundancy	The external redundancy of the disk, if the ASM mechanism does not provide redundancy. The possible states are: UNKNOWN, UNPROT, MIRROR, or PARITY.
Total IO Percent	The number of I/O operations performed by the selected disk as a percentage of all I/O performed by all disks in all ASM disk groups assigned to the Oracle instance.
Total Reads	The total number of I/O read requests for the disk.
Total Size Percent	The size of the disk as a percentage of the size of all disks in all ASM disk groups assigned to the Oracle instance.
Total Writes	The total number of I/O write requests for the disk.
Used Space Pct	The percent of used space out of the entire space allocation on the ASM disk.
Write Errors	The total number of failed I/O write requests for the disk.
Write Time	The total time spent on I/O write requests.

ASM Instance Total

Purpose

The ASM Instance Total collection provides ASM-related data, summarized for the database instance.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	300
Online	300
Offline	900

Metric Descriptions


Metric	Description
Total Disk Space Allocated	The total capacity allocated to all ASM disks residing on ASM groups that are used by this database instance.
Total Disks Free Percent	The total free space percentage on all ASM disks residing on ASM groups that are used by this database instance.
Total IO	The total number of I/O operations (reads and writes) on ASM managed disks.
Total Reads	The total number of I/O read requests for ASM managed disks.
Total Writes	The total number of I/O writes to ASM managed disks.

ASM Operations

Purpose

The ASM Operations collection retrieves details regarding the currently running ASM operations.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	300
Online	300
Offline	900

Metric Descriptions


Metric	Description
Actual Power	The power actually allocated to the operation.
Estimated Minutes	The estimated amount of time (in minutes) that the operation is expected to take.
Estimated Rate	The estimated rate (%) at which allocation units will be moved by the operation
Estimated Work	The estimated number of allocation units that the operation needs to move.
Group Number	The number of the disk group where the operation is running.
Operation	The type of the operation; REBAL, COD, DSCV, ACD, RFRSH, or EXPEL.
Operation State	The state of the operation; WAIT, RUN, REAP, HALT, or ERRORS.
Requested Power	The power requested for the operation as specified by the ASM_POWER_LIMIT parameter. Higher value of ASM_POWER_LIMIT indicate faster operation, while lower values indicate slower operation that uses fewer resources.
So Far Moved Units Number	The number of allocation units moved so far by the operation.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Foglight for Oracle (Cartridge) 5.9.2.1 - User Guide

ASM Diskgroups Balance

ASM Disks

ASM Instance Total

ASM Operations