Identifying lead blockers with the Oracle database agent (4264775)

How to identify lead blockers in Foglight for Oracle?

There are many existing locks shown in Oracle monitored instance Activity | Locks page. Who are the lead blockers?

To track down the lead blockers in Oracle, focus on the locks with the Longest Lock Duration metric.

1. Navigate to Activity | Locks - under Locks Historical Tree, click on the snapshot that has the longest lock duration (2nd column)
2. Within the Lock Tree for Selected Snapshot table, there is a breakdown of all sessions with Lock Duration metric.

For more information on locks, please see the Reviewing Locks Activity at the Instance Level.