Re: library cache pin wait

> to get the really pinned objects x$kglpn must be used - no v$-view is there
> for this to oracle 10.2, for oracle 11 I don't have the information.

Not in 11g either. Although no v$ view exposes x$kglpn, DBA_KGLLOCK does. It's documented. But unlike your v$code_object_in_use, the columns in DBA_KGLLOCK are obviously not as user friendly, and pins are mixed with KGL locks in it (need filter where kgllktype='Pin').

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l