{"id":42,"date":"2012-03-01T02:17:32","date_gmt":"2012-03-01T02:17:32","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=42"},"modified":"2012-03-01T23:12:24","modified_gmt":"2012-03-01T23:12:24","slug":"dmlddl-locks","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=42","title":{"rendered":"DML\/DDL locks"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 130<br \/>\nSET PAGESIZE 66<\/p>\n<p>COLUMN Object   FORMAT a30     HEADING 'Object'<br \/>\nCOLUMN Type     FORMAT a4      HEADING 'Type'<br \/>\nCOLUMN UserID   FORMAT a20     HEADING 'OS\/Oracle'<br \/>\nCOLUMN Hold     FORMAT a10     HEADING 'Hold'<br \/>\nCOLUMN Program  FORMAT a35     HEADING 'Program'<br \/>\nCOLUMN usercode FORMAT a12     HEADING 'SID\/Serial#'<br \/>\nCOLUMN WaitMin  FORMAT 999,999 HEADING 'Wait Time (minutes)' <\/p>\n<p>SELECT<br \/>\n    a.osuser || ':' || a.username   UserID<br \/>\n  , a.sid || '\/' || a.serial#       usercode<br \/>\n  , b.lock_type Type, b.mode_held   Hold<br \/>\n  , c.owner || '.' || c.object_name Object<br \/>\n  , a.program                       Program<br \/>\n  , ROUND(d.seconds_in_wait\/60,2)   WaitMin<br \/>\nFROM<br \/>\n    v$session       a<br \/>\n  , sys.dba_lock   b<br \/>\n  , sys.dba_objects c<br \/>\n  , v$session_wait  d<br \/>\nWHERE<br \/>\n      a.sid        =  b.session_id<br \/>\n  AND b.lock_type  IN ('DML','DDL')<br \/>\n  AND b.lock_id1   =  c.object_id<br \/>\n  AND b.session_id  =  d.sid<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<pre class=\"qcode\">\r\nSET LINESIZE 130\r\nSET PAGESIZE 66\r\n\r\nCOLUMN Object   FORMAT a30     HEADING 'Object' \r\nCOLUMN Type     FORMAT a4      HEADING 'Type'\r\nCOLUMN UserID   FORMAT a20     HEADING 'OS\/Oracle' \r\nCOLUMN Hold     FORMAT a10     HEADING 'Hold' \r\nCOLUMN Program  FORMAT a35     HEADING 'Program' \r\nCOLUMN usercode FORMAT a12     HEADING 'SID\/Serial#' \r\nCOLUMN WaitMin  FORMAT 999,999 HEADING 'Wait Time (minutes)' \r\n\r\nSELECT \r\n    a.osuser || ':' || a.username   UserID\r\n  , a.sid || '\/' || a.serial#       usercode\r\n  , b.lock_type Type, b.mode_held   Hold\r\n  , c.owner || '.' || c.object_name Object\r\n  , a.program                       Program \r\n  , ROUND(d.seconds_in_wait\/60,2)   WaitMin\r\nFROM \r\n    v$session       a\r\n  , sys.dba_lock   b\r\n  , sys.dba_objects c\r\n  , v$session_wait  d\r\nWHERE \r\n      a.sid        =  b.session_id\r\n  AND b.lock_type  IN ('DML','DDL')\r\n  AND b.lock_id1   =  c.object_id\r\n  AND b.session_id  =  d.sid\r\n\/\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SET LINESIZE 130 SET PAGESIZE 66 COLUMN Object FORMAT a30 HEADING &#8216;Object&#8217; COLUMN Type FORMAT a4 HEADING &#8216;Type&#8217; COLUMN UserID FORMAT a20 HEADING &#8216;OS\/Oracle&#8217; COLUMN Hold FORMAT a10 HEADING &#8216;Hold&#8217; COLUMN Program FORMAT a35 HEADING &#8216;Program&#8217; COLUMN usercode FORMAT a12 HEADING &#8216;SID\/Serial#&#8217; COLUMN WaitMin FORMAT 999,999 HEADING &#8216;Wait Time (minutes)&#8217; SELECT a.osuser || &#8216;:&#8217; || [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":34,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-42","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-G","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=42"}],"version-history":[{"count":4,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/42\/revisions"}],"predecessor-version":[{"id":134,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/42\/revisions\/134"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/34"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}