Re: library cache pin wait

From: Yong Huang <>
Date: Tue, 7 Oct 2008 10:07:23 -0700 (PDT)
Message-ID: <>

> 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       

Received on Tue Oct 07 2008 - 12:07:23 CDT

Original text of this message