"addr" of library cache latch from v$latch

From: Rahul <rahul_at_ratelindo.co.id>
Date: Tue, 25 Jul 2000 19:20:05 +0700
Message-Id: <10569.112860@fatcity.com>

list,
on querying v$latch_children... it shows 5 children for the library_cache...

one of them looks "hot" with many "sleeps" how do i know which object/cursor/plsql in library cache this latch protects ??

does the "addr" of v$latch_children points to one of the the hash bucket (which in turn points to the object handles) or this addres directly points to the corresponding library handle linked list ??

or ...this addr points to an address in x$kglob ??

i hope i make myself clear...

TIA Received on Tue Jul 25 2000 - 07:20:05 CDT

"addr" of library cache latch from v$latch_children