{"id":1275,"date":"2018-02-07T10:22:28","date_gmt":"2018-02-07T02:22:28","guid":{"rendered":"http:\/\/www.821121.com\/?p=1275"},"modified":"2021-01-06T17:23:32","modified_gmt":"2021-01-06T09:23:32","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5-%e5%9b%9e%e6%bb%9a%e6%ae%b5%e7%8a%b6%e6%80%81","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1275","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5-\u56de\u6eda\u6bb5\u72b6\u6001"},"content":{"rendered":"<p>\u56de\u6eda\u6bb5\u72b6\u6001\uff08\u68c0\u67e5\u6d3b\u52a8\u3001\u8fc7\u671f\u3001\u672a\u4f7f\u7528\u6bb5\u5927\u5c0f\uff09<\/p>\n<pre><code class=\"language-sql\">select a.owner,a.tablespace_name,a.status,a.use_mb,\n      round(a.use_mb \/ b.total_mb * 100) use_precent\n  from (select owner,tablespace_name,status,\n              sum(bytes) \/ 1024 \/ 1024 use_mb\n          from dba_undo_extents\n        where status=&#039;ACTIVE&#039;\n        group by owner, tablespace_name, status) a,\n      (select tablespace_name, sum(bytes) \/ 1024 \/ 1024 total_mb\n          from dba_data_files\n        where tablespace_name like &#039;%UNDO%&#039;\n        group by tablespace_name) b\nwhere a.tablespace_name = b.tablespace_name\norder by 1, 2, 3;<\/code><\/pre>\n<p>\u56de\u6eda\u6bb5\u72b6\u6001\uff08\u7b5b\u9009\u4f7f\u7528\u8d85\u8fc7500MB\u5355\u4e2a\u8fdb\u7a0b\uff09<\/p>\n<pre><code class=\"language-sql\">select a.inst_id,a.username,a.sql_id,a.prev_sql_id,b.name,c.used_ublk*8192\/1024\/1024 use_mb\n  from gv$session a, v$rollname b, v$transaction c\nwhere a.saddr = c.ses_addr\n  and b.usn = c.xidusn\n  and c.used_ublk * 8192 \/ 1024 \/ 1024 &gt; 50\norder by 5;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u56de\u6eda\u6bb5\u72b6\u6001\uff08\u68c0\u67e5\u6d3b\u52a8\u3001\u8fc7\u671f\u3001\u672a\u4f7f\u7528\u6bb5\u5927\u5c0f\uff09 sel<\/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-1275","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\/1275","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=1275"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1275\/revisions"}],"predecessor-version":[{"id":1276,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1275\/revisions\/1276"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1275"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}