{"id":99,"date":"2009-12-15T12:49:00","date_gmt":"2009-12-15T10:49:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/12\/15\/oracle-locks\/"},"modified":"2010-08-24T22:36:10","modified_gmt":"2010-08-24T20:36:10","slug":"oracle-locks","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/12\/15\/oracle-locks\/","title":{"rendered":"ORACLE LOCKS"},"content":{"rendered":"<p><b>find locks:<\/b><\/p>\n<pre class=\"code\">select <br \/>  oracle_username<br \/>  os_user_name,<br \/>  locked_mode,<br \/>  object_name,<br \/>  object_type<br \/>from <br \/>  v$locked_object a,dba_objects b<br \/>where <br \/>  a.object_id = b.object_id&nbsp;<\/pre>\n<pre class=\"code\">&nbsp;<\/pre>\n<pre class=\"code\">select l1.sid, ' BLOCK ', l2.sid from v$lock l1, v$lock l2<br \/>  where l1.block =1 and l2.request > 0<br \/>  and l1.id1=l2.id1<br \/>  and l1.id2=l2.id2;<br \/><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>find locks: select oracle_username os_user_name, locked_mode, object_name, object_typefrom v$locked_object a,dba_objects bwhere a.object_id = b.object_id&nbsp; &nbsp; select l1.sid, &#8217; BLOCK &#8217;, l2.sid from v$lock l1, v$lock l2 where l1.block =1 and l2.request > 0 and l1.id1=l2.id1 and l1.id2=l2.id2;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[16],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-locks"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=99"}],"version-history":[{"count":2,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":175,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/99\/revisions\/175"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}