{"id":53,"date":"2013-01-08T17:59:43","date_gmt":"2013-01-08T09:59:43","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=53"},"modified":"2013-01-12T18:00:51","modified_gmt":"2013-01-12T10:00:51","slug":"tools-scripts","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=53","title":{"rendered":"scripts:\u67e5\u770b\u6570\u636e\u5e93\u8868\u7a7a\u95f4\u5269\u4f59\u91cf"},"content":{"rendered":"<p>\u67e5\u770b\u6570\u636e\u5e93\u8868\u7a7a\u95f4\u5269\u4f59\u91cf<br \/>\n<coolcode lang=\"sql\"><br \/>\nset linesize 1000<br \/>\nset pagesize 100<br \/>\nselect t.*<br \/>\n  from (SELECT D.TABLESPACE_NAME,<br \/>\n               SPACE \"SUM_SPACE(M)\",<br \/>\n               BLOCKS SUM_BLOCKS,<br \/>\n               SPACE - NVL(FREE_SPACE, 0) \"USED_SPACE(M)\",<br \/>\n               ROUND((1 - NVL(FREE_SPACE, 0) \/ SPACE) * 100, 2) \"USED_RATE(%)\",<br \/>\n               FREE_SPACE \"FREE_SPACE(M)\"<br \/>\n          FROM (SELECT TABLESPACE_NAME,<br \/>\n                       ROUND(SUM(BYTES) \/ (1024 * 1024), 2) SPACE,<br \/>\n                       SUM(BLOCKS) BLOCKS<br \/>\n                  FROM DBA_DATA_FILES<br \/>\n                 GROUP BY TABLESPACE_NAME) D,<br \/>\n               (SELECT TABLESPACE_NAME,<br \/>\n                       ROUND(SUM(BYTES) \/ (1024 * 1024), 2) FREE_SPACE<br \/>\n                  FROM DBA_FREE_SPACE<br \/>\n                 GROUP BY TABLESPACE_NAME) F<br \/>\n         WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)<br \/>\n        UNION ALL<br \/>\n        SELECT D.TABLESPACE_NAME,<br \/>\n               SPACE \"SUM_SPACE(M)\",<br \/>\n               BLOCKS SUM_BLOCKS,<br \/>\n               USED_SPACE \"USED_SPACE(M)\",<br \/>\n               ROUND(NVL(USED_SPACE, 0) \/ SPACE * 100, 2) \"USED_RATE(%)\",<br \/>\n               SPACE - USED_SPACE \"FREE_SPACE(M)\"<br \/>\n          FROM (SELECT TABLESPACE_NAME,<br \/>\n                       ROUND(SUM(BYTES) \/ (1024 * 1024), 2) SPACE,<br \/>\n                       SUM(BLOCKS) BLOCKS<br \/>\n                  FROM DBA_TEMP_FILES<br \/>\n                 GROUP BY TABLESPACE_NAME) D,<br \/>\n               (SELECT TABLESPACE,<br \/>\n                       ROUND(SUM(BLOCKS * 8192) \/ (1024 * 1024), 2) USED_SPACE<br \/>\n                  FROM V$SORT_USAGE<br \/>\n                 GROUP BY TABLESPACE) F<br \/>\n         WHERE D.TABLESPACE_NAME = F.TABLESPACE(+)) t  order by \"USED_RATE(%)\" desc;<br \/>\n<\/coolcode><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b\u6570\u636e\u5e93\u8868\u7a7a\u95f4\u5269\u4f59\u91cf set linesize 1000 set pagesize 100 select t [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/53"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=53"}],"version-history":[{"count":9,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions"}],"predecessor-version":[{"id":365,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions\/365"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}