{"id":1273,"date":"2018-02-06T11:03:41","date_gmt":"2018-02-06T03:03:41","guid":{"rendered":"http:\/\/www.821121.com\/?p=1273"},"modified":"2021-01-06T17:22:07","modified_gmt":"2021-01-06T09:22:07","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5-%e6%9f%a5%e7%9c%8b%e9%95%bf%e4%ba%8b%e5%8a%a1session","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1273","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5-\u67e5\u770b\u957f\u4e8b\u52a1session"},"content":{"rendered":"<p>\u957f\u4e8b\u52a1\uff08\u957f\u4e8b\u52a1\u3001\u8d85\u8fc710\u5206\u949f\uff09<\/p>\n<pre><code class=\"language-sql\">with transaction_details as  \n( select inst_id  \n  , ses_addr\n  , sysdate - start_date as diff  \n  from gv$transaction \n  where start_date &lt;= sysdate - interval &#039;600&#039; second \n)  \nselect s.username  \n, to_char(trunc(t.diff))  \n             || &#039; days, &#039;  \n             || to_char(trunc(mod(t.diff * 24,24)))  \n             || &#039; hours, &#039;  \n             || to_char(trunc(mod(t.diff * 24 * 60,24)))  \n             || &#039; minutes, &#039;  \n             || to_char(trunc(mod(t.diff * 24 * 60 * 60,60)))  \n             || &#039; seconds&#039; as transaction_duration  \n, s.program  \n, s.terminal\n, s.event\n, s.sql_id\n, s.sid  \n, s.serial#\n, s.INST_ID  \nfrom gv$session s  \n, transaction_details t  \nwhere s.inst_id = t.inst_id  \nand s.saddr = t.ses_addr \norder by t.diff desc  ;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u957f\u4e8b\u52a1\uff08\u957f\u4e8b\u52a1\u3001\u8d85\u8fc710\u5206\u949f\uff09 with tran<\/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-1273","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\/1273","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=1273"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions"}],"predecessor-version":[{"id":1274,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions\/1274"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1273"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}