Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.2.1 - 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 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.

ASM Operations

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

Oracle

Realtime Collection

300

Online

300

Offline

900

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating