DBA FUS‎ > ‎

Who is pinning the object - Library cache waiting

posted Sep 11, 2010, 5:21 AM by Sachchida Ojha
SELECT s.sid, s.serial#, s.username, s.osuser, s.machine, s.status,
kglpnmod "Mode", kglpnreq "Req"
    FROM x$kglpn p, v$session s WHERE p.kglpnuse=s.saddr AND
kglpnhdl='value of p1raw';
Comments