v$latch_children

<pre name="code" class="sql">SQL> set linesize 200
SQL>  select addr,LATCH#,LEVEL#,CHILD#,NAME,gets  from v$latch_children where name='shared pool';

ADDR	     LATCH#	LEVEL#	   CHILD# NAME									 GETS
-------- ---------- ---------- ---------- ---------------------------------------------------------------- ----------
200A7B30	293	     7		7 shared pool								   10
200A7ACC	293	     7		6 shared pool								   10
200A7A68	293	     7		5 shared pool								   10
200A7A04	293	     7		4 shared pool								   10
200A79A0	293	     7		3 shared pool								   10
200A793C	293	     7		2 shared pool								   10
200A78D8	293	     7		1 shared pool								53967

已选择7行。

V$LATCH_CHILDREN

V$LATCH_CHILDREN displays 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  显