Blocking Locks

Performance Analysis for Oracle

Blocking Locks Tab

When the Lock Resource is chosen, the Blocking Locks tab is visible. At the instance view level, the resulting pane listed entries comprise all locks occurring in the specified time period, the objects for which the wait was incurred and the lock duration (in accordance with the = 4) BSPSPopupOnMouseOver(event)" class=BSSCPopup id=A1>totaling method).

At the level of a drilldown into a specific Dimension, you can see the objects on which the current activity has been locked. Expanding the object displays the list of activities (characterized by their dimensions) that created the lock on that specific object and therefore blocked the current activity. Duration represents the time period for which this lock occurred. Clicking on a dimension entry facilitates a roll-up of the tree node with the selected dimension in focus, so that you can initiate an investigation of the locking source.

 

Related Topic