Re: library cache pin wait

I am in 10.2.0.4 on redhat linux. This is also a 7 node RAC cluster.

On Tue, Oct 7, 2008 at 1:07 PM, Yong Huang <yong321_at_yahoo.com> wrote:

> > 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
>
>
>

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