{"id":1471,"date":"2017-04-03T09:58:54","date_gmt":"2017-04-03T01:58:54","guid":{"rendered":"http:\/\/www.821121.com\/?p=1471"},"modified":"2021-03-03T10:03:27","modified_gmt":"2021-03-03T02:03:27","slug":"lists-all-locked-objects-for-rac","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1471","title":{"rendered":"Lists all Locked Objects for RAC"},"content":{"rendered":"<pre><code class=\"language-sql\">SET PAGESIZE 300\nSET LINESIZE 300\nCOLUMN owner FORMAT A20\nCOLUMN username FORMAT A20\nCOLUMN object_owner FORMAT A20\nCOLUMN object_name FORMAT A30\nCOLUMN locked_mode FORMAT A15\n\nSELECT b.inst_id,\n       b.session_id AS sid,\n       NVL(b.oracle_username, &#039;(oracle)&#039;) AS username,\n       a.owner AS object_owner,\n       a.object_name,\n       Decode(b.locked_mode, 0, &#039;None&#039;,\n                             1, &#039;Null (NULL)&#039;,\n                             2, &#039;Row-S (SS)&#039;,\n                             3, &#039;Row-X (SX)&#039;,\n                             4, &#039;Share (S)&#039;,\n                             5, &#039;S\/Row-X (SSX)&#039;,\n                             6, &#039;Exclusive (X)&#039;,\n                             b.locked_mode) locked_mode,\n       b.os_user_name\nFROM   dba_objects a,\n       gv$locked_object b\nWHERE  a.object_id = b.object_id\nORDER BY 1, 2, 3, 4<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SET PAGESIZE 300 SET LINE<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,48],"tags":[],"class_list":["post-1471","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-sql"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1471"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1471\/revisions"}],"predecessor-version":[{"id":1473,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1471\/revisions\/1473"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1471"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}