Chat now with support
Chat with Support

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

Latches Activity

The Latches Activity collection collects latches activity-related data.

Oracle

Realtime Collection

20

Online

60

Offline

300

Cache Buffer Chain Latch

This latch is acquired whenever a block in the buffer cache is accessed (pinned)

Cache Buffer LRU Chain Latch

This latch is acquired in order to introduce a new block into the buffer cache and when writing a buffer back to disk, specifically when trying to scan the LRU chain that contains all of the dirty blocks in the buffer cache

Latch Free Waits

Number of waits for a latch that is currently busy (held by another process)

Library Cache Latch

This latch is acquired in order to add a new statement to the library cache. During a parse, Oracle searches the library cache for a matching statement. If one is not found, then Oracle will parse the SQL statement, obtain the library cache latch and insert the new SQL.

Library Cache Pin Latch

This latch is acquired when a statement in the library cache is re-executed

Redo Allocation Latch

This latch is acquired in order to allocate space within the redo log buffer. There is one redo allocation latch per instance.

Redo Copy Latch

This latch is acquired in order to write redo records into the redo log buffer. There may be up to LOG_SIMULTANEOUS_COPIES allocation latches.

Shared Pool Latch

This Latch is acquired when allocating and freeing memory in the shared pool

Total Active Time

Total amount of time waited for the event (in seconds)

Locks Activity

The Locks Activity collection provides locks activity-related data.

Oracle

Realtime Collection

60

Online

60

Offline

300

Average Lock Duration

The average time (in milliseconds) that a resource was locked (held in contention).

High values of lock duration may indicate aggressive lock incidence which may be improved through tuning.

The metric is calculated as follows:

100 * (Lock Wait)

Enqueue Waits

Enqueue Waits

The total number of times an enqueue request or conversion resulted in a wait.

Enqueue Waits Ratio

The percentage of enqueue wait events (waits resulting from enqueue requests or conversions) within the total time consumed by enqueue operations.

Gets

The total number of enqueue requests or enqueue conversions for this type of enqueue.

Gets Pct

The percentage of lock requests of this type within the total number of lock requests

Lock Efficiency

The percentage of lock requests that did not escalate to a blocking lock.

Lock Name

The name of the lock.

Lock Wait

The total amount of time spent waiting for the enqueue or enqueue conversion.

Waits Pct

The percentage of waits for this type of lock, of all the locks.

Locks Breakdown

The Locks Breakdown collection provides lock requests and wait information, including the percentage of time spent on locks of the following types: system, TX, TM, User-defined.

Oracle

Realtime Collection

60

Online

60

Offline

300

PDB

In multitenant architectures, the name of the pluggable database.

System Locks Percentage

The percentage of time the sessions spent waiting on System locks, out of the entire time spent waiting on locks.

System Locks Wait Time

The percentage of time the sessions spent waiting on System locks.

TM Locks Wait Time

The amount of time the sessions spent waiting on TM locks.

TM Percentage

The percentage of time the sessions spent waiting on TM locks, out of the entire time spent waiting on locks.

Total Lock Wait

The total time the sessions spent waiting on locks.

TX Locks Wait Time

The amount of time the sessions spent waiting on TX locks.

TX Percentage

The percentage of time the sessions spent waiting on TX locks, out of the entire time spent waiting on locks.

UL Locks Wait Time

The amount of time the sessions spent waiting on user-defined lock types.

UL Percentage

The percentage of time the sessions spent waiting on user-defined locks, out of the entire time spent waiting on locks.

Locks Instance

The Locks Instance collection provides summarized lock requests and application efficiency information.

Oracle

Realtime Collection

60

Online

60

Offline

300

Balance Enqueue Waits

The extent, in percents, to which enqueue wait events are balanced across RAC nodes

Balance Lock Efficiency

The extent, in percents, to which lock efficiency is balanced across RAC nodes

Balance Lock Wait

The extent, in percents, to which lock wait events are balanced across RAC nodes

Enqueue Waits

Total number of waits on enqueues

Lock Efficiency

The percentage of total locks waits within the total lock requests

Related Documents