Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.7.5.41 - 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) Reviewing Overall Activity Reviewing RAC Historic Activity Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert and Error Logs Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Reviewing Locks Activity at the Cluster Level

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

•
Locks Activity
•
Lock Tree (Current)
•
Locks Historical Tree
Locks Activity

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

 
Table 9. Locks Activity pane
Name
Description

Lock Name

The name of the lock.

Gets

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.

Alarms

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.

Lock Tree (Current)

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 .

 
Table 10. Lock Tree (Current)
Name
Description

PDB

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

Session

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

Serial

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:

•
TM — DML enqueue
•
TX — Transaction enqueue
•
UL — User supplied

Lock Mode

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

•
None
•
Null
•
Row-S (SS)
•
Row-X (SX)
•
Share
•
S/Row-X (SSX)
•
Exclusive

Lock Request Mode

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

•
None
•
Null
•
Row-S (SS)
•
Row-X (SX)
•
Share
•
S/Row-X (SSX)
•
Exclusive

Lock Duration

The duration of the lock in seconds.

Cross Instance

Defines whether the lock is between different cluster nodes:

•
YES — for global locks
•
NO — for single node locks

Instance

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.

NOTE: Killing a session requires having specific privileges. Please provide an Oracle user with these privileges. Alternatively, select the check box Log-in as SYSDBA to provide the credentials of a SYSDBA user.
Session Details Popup
 
Table 11. Session Details Popup
Name
Description

SID

The session identifier

Serial

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

Process

The process number

DB User

The database user name

OS

The operating system name

Program

The name of the program that is processing the SQL statements

Client

The Client computer identifier

Host

The host computer identifier

Current SQL

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

Locks Historical Tree

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:

•
Lock Wait Events — a chart that displays all of the lock wait events, plotted over time. This chart can be viewed in either of the following views:
•
Baseline — displaying only lock wait events.
•
Breakdown — displaying both lock and non-lock wait events.
•
Locks Exceeding a predefined threshold — displays locks that reached or exceeded the minimal duration, in seconds, which a lock should reach or exceed in order to be collected.
* 
NOTE: The minimal duration’s length is defined using the Locks pane of the Collection Settings view.

Reviewing Locks Activity at the Instance Level

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

•
Locks Wait Events chart
The content of this pane is similar to that of the chart displayed under the Activity > Locks > Locks Historical Tree pane at the Whole Cluster mode. For more information, see Locks Historical Tree.
•
Locks Activity pane — identical to the Locks Activity pane in the Whole Cluster mode. For more information, see Locks Activity.
•
Locks Tree (Current) pane — identical to the Locks Tree (Current) pane in the Whole Cluster mode. For more information, see Lock Tree (Current).
•
Locks Historical Tree — see Locks Historical Tree .
Locks Historical Tree

The Locks Historical Tree pane displays the locks activity and the locks tree summary, plotted over time.

This pane includes the sections listed below.

•
Locks Activity — this section, which is identical to the Locks Activity section in the Locks Overview pane, displays the lock wait (average active sessions), which can be plotted as either:
•
Baseline — lock wait time plotted over time.
•
Breakdown — lock wait and non-lock wait plotted over time.
•
Locks Exceeding a predefined threshold — displays locks that reached or exceeded the minimal duration, in seconds, which a lock should reach or exceed in order to be collected. The minimal duration’s length is defined using the Locks pane of the Collection Settings view.

Viewing Detailed Sessions Data

The Sessions screen allows you to trace the activity of all currently connected sessions, as well as their resource consumption.

* 
NOTE: The refresh rate of the data displayed on the Sessions panel can be set by selecting a value from the Refresh interval drop-down list, which appears on the panel’s upper right side.

 

This panel can also be used to carry out the tasks described in the following sections:

•
Sessions Summary
•
Sessions Details
•
Session Drill Down
Sessions Summary

The Current section in the top of the screen allows you to view current Key Performance Indicators of the monitored instance:

