{"id":1277,"date":"2018-02-08T14:24:19","date_gmt":"2018-02-08T06:24:19","guid":{"rendered":"http:\/\/www.821121.com\/?p=1277"},"modified":"2021-01-06T17:25:00","modified_gmt":"2021-01-06T09:25:00","slug":"%e5%b8%b8%e7%94%a8sql%e8%af%ad%e5%8f%a5-%e4%b8%b4%e6%97%b6%e6%ae%b5%e4%bd%bf%e7%94%a8%e6%83%85%e5%86%b5","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1277","title":{"rendered":"\u5e38\u7528sql\u8bed\u53e5-\u4e34\u65f6\u6bb5\u4f7f\u7528\u60c5\u51b5"},"content":{"rendered":"<p>\u4e34\u65f6\u6bb5\u4f7f\u7528\u60c5\u51b5<\/p>\n<pre><code class=\"language-sql\">SELECT d.tablespace_name &quot;TABLESPACE_NAME&quot;,\n      TO_CHAR(NVL(a.bytes \/ 1024 \/ 1024, 0), &#039;99999999&#039;) &quot;SUM(MB)&quot;,\n      TO_CHAR(NVL(t.bytes, 0) \/ 1024 \/ 1024, &#039;999999999&#039;) &quot;USED(MB)&quot;,\n      TO_CHAR(NVL(t.bytes \/ a.bytes * 100, 0), &#039;990.00&#039;) &quot;USED(%)&quot;,\n      (a.bytes - t.bytes) \/ 1024 \/ 1024 &quot;FREE(MB)&quot;,\n      d.status &quot;Status&quot;\n  FROM sys.dba_tablespaces d,\n      (select tablespace_name, sum(bytes) bytes\n          from dba_temp_files\n        group by tablespace_name) a,\n      (select tablespace_name, sum(bytes_cached) bytes\n          from gv$temp_extent_pool\n        group by tablespace_name) t\nWHERE d.tablespace_name = a.tablespace_name(+)\n  AND d.tablespace_name = t.tablespace_name(+)\n  AND d.contents like &#039;TEMPORARY&#039;\norder by 4 desc;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e34\u65f6\u6bb5\u4f7f\u7528\u60c5\u51b5 SELECT d.tablespa<\/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-1277","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\/1277","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=1277"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1277\/revisions"}],"predecessor-version":[{"id":1278,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1277\/revisions\/1278"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1277"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}