Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.4.10 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

ASM Diskgroups

The ASM Diskgroups collection collects storage and activity data regarding ASM Diskgroups.

Oracle

Realtime Collection

300

Online

300

Offline

900

Allocation Size Unit

The size of allocation units in the disk group.

ASM Metadata Block Size

The block size for ASM metadata in the disk group.

Average Service Time

The average service time for all disks in the group.

Group Name

The name of the disk group.

Group Number

The number assigned to an ASM disk group.

Group State

The state of the specified ASM disk group relative to the Oracle instance (CONNECTED, BROKEN, UNKNOWN, DISMOUNTED, or MOUNTED).

Number of Disks

The number of disks in the disk group.

Offline Disks

The number of disks in the disk group that are offline.

Read Errors

The total number of failed I/O read requests for the disk group.

Read IO Requests

The total number of I/O read requests for the disk group.

Total Group Size

The total capacity of the specified ASM disk group (in megabytes).

Usable Group Space

The unused space on the disk group (in megabytes).

Used Group Space

The percentage of used disk space on the entire disk group. This value is calculated as follows:

100*(Total Group Size - Usable Group Space)

Total Group Size

Write Errors

The total number of failed I/O write requests for the disk group.

Write IO Requests

The total number of I/O write requests for the disk group.

ASM Diskgroups Balance

The ASM Diskgroups Balance collection estimates the rate of balance of IO Activity and Response time of ASM disks on ASM diskgroups.

Oracle

Realtime Collection

300

Online

300

Offline

900

Balanced IO

The extent, in percents, to which the I/O activity is balanced across the ASM diskgroups.

Balanced Time

The extent, in percents, to which the I/O time is balanced across the ASM diskgroups.

Group Number

The number assigned to an ASM disk group.

ASM Disks

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

Oracle

Realtime Collection

300

Online

300

Offline

900

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

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

Oracle

Realtime Collection

300

Online

300

Offline

900

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating