V$LATCH_PARENT contains statistics about parent latches. The columns of V$LATCH_PARENT are identical to those in V$LATCH. 包含父latches的统计信息 这个表中存放的是独立latch和父latch,每一个latch存放一条记 V$LATCH_CHILDREN contains statistics about child latches. This view includes all columns of V$LATCH plus the CHILD# column. Note that child latches have the same parent if their LATCH# columns match each other. V$LATCH_CHILDREN 包含child latches的统计信息,child latches 有同样的父lacth# SQL> select * from (select ADDR,latch#,child# from v$latch_children where name = 'cache buffers chains' order by 3) where rownum<6; ADDR LATCH# CHILD# -------- ---------- ---------- 2D32792C 150 1 2D3279A8 150 2 2D327A24 150 3 2D327AA0 150 4 2D327D1C 150 5