•
Sessions - Displays the distribution of the currently connected sessions between active (sessions that are currently running a SQL statement) and inactive sessions.
•
Throughput — Divided into 4 metrics which represent the throughput of the monitored instance:
•
Logons/s — The rate per second of sessions that were initiated during the current sampling period.
•
Executions/s — The rate per second of statements executions during the current sampling period.
•
Commits/s — The rate per second of commits during the current sampling period.
•
Rollbacks/s — The rate per second of rollbacks during the current sampling period.
•
Locks — Displays the total number of blocked sessions during the current sampling period.
•
Host CPU Utilization — The host CPU utilization % during the current sampling period.

The Last 1 hour trend presents the activity on the instance during the last 1 Hour by presenting:

•
Workload — Displays the general workload (average active sessions) during the specified time range.
•
Breakdown — Displays the workload, distributed by the various wait event categories. The colors of the categories match the colors of the various resources displayed in the Resource Breakdown section.
By clicking the Top Wait Events link at the upper right corner of the section, The Active Wait Events popup appears, with the Resource drop-down list unfiltered and displaying the entire list of wait events
Sessions Details

The current sessions table allows you to monitor the currently running sessions and their individual resource consumption. The Session List section contains a table that lists all currently running sessions, displaying each session in a separate row.

The Sessions view in the table can be filtered by the Active only and Foreground Only check boxes:

•
Active only — selected by default, presenting only the active sessions that are currently running, by clearing the check box, all inactive sessions will be presented as well.
•
Foreground only — selected by default, presenting only the user sessions, by clearing the check box, the background sessions will be presented as well.
Session Drill Down

The various sections of the Session Drill Down page provide detailed information about the selected session upon selecting a specific session in the table.

Session Identification Section

The left section of the screen displays several parameters that provide general information about the selected session, as follows:

•
SID — Session identifier. NOTE: Clicking on the Session ID enables you to switch sessions from a popup list of current sessions.
•
Serial# — Session serial number.
•
Logon Time — The time when the user logged on to the session.
•
Status — Indicates whether the session is active or inactive.
•
DB User — The Oracle login name for this session.
•
OS User — The OS login name for this session.
•
Program — The name of the program the user is running to access Oracle
•
Machine — The name of the host the session is running from.

Waiting On — The current wait event on which the session is waiting.

Reviewing Workload Details

The Workload chart displays the selected session workload (Average Active Sessions) during the specified time range (default 1 Hr.). The breakdown displays the workload, distributed by the various wait event categories. The colors of the categories match the colors of the various resources displayed in the Resource Breakdown section.

By clicking the Top Wait Events link at the upper right corner of the section, The Active Wait Events popup appears, with the Resource drop-down list unfiltered and displaying the entire list of wait events.

Reviewing SQL Summary

This tab provides details about the SQL statements that were executed by the selected session during the selected time range (up to 1 hour).

Reviewing Sessions Statistics

Additional statistics are displayed in the “Session Statistics” tab.

Reviewing Session Blocks

The Session Blocks pane displays all blocks held or requested by the selected session.

Viewing Datafiles I/O Activity at the Cluster Level

The Overall Datafiles I/O panel displays the I/O activity of all datafiles on the cluster. This panel includes the following sections:

•
Total Physical I/O chart
•
Datafiles I/O Summary table
Physical I/O chart

The Physical I/O chart displays the physical I/O activity within the cluster’s datafiles, in either of the following methods:

•
Baseline — displays the physical I/O activity along with the allowed range of typical observed behavior. Use the chart, in its baseline form, to display either a specific metric or all of the metrics.
Metric values and typical behavior are plotted over time.
•
Breakdown — provides a color-coded display of the physical activity of all instances within the RAC. Select whether to display the total physical I/O, only physical reads or only physical writes.

Click the arrow to the right of the Physical I/O title to display data for the total physical activity, or only for physical reads or writes.

Datafiles I/O Summary Table

The Datafiles I/O Summary table displays all of the I/O activity details of all datafiles on the cluster. Clicking the datafile’s name displays the Physical I/O Activity page, which presents the datafile’s physical read and writes, plotted over the time range, along with the overall physical reads and writes.

* 
IMPORTANT: To view the specific datafile’s storage data, click the link Datafile Storage, on the upper right side of the Physical I/O Activity page. For details, see Datafile-specific Page .
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating