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

Reviewing Instance Usability

The Instance Usability panel displays aggregated information regarding the instance’s usability and availability.

This panel supports the following tasks:

The Instance pane contains the following indicators:

The Alarms pane displays the usability-related outstanding alarms. These alarms alert the following issues per instance: response time, instance availability, instance connection availability, OS connection availability, instance connection time, and Listener status.

The Instance Availability section displays the instance availability in percentages, plotted over the time range. If the instance was unavailable once or more during this time, the relevant message describing the last occurrence of unavailability appears in the Error Message box.

The Listener Availability section displays the availability of all listeners configured for the instance, in percentages, plotted over the time range. If one or more of the listeners were unavailable during this time, a message describing this issue appears under the Listener Errors section.

The Connection Time section displays the instance’s connection time, in seconds, plotted over the time range.

The Response Time section displays the instance’s response time, in milliseconds, plotted over the time range.

Reviewing Cluster Usability

Use the Cluster Usability panel to compare between the various RAC nodes, regarding the following indicators:

To investigate a single instance, select the requested instance from the list at the top of the panel. The display switches to instance usability. For details, see Reviewing Instance Usability .

Reviewing Locks Activity at the Cluster Level

The Activity Locks panel for a RAC comprises the following panes:

The Locks Activity pane displays a breakdown of all lock types and their general properties.

Lock Name

The name of the lock.


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

Gets Rate

The rate of lock gets.

Gets (percent)

The percentage of lock gets for this type of lock within the total number of locks.

Enqueue Waits

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

Waits Rate

The number of wait events per second.

Wait (percent)

The percentage of wait events for this type of lock within the total number of locks.

Lock Wait

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

Average Lock Duration

The average length of time for a lock, in milliseconds.

Lock Efficiency

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


The number of warning, critical, and fatal alarms that were invoked for this Oracle database instance.

Holding the cursor over each alarm type displays a dwell that shows the most recent alarms invoked for this database instance, sorted by severity.

Click each alarm type to drill down and manage the alarms. See the Foglight Online Help, Monitoring System-Wide Alarms for details on the alarm information.

The Lock Tree (Current) pane displays current data, which is available only in real-time mode.

Clicking any locking or locked session table row displays a popup that is used for viewing further details. For information see Session Details Popup .


In multitenant architectures, the name of the pluggable database where the lock took place.


The identifier for a session that holds or acquires the lock.


The session’s serial number. The combination of SID and serial number provides a unique identification of the session.

DB User

The database user name.

Object Wanted

The object requested for lock.

Lock Type

The type of user or system lock.

The locks on the user types are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks. The user type locks are:

Lock Mode

The lock mode in which the session holds the lock. This row can have one of the following values:

Lock Request Mode

The lock mode in which the process requests the lock. This row can have one of the values listed below.

Lock Duration

The duration of the lock in seconds.

Cross Instance

Defines whether the lock is between different cluster nodes:


The name of the instance to which the blocking or blocked session belongs.

Kill Session

Used for terminating the selected session, by means of the Kill Session dialog box that is displayed upon clicking this column.



The session identifier


The session’s serial number. The combination of SID and serial number provides a unique identification of the session.


The process number

DB User

The database user name


The operating system name


The name of the program that is processing the SQL statements


The Client computer identifier


The host computer identifier

Current SQL

The SQL text of the SQL statement that is currently being processed in this session

The Locks Historical Tree pane displays the overall locks activity that took place within the selected time range, as well as locks that exceeded a predefined threshold.

This pane comprises the following sections:

Reviewing Locks Activity at the Instance Level

The Activity Locks panel, which displays lock summary information for an Oracle instance, comprises the following panes:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating