{"id":161,"date":"2012-06-07T14:13:52","date_gmt":"2012-06-07T14:13:52","guid":{"rendered":"http:\/\/tomas.papp.me.uk\/?p=161"},"modified":"2012-06-07T14:13:52","modified_gmt":"2012-06-07T14:13:52","slug":"library-cache-lock","status":"publish","type":"post","link":"https:\/\/tomas.papp.me.uk\/?p=161","title":{"rendered":"Library cache lock"},"content":{"rendered":"<p>Wait details:<\/p>\n<pre>select\r\n distinct\r\n ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,ses.ksuseunm machine,\r\n ob.kglnaown obj_owner, ob.kglnaobj obj_name\r\n ,pn.kglpncnt pin_cnt, pn.kglpnmod pin_mode, pn.kglpnreq pin_req\r\n , w.state, w.event, w.wait_Time, w.seconds_in_Wait\r\n -- lk.kglnaobj, lk.user_name, lk.kgllksnm,\r\n --,lk.kgllkhdl,lk.kglhdpar\r\n --,trim(lk.kgllkcnt) lock_cnt, lk.kgllkmod lock_mode, lk.kgllkreq lock_req,\r\n --,lk.kgllkpns, lk.kgllkpnc,pn.kglpnhdl\r\n from\r\n x$kglpn pn, x$kglob ob,x$ksuse ses\r\n , v$session_wait w\r\n where pn.kglpnhdl in\r\n (select kglpnhdl from x$kglpn where kglpnreq &gt;0 )\r\n and ob.kglhdadr = pn.kglpnhdl\r\n and pn.kglpnuse = ses.addr\r\n and w.sid = ses.indx\r\n order by seconds_in_wait desc\r\n \/<\/pre>\n<p>Holders\/waiters<\/p>\n<pre>select\r\n distinct\r\n ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,KSUSEMNM module,\r\n ob.kglnaown obj_owner, ob.kglnaobj obj_name\r\n ,lk.kgllkcnt lck_cnt, lk.kgllkmod lock_mode, lk.kgllkreq lock_req\r\n , w.state, w.event, w.wait_Time, w.seconds_in_Wait\r\n from\r\n x$kgllk lk, x$kglob ob,x$ksuse ses\r\n , v$session_wait w\r\n where lk.kgllkhdl in\r\n (select kgllkhdl from x$kgllk where kgllkreq &gt;0 )\r\n and ob.kglhdadr = lk.kgllkhdl\r\n and lk.kgllkuse = ses.addr\r\n and w.sid = ses.indx\r\n order by seconds_in_wait desc\r\n \/<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Wait details: select distinct ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,ses.ksuseunm machine, ob.kglnaown obj_owner, ob.kglnaobj obj_name ,pn.kglpncnt pin_cnt, pn.kglpnmod pin_mode, pn.kglpnreq pin_req , w.state, w.event, w.wait_Time, w.seconds_in_Wait &#8212; lk.kglnaobj, lk.user_name, lk.kgllksnm, &#8211;,lk.kgllkhdl,lk.kglhdpar &#8211;,trim(lk.kgllkcnt) lock_cnt, lk.kgllkmod lock_mode, lk.kgllkreq lock_req, &#8211;,lk.kgllkpns, lk.kgllkpnc,pn.kglpnhdl from x$kglpn pn, x$kglob ob,x$ksuse ses , v$session_wait w where pn.kglpnhdl in (select kglpnhdl from x$kglpn [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-161","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=161"}],"version-history":[{"count":1,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions"}],"predecessor-version":[{"id":162,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions\/162"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}