{"id":1345,"date":"2018-02-12T09:09:15","date_gmt":"2018-02-12T01:09:15","guid":{"rendered":"http:\/\/www.821121.com\/?p=1345"},"modified":"2021-01-07T17:11:11","modified_gmt":"2021-01-07T09:11:11","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5-%e6%9f%a5%e7%9c%8bvsession%e4%b8%ad%e4%b8%8e%e5%ae%a2%e6%88%b7%e7%ab%af%e6%9c%89%e5%85%b3%e7%9a%84%e4%bc%9a%e8%af%9d%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1345","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5-\u67e5\u770bv$session\u4e2d\u4e0e\u5ba2\u6237\u7aef\u6709\u5173\u7684\u4f1a\u8bdd\u4fe1\u606f"},"content":{"rendered":"<p>--Oracle\u7528\u6237\u540d<\/p>\n<pre><code class=\"language-sql\">select t.username,count(*) from v$session t where type&lt;&gt; &#039;BACKGROUND&#039;  group by username order by 2 desc;<\/code><\/pre>\n<p>--\u64cd\u4f5c\u7cfb\u7edf\u5ba2\u6237\u7aef\u7528\u6237\u540d<\/p>\n<pre><code class=\"language-sql\">select t.osuser,count(*) from v$session t where type&lt;&gt; &#039;BACKGROUND&#039;  group by osuser order by 2 desc;<\/code><\/pre>\n<p>--\u64cd\u4f5c\u7cfb\u7edf\u673a\u5668\u540d\u79f0<\/p>\n<pre><code class=\"language-sql\">select t.MACHINE,count(*) from v$session t where type&lt;&gt; &#039;BACKGROUND&#039;  group by MACHINE order by 2 desc;<\/code><\/pre>\n<p>--\u64cd\u4f5c\u7cfb\u7edf\u7a0b\u5e8f\u540d\u79f0<\/p>\n<pre><code class=\"language-sql\">select t.PROGRAM,count(*) from v$session t where type&lt;&gt; &#039;BACKGROUND&#039;  group by PROGRAM order by 2 desc;<\/code><\/pre>\n<p>--\u901a\u8fc7\u8c03\u7528DBMS_APPLICATION_INFO.SET_MODULE\u8fc7\u7a0b,\u8bbe\u7f6e\u7684\u5f53\u524d\u6267\u884c\u6a21\u5757\u7684\u540d\u79f0<\/p>\n<pre><code class=\"language-sql\">select t.MODULE,count(*) from v$session t where type&lt;&gt; &#039;BACKGROUND&#039;  group by MODULE order by 2 desc;<\/code><\/pre>\n<p>--\u901a\u8fc7\u8c03\u7528DBMS_APPLICATION_INFO.SET_ACTION\u8fc7\u7a0b \u8bbe\u7f6e\u7684\u5f53\u524d\u6b63\u5728\u6267\u884c\u7684\u52a8\u4f5c\u7684\u540d\u79f0<\/p>\n<pre><code class=\"language-sql\">select t.ACTION,count(*) from v$session t where type&lt;&gt; &#039;BACKGROUND&#039;  group by ACTION order by 2 desc;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;Oracle\u7528\u6237\u540d select t.user<\/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-1345","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\/1345","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=1345"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1345\/revisions"}],"predecessor-version":[{"id":1346,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1345\/revisions\/1346"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1345"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}