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#
-------- ---------- ----------
2D32792C	150	     1
2D3279A8	150	     2
2D327A24	150	     3
2D327AA0	150	     4
2D327D1C	150	     5

转载于:https://www.cnblogs.com/zhaoyangjian724/p/3797984.html