Re: library cache pin wait
Date: Tue, 7 Oct 2008 10:07:23 -0700 (PDT)
> 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 HuangReceived on Tue Oct 07 2008 - 12:07:23 CDT