{"id":54,"date":"2020-07-07T16:27:39","date_gmt":"2020-07-07T07:27:39","guid":{"rendered":"http:\/\/www.shamonabe.com\/?p=54"},"modified":"2020-07-07T16:27:40","modified_gmt":"2020-07-07T07:27:40","slug":"post-54","status":"publish","type":"post","link":"http:\/\/www.shamonabe.com\/?p=54","title":{"rendered":"\u8868\u9818\u57df\u306e\u4f7f\u7528\u7387\u306a\u3069\u3092\u7b97\u51fa"},"content":{"rendered":"<p>\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c<\/p>\n<p><code>select a.tablespace_name,<br \/>\nkbytes_alloc \"Allocated MB\",<br \/>\ntrunc(kbytes_alloc-nvl(kbytes_free,0),2) \"Used MB\",<br \/>\ntrunc(nvl(kbytes_free,0),2) \"Free MB\",<br \/>\n( trunc((kbytes_alloc-nvl(kbytes_free,0))\/kbytes_alloc, 2) ) \"Used\",<br \/>\ndata_files \"Data Files\"<br \/>\nfrom ( select sum(bytes)\/1024\/1024 Kbytes_free,<br \/>\nmax(bytes)\/1024\/1024 largest,<br \/>\ntablespace_name<br \/>\nfrom sys.dba_free_space<br \/>\ngroup by tablespace_name ) a join<br \/>\n( select sum(bytes)\/1024\/1024 Kbytes_alloc,<br \/>\ntablespace_name,<br \/>\ncount(*) data_files<br \/>\nfrom sys.dba_data_files<br \/>\ngroup by tablespace_name )b<br \/>\non a.tablespace_name = b.tablespace_name<br \/>\norder by 1;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c select a.tablespace_name, kbytes_alloc &#8220;Allocated <\/p>\n<p><a class=\"more-link\" href=\"http:\/\/www.shamonabe.com\/?p=54\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/54"}],"collection":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54"}],"version-history":[{"count":1,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":55,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions\/55"}],"wp:attachment":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}