Online Documentation for SQL Manager for Oracle

Latches


Latches are low level serialization mechanisms used to protect shared data structures in the SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process will wait for a latch and for how long.

 

The Latches tab displays aggregate latch statistics for both parent and child latches, grouped by latch name.

 

Database Statistics - Latches

 

The list displays latches as a grid with the following columns: Name, PID, Immediate Gets, Immediate Misses, Gets, Misses, Sleeps. If more convenient, you can change the order of the columns by dragging their headers horizontally.

 

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

 

Click a column caption to sort items by values of this column in the ascending or the descending mode.

 

In order to filter items in grid, you can use Custom Filter and Filter Builder dialog. For more information refer to the Filtering records page.