Chat now with support
Chat with Support

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

Scattered Read

I/O operation in which multiple disk blocks are read and scattered into different discontinuous buffers in the SGA. This is typical of the I/O that results from performing operations that require processing large amounts of data, such as full table scans, sorting, or Oracle Parallel Queries (OPQs).

Schema Locks

A lock mode that is used when compiling a query, to prevent changes to the underlying tables structures while the query is compiled.

Sequential Read

I/O operation in which disk blocks (usually single blocks) are read in sequence into contiguous memory space. This is typical of the I/O that results, for example, from using indexes.


Represents how critical an alarm is. A severity determines how Foglight for Oracle behaves when the values for a metric fall within a user-defined range of values. A severity specifies whether the information returned in the metric represents normal or abnormal behavior for the system under diagnosis. For example, unusually high values might mean that a metric has crossed a threshold into a high severity state. This, in turn, could change the color of a component on the home page; for example, from orange to red when moving from a critical to a fatal state.

The severity determines what action Foglight for Oracle takes when a metric value falls into the range defined by a threshold.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating