Foglight for Oracle (Cartridge) 6.3.0 - User Guide

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.

Severity

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.