定位library cache lock的方法(二)
FROM v$session_wait b
WHERE b.EVENT in (' library cache pin','library cache lock' ) )
前提是sesion 没有被 killed 掉, 如果被killed , v$session.paddr <> v$process.addr.