V$LATCH_PARENT和V$LATCH_CHILDREN

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#-------- ---------- ----------2D32792C150     12D3279A8150     22D327A24150     32D327AA0150     42D327D1C150     5