{"id":731,"date":"2015-11-30T16:11:49","date_gmt":"2015-11-30T16:11:49","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=731"},"modified":"2015-11-30T16:11:49","modified_gmt":"2015-11-30T16:11:49","slug":"datafile-resize","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=731","title":{"rendered":"Datafile Resize"},"content":{"rendered":"<p><UL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud604\uc7ac \uc0ac\uc6a9\ub960 \uc870\ud68c <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">select df.tablespace_name &#8220;Tablespace&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">round(df.TBS_byte \/1048576,2) &#8220;Total(MB)&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">round((df.TBS_byte &#8211; fs.Free_byte)\/1048576,2) &#8220;Used(MB)&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">round(fs.Free_byte \/1048576,2) &#8220;Free(MB)&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">round((fs.Free_byte\/df.TBS_byte) *100,0) &#8220;Free(%)&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">fs.pieces &#8220;Pieces&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">round(fs.Max_free \/1048576,2) &#8220;MaxFree(MB)&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">db.EXTENT_MANAGEMENT <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">from ( select tablespace_name, sum(bytes) TBS_byte <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">from dba_data_files group by tablespace_name ) df, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">( select tablespace_name, max(bytes) Max_free, sum(bytes) Free_byte, count(*) pieces <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">from dba_free_space group by tablespace_name ) fs, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">( select tablespace_name, initial_extent, next_extent,EXTENT_MANAGEMENT <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">from dba_tablespaces ) db <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">where df.tablespace_name = db.tablespace_name <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">and df.tablespace_name = fs.tablespace_name(+) <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">order by 5 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/ <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.2156004A565C753310B53D.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud604\uc7ac \ub370\uc774\ud130\ud30c\uc77c \uc815\ubcf4 \uc870\ud68c(\uc81c \uacbd\uc6b0 TEST1 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uac00 test01.dbf ~ test04.dbf\ub85c \uc774\ub8e8\uc5b4\uc838 \uc788\uc2b5\ub2c8\ub2e4) <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">set lines 300 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">set pages 1000 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">col file_name for a50 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">col tablespace_name for a20 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">select FILE_ID, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">FILE_NAME, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">TABLESPACE_NAME, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">AUTOEXTENSIBLE, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">INCREMENT_BY, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">BYTES\/1024\/1024 &#8220;current(M)&#8221;, <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">MAXBYTES\/1024\/1024 &#8220;maxExtend(M)&#8221; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">from dba_data_files <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">order by 3,4 desc <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\/ <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.217BD83D565C7535293098.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \uac01 \ub370\uc774\ud130\ud30c\uc77c \ub9ac\uc0ac\uc774\uc988(\uc0ac\uc774\uc988 \uc99d\uac00) <\/SPAN><\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile9.uf.245EC445565C75362177C4.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile9.uf.2516013C565C75361AC364.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ub370\uc774\ud130\ud30c\uc77c \ubcc4 \ube14\ub85d \uc0ac\uc6a9\ub960 \uc870\ud68c <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">select block_id, blocks from dba_extents where file_id=&#8217;6&#8242; order by block_id; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">select block_id, blocks from dba_extents where file_id=&#8217;7&#8242; order by block_id; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">select block_id, blocks from dba_extents where file_id=&#8217;8&#8242; order by block_id; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">select block_id, blocks from dba_extents where file_id=&#8217;9&#8242; order by block_id; <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile26.uf.22660939565C753704EF37.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.273FB74B565C75381A981D.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile26.uf.215D0041565C75391AE7FA.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.23648044565C75392FF83B.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc0ac\uc6a9\ub960 \uacc4\uc0b0 <\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">show parameter block_size <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.242EF34B565C753B2C669A.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">4\ubc88\uc5d0\uc11c \uc870\ud68c \ub41c \uc0ac\ud56d\uc73c\ub85c \uacc4\uc0b0\uc744 \ud569\ub2c8\ub2e4 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">(\ub9c8\uc9c0\ub9c9 block_id * block_size) + (\ub9c8\uc9c0\ub9c9 block * block_size) <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">test01.dbf <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile8.uf.26455641565C753C314405.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">((896 * 8192) + (128 * 8192))\/1024\/1024 = 8 M <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">test02.dbf <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.257A5636565C753D134ECA.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">((640 * 8192) + (128 * 8192))\/1024\/1024 = 6 M <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">test03.dbf <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile27.uf.2311B237565C753E33C9CE.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">((768 * 8192) + (128 * 8192))\/1024\/1024 = 7 M <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">test04.dbf <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.222F4C38565C753F2B6545.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">((640 * 8192) + (128 * 8192))\/1024\/1024 = 6 M <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ub370\uc774\ud130\ud30c\uc77c \ub9ac\uc0ac\uc774\uc988 <\/SPAN><\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.25232E43565C754004946C.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile28.uf.262D304E565C75411990DF.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">alter database datafile &#8216;\/u01\/app\/oracle\/oradata\/SOON1004\/test01.dbf&#8217; resize 8M; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">alter database datafile &#8216;\/u01\/app\/oracle\/oradata\/SOON1004\/test02.dbf&#8217; resize 6M; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">alter database datafile &#8216;\/u01\/app\/oracle\/oradata\/SOON1004\/test03.dbf&#8217; resize 7M; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">alter database datafile &#8216;\/u01\/app\/oracle\/oradata\/SOON1004\/test04.dbf&#8217; resize 6M; <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.25687341565C754210857C.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud574\ub2f9 \uc0ac\uc6a9\ub960 \ubcf4\ub2e4 \ub0ae\uac8c \ub9ac\uc0ac\uc774\uc988 \uc2dc \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile6.uf.235EAE3E565C7543094873.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud655\uc778 <\/SPAN><\/DIV><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile8.uf.273F6A49565C75432AF5E4.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile28.uf.230D013D565C7545184109.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&nbsp; <\/SPAN>&nbsp;<\/P><\/LI><br \/>\n<LI><br \/>\n<P>\ube14\ub7ed \ub2e8\uc704\ub85c \uc0ac\uc6a9\ub960\uc744 \uc870\ud68c \ud574 resize \ud558\ub294 \ubc29\ubc95\uc774\uc9c0\ub9cc \uc2e4\uc81c \uc0ac\uc6a9\ud558\ub294 \uc0ac\uc774\uc988 \ubcf4\ub2e4 \uc904\uc9c0 \uc54a\uc74c.<\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud604\uc7ac \uc0ac\uc6a9\ub960 \uc870\ud68c select df.tablespace_name &#8220;Tablespace&#8221;, round(df.TBS_byte \/1048576,2) &#8220;Total(MB)&#8221;, round((df.TBS_byte &#8211; fs.Free_byte)\/1048576,2) &#8220;Used(MB)&#8221;, round(fs.Free_byte \/1048576,2) &#8220;Free(MB)&#8221;, round((fs.Free_byte\/df.TBS_byte) *100,0) &#8220;Free(%)&#8221;, fs.pieces &#8220;Pieces&#8221;, round(fs.Max_free \/1048576,2) &#8220;MaxFree(MB)&#8221;, db.EXTENT_MANAGEMENT from ( select tablespace_name, sum(bytes) TBS_byte from dba_data_files group by tablespace_name ) df, ( select tablespace_name, max(bytes) Max_free, sum(bytes) Free_byte, count(*) pieces from dba_free_space group by tablespace_name ) fs, ( [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":732,"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":[9],"tags":[65,428,429,430,431,432],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.273FB74B565C75381A981D.png?fit=640%2C439","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/731"}],"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=731"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/731\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/732"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=731"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}