{"id":3911,"date":"2018-06-15T10:24:03","date_gmt":"2018-06-15T01:24:03","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3911"},"modified":"2018-06-15T10:24:03","modified_gmt":"2018-06-15T01:24:03","slug":"book-script-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%8a%a4%ed%8e%98%ec%9d%b4%ec%8a%a4-%eb%aa%a8%eb%8b%88%ed%84%b0%eb%a7%81-%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3911","title":{"rendered":"[Book Script]  \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \ud558\uae30"},"content":{"rendered":"\n<pre class=\"lang:plsql decode:true \" >SELECT T.NAME , T.BYTES,T.USED,T.FREE,T.PCT_FREE_USED, C.BLOCK_SIZE\/1024||'k' BLOCK_SIZE,\r\n       C.CONTENTS, C.LOGGING,\r\n       C.EXTENT_MANAGEMENT,\r\n       C.ALLOCATION_TYPE,\r\n       C.SEGMENT_SPACE_MANAGEMENT,\r\n       C.DEF_TAB_COMPRESSION\r\nFROM\r\n( SELECT\r\n           A.TABLESPACE_NAME                                              NAME,\r\n           SUM(B.BYTES\/1048576)\/COUNT( DISTINCT A.FILE_ID||'.'||A.BLOCK_ID )      BYTES,\r\n           SUM(B.BYTES\/1048576)\/COUNT( DISTINCT A.FILE_ID||'.'||A.BLOCK_ID ) -\r\n           SUM(A.BYTES\/1048576)\/COUNT( DISTINCT B.FILE_ID )                       USED,\r\n           SUM(A.BYTES\/1048576)\/COUNT( DISTINCT B.FILE_ID )                       FREE,\r\n           100-(100 * ( (SUM(B.BYTES)\/COUNT( DISTINCT A.FILE_ID||'.'||A.BLOCK_ID )) -\r\n                           (SUM(A.BYTES)\/COUNT( DISTINCT B.FILE_ID ) )) \/\r\n           (SUM(B.BYTES)\/COUNT( DISTINCT A.FILE_ID||'.'||A.BLOCK_ID ))) PCT_FREE_USED\r\nFROM       DBA_FREE_SPACE A, DBA_DATA_FILES B\r\nWHERE      A.TABLESPACE_NAME = B.TABLESPACE_NAME\r\nGROUP BY   A.TABLESPACE_NAME ) T , DBA_TABLESPACES C\r\nWHERE T.NAME=C.TABLESPACE_NAME\r\nORDER BY T.PCT_FREE_USED ;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SELECT T.NAME , T.BYTES,T.USED,T.FREE,T.PCT_FREE_USED, C.BLOCK_SIZE\/1024||&#8217;k&#8217; BLOCK_SIZE, C.CONTENTS, C.LOGGING, C.EXTENT_MANAGEMENT, C.ALLOCATION_TYPE, C.SEGMENT_SPACE_MANAGEMENT, C.DEF_TAB_COMPRESSION FROM ( SELECT A.TABLESPACE_NAME NAME, SUM(B.BYTES\/1048576)\/COUNT( DISTINCT A.FILE_ID||&#8217;.&#8217;||A.BLOCK_ID ) BYTES, SUM(B.BYTES\/1048576)\/COUNT( DISTINCT A.FILE_ID||&#8217;.&#8217;||A.BLOCK_ID ) &#8211; SUM(A.BYTES\/1048576)\/COUNT( DISTINCT B.FILE_ID ) USED, SUM(A.BYTES\/1048576)\/COUNT( DISTINCT B.FILE_ID ) FREE, 100-(100 * ( (SUM(B.BYTES)\/COUNT( DISTINCT A.FILE_ID||&#8217;.&#8217;||A.BLOCK_ID )) &#8211; (SUM(A.BYTES)\/COUNT( DISTINCT B.FILE_ID ) )) \/ (SUM(B.BYTES)\/COUNT( DISTINCT A.FILE_ID||&#8217;.&#8217;||A.BLOCK_ID ))) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2878,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[1094],"tags":[1095],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/tip.jpg?fit=325%2C315","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3911"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3911"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3911\/revisions"}],"predecessor-version":[{"id":3912,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3911\/revisions\/3912"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2878"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3911"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}