{"id":125,"date":"2013-01-09T16:38:57","date_gmt":"2013-01-09T08:38:57","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=125"},"modified":"2013-01-12T17:59:55","modified_gmt":"2013-01-12T09:59:55","slug":"%e6%9f%a5%e7%9c%8benqueue%e5%92%8c%e6%9f%a5%e7%9c%8b%e9%94%81%e9%98%bb%e5%a1%9e%e8%80%85%e5%92%8c%e7%ad%89%e5%be%85%e8%80%85","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=125","title":{"rendered":"scripts\uff1a\u67e5\u770benqueue\u548c\u67e5\u770b\u9501\u963b\u585e\u8005\u548c\u7b49\u5f85\u8005"},"content":{"rendered":"<p>\u67e5\u770benqueue<br \/>\n<coolcode lang=\"sql\"><br \/>\nselect b.sid,b.serial#,b.username,b.machine,a.event,a.wait_time,<br \/>\nchr(bitand(a.p1,-16777216)\/16777215)||chr(bitand(a.p1, 16711680)\/65535) \"Enqueue Type\"<br \/>\nfrom v$session_wait a,v$session b<br \/>\nwhere a.event not like 'SQL*N%' and a.event not like 'rdbms%' and a.sid=b.sid<br \/>\nand b.sid>8 and a.event='enqueue'<br \/>\norder by b.username;<br \/>\n<\/coolcode><br \/>\n\u67e5\u770b\u9501\u963b\u585e\u8005\u548c\u7b49\u5f85\u8005<br \/>\n<coolcode lang=\"sql\"><br \/>\nSELECT DECODE(request, 0, 'Holder :', 'Waiter :') || sid sess,<br \/>\n       id1,<br \/>\n       id2,<br \/>\n       lmode,<br \/>\n       2 request,<br \/>\n       type<br \/>\n  FROM V$LOCK<br \/>\n WHERE (id1, id2, type) IN<br \/>\n       (SELECT id1, id2, type FROM V$LOCK WHERE request > 0)<br \/>\n ORDER BY id1, request;<br \/>\n<\/coolcode><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770benqueue select b.sid,b.serial#,b.username,b.machine,a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/125"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=125"}],"version-history":[{"count":9,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/125\/revisions"}],"predecessor-version":[{"id":364,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/125\/revisions\/364"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=125"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}