Latch Summary view (ILATCH)

The Latch Summary view (ILATCH) shows the source of any latch contention.

The view shows statistics for the latches that are listed. The latches can be used by multiple regions.

The regions waiting for the latches are shown by their identification number in the Rgn fields if more than one region is waiting for a latch.

At the top of the view are links to related views that can help solve latch contention.

Related topic

Analyze-contention

ILATCH view

                                 Latch Summary
 Related Views
 . Latch Delays              . Latch Delays by PSB   . Internal Monitors  
 . Latch Delays by Class     . Latch Delays by Tran
 . Latch Delays by IMS       . Average Latch Wait

               Wait    +-- Owner -------+ +--- Wait Rgns ---+ +--- Wait ---+
Latch Name ID  Cnt  ST Rgn Stat  PSB Name Rgn1 Rgn2 Rgn3 Rgn4 Totl Cnts  Avg
SCHED SUBQ SUBQ N/A -- --- ----- GENERIC  ---- ---- ---- ----    0    0    0
SCHEDULE   SCHD   0                                              0    0    0
SMB HASH   BLKM N/A -- --- ----- GENERIC  ---- ---- ---- ----    0    0    0
STATISTICS ACTL   0                                              0    0    0
STG MGR    SMGT N/A -- --- ----- GENERIC  ---- ---- ---- ----    0    0    0
TCT BLOCK  TCTB N/A -- --- ----- GENERIC  ---- ---- ---- ----    0    0    0
TERMINAL   TERM   0                                              0    0    0
USER       USER   0                                              0    0    0

No hyperlinks are available on the view.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*