Shared Pool and Library Cache Latches

select a.ksppinm, b.ksppstvl

from x$ksppi a, x$ksppsv b

where a.indx = b.indx

and a.ksppinm = ’_kghdsidx_count’;

KSPPINM KSPPSTVL

------------------ ----------

_kghdsidx_count 2

select addr, kghluidx, kghlufsh, kghluops, kghlurcr, kghlutrn, kghlumxa

from x$kghlu;

ADDR KGHLUIDX KGHLUFSH KGHLUOPS KGHLURCR KGHLUTRN KGHLUMXA

---------------- -------- ---------- ---------- -------- -------- ----------

80000001001581B8 2 41588416 496096025 14820 17463 2147483647

8000000100157E18 1 46837096 3690967191 11661 19930 2147483647

select addr, name, gets, misses, waiters_woken

from v$latch_children

where name = 'shared pool’;

ADDR NAME GETS MISSES WAITERS_WOKEN

---------------- ------------- ----------- ---------- -------------

C00000004C5B06B0 shared pool 0 0

0C00000004C5B0590 shared pool 0 0

0C00000004C5B0470 shared pool 0 0

0C00000004C5B0350 shared pool 0 0

0C00000004C5B0230 shared pool 0 0

0C00000004C5B0110 shared pool 1385021389 90748637 12734879

C00000004C5AFFF0 shared pool 2138031345 413319249 44738488