{"id":1177,"date":"2011-05-02T11:43:25","date_gmt":"2011-05-02T16:43:25","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=1177"},"modified":"2011-07-06T10:01:10","modified_gmt":"2011-07-06T15:01:10","slug":"running-procedures","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2011\/05\/02\/running-procedures\/","title":{"rendered":"Running procedures?"},"content":{"rendered":"<p>You can use what is below to print out each session that is currently executing (or has pinned) a given stored procedure<\/p>\n<pre lang=\"sql\" line=\"1\">\r\ncolumn owner format a20\r\ncolumn name format a30\r\ncolumn type format a15\r\nset lines 255 trims on\r\nSELECT substr(DECODE(o.kglobtyp,7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13,'CLASS'),1,15)  \"TYPE\",\r\n       substr(o.kglnaown,1,30)  \"OWNER\",\r\n       substr(o.kglnaobj,1,30)  \"NAME\",\r\n       s.indx  \"SID\",\r\n       s.ksuseser  \"SERIAL\"\r\n  FROM sys.X$KGLOB  o,\r\n       sys.X$KGLPN  p,\r\n       sys.X$KSUSE  s\r\n  WHERE o.inst_id = USERENV('Instance')\r\n    AND p.inst_id = USERENV('Instance')\r\n    AND s.inst_id = USERENV('Instance')\r\n    AND o.kglhdpmd = 2\r\n    AND o.kglobtyp IN (7, 8, 9, 12, 13)\r\n    AND p.kglpnhdl = o.kglhdadr\r\n    AND s.addr = p.kglpnses\r\n  ORDER BY 1, 2, 3;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>You can use what is below to print out each session that is currently executing (or has pinned) a given stored procedure column owner format a20 column name format a30 column type format a15 set lines 255 trims on SELECT&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2011\/05\/02\/running-procedures\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/1177"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1177"}],"version-history":[{"count":5,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/1177\/revisions"}],"predecessor-version":[{"id":1319,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/1177\/revisions\/1319"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1177"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}