Chatta subito con l'assistenza
Chat con il supporto

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

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

Locks Tree

The Locks Tree Instance collection provides lock tree information at the instance level.

Oracle

Realtime Collection

20

Blocked SQL

The SQL statement waiting for lock release.

Blocking Serial

The session serial number is either:

Blocking SID

The session identifier for the session is holding the object (locking).

Client Machine

The name of the Client machine

Cross Instance

The lock is between different cluster nodes for global locks.

DB User Name

The Oracle user, which is either:

Host

The host where the Oracle instance is installed, which is either:

Instance

The Oracle instance session is either:

Lock Duration

The wait length of time, in seconds.

Lock Event

The event on which the blocked session is waiting

Lock Mode

The lock mode in which the session holds the lock

Lock Request Mode

The lock mode in which the process requests the lock

Lock Type

The type of user or system lock.

Object Wanted

The object requested for lock.

OS User Name

The OS user name with which the session logged in is either:

PDB

In multitenant architectures, the name of the pluggable database.

PID

The operating system process ID for the Oracle server process. The process ID is either:

Program

The operating system program is either:

Serial

The session serial number is either:

SID

The blocked session’s system ID (SID)

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione