{"id":2651,"date":"2018-02-02T18:48:58","date_gmt":"2018-02-02T09:48:58","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2651"},"modified":"2018-02-02T18:57:35","modified_gmt":"2018-02-02T09:57:35","slug":"segment-shrink-%ea%b8%b0%eb%8a%a5-oracle-10g","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2651","title":{"rendered":"SEGMENT SHRINK \uae30\ub2a5 (Oracle 10g ~ )"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Oracle10g \ubd80\ud130 \uc138\uadf8\uba3c\ud2b8\ub97c shrink \uc2dc\ud0ac \uc635\uc158\uc774 \uc874\uc7ac\ud558\uba70, \uc774 \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uba74 DBA\uac00\uac00 \uacf5\uac04\uc744 \uc880\ub354 \ud6a8\uc728\uc801\uc73c\ub85c \ud65c\uc6a9\ud560 \uc218
\n\uc788\ub2e4 \uc774 \uae30\ub2a5\uc740, \ub610\ud55c \uc9c8\uc758 \ucc98\ub9ac \uc18d\ub3c4 \uac1c\uc120\uc5d0\ub3c4 \ub3c4\uc6c0\uc774 \ub41c\ub2e4.<\/p>\n

Explanation
\n———–
\n1. \uc900\ube44 \uc0ac\ud56d<\/p>\n

Init.ora \ud30c\ub77c\ubbf8\ud130\uc778 ‘Compatible’ \uac12\uc774 10.0 \uc774\uc0c1\uc774\uc5b4\uc57c \ud568.
\n\uc138\uadf8\uba38\ud2b8\ub294, AUTO Segment Space Managed Tablespace\uc5d0 \uc874\uc7ac\ud574\uc57c \ud568.<\/p>\n

2. \ub3d9\uc791 \ubc29\ubc95<\/p>\n

1) \ud14c\uc774\ube14\uc758 row movement \uae30\ub2a5\uc744 \ud65c\uc131\ud654 \uc2dc\ud0a8\ub2e4.
\nSQL> ALTER TABLE scott.emp ENABLE ROW MOVEMENT;<\/p>\n

2) \ud14c\uc774\ube14\uc744 shrink \uc2dc\ud0a4\uc9c0\ub9cc, HWM (High Water Mark)\uc744 shrink \uc2dc\ud0a4\uc9c0 \uc54a\ub294\ub2e4.
\nSQL> ALTER TABLE scott.emp SHRINK SPACE COMPACT;<\/p>\n

3) \ud14c\uc774\ube14\uacfc HWM\uc744 shrink \uc2dc\ud0a8\ub2e4.
\nSQL> ALTER TABLE scott.emp SHRINK SPACE;<\/p>\n

4) \ud14c\uc774\ube14 \ubc0f \uad00\ub828\ub41c \uc778\ub371\uc2a4\ub97c \ubaa8\ub450 shrink\uc2dc\ud0a8\ub2e4.
\nSQL> ALTER TABLE scott.emp SHRINK SPACE CASCADE;<\/p>\n

5) MView \ud615\ud0dc\uc758 \ud14c\uc774\ube14\uc744 shrink\uc2dc\ud0a8\ub2e4.
\nSQL> ALTER TABLE <table name> SHRINK SPACE;<\/p>\n

6) \uc778\ub371\uc2a4\ub9cc shrink \uc2dc\ud0a8\ub2e4.
\nSQL> ALTER INDEX <index nam> SHRINK SPACE;<\/p>\n

3. \uc801\uc6a9 \ub300\uc0c1<\/p>\n

1) Normal Table
\n2) Index
\n3) Lob
\n4) IOT
\n5) MView<\/p>\n

4. Query\/DML Concurrency<\/p>\n

Segment shrink\ub97c \ud560 \ub54c\uc758 online \ucc98\ub9ac\ub294, DML-\ud638\ud658 \ub77d\uc744 \uc0ac\uc6a9\ud55c\ub2e4. \ub530\ub77c\uc11c DML\uc740
\nshrink\ub97c \ucc98\ub9ac \ud558\ub294\ub3d9\uc548\uc5d0\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. space-release\/HWM \uc870\uc815\uc744 \ud558\ub294 \ub2e8\uacc4\uc5d0\uc11c\ub294,
\n\ud14c\uc774\ube14\uc5d0 \ub300\ud574 DML\uace0 \ud638\ud658\ub418\uc9c0 \uc54a\ub294 \ub77d\uc744 \uc0ac\uc6a9\ud55c\ub2e4 \ub530\ub77c\uc11c, DML\uc740 shink\uac00 \ub05d\ub0a0 \ub54c \uae4c\uc9c0
\n\uc7a0\uc2dc \uc911\ub2e8\ub418\ub098.<\/p>\n

shrink\ub97c \uc2e4\ud589\ud568\uc73c\ub85c\uc368 \ubc1c\uc0dd\ud558\ub294 DML \ucc98\ub9ac \uad00\ub828 \uc5d0\ub7ec\ub294 \uc5c6\ub2e4.<\/p>\n

\ucffc\ub9ac\ub294 \uc138\uadf8\uba3c\ud2b8\uc758 HWM\uc5d0 \ub300\ud55c \uce90\uc26c\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \uc624\ub77c\ud074\uc740, HWM\uc774 \uc5b8\uc81c\ub098 \ucee4\uc9c8 \uac83\uc73c\ub85c \uac04\uc8fc\ud55c\ub2e4. \ub530\ub77c\uc11c
\nCR\uc740 \uc138\uadf8\uba3c\ud2b8 \ud5e4\ub354 \ubc0f \uc775\uc2a4\ud150\ud2b8 \ub9f5 \ube14\ub7ed\uc5d0 \ub300\ud574\uc11c\ub294 \ud544\uc694\ud558\uc9c0 \uc54a\ub2e4. \uc138\uadf8\uba3c\ud2b8 HWM\uc774 \uc791\uc544\uc9c0\ub294 \uc720\uc77c\ud55c
\n\uacbd\uc6b0\ub294, drop \ub610\ub294 truncate \uc791\uc5c5 \ubfd0\uc774\ub2e4.<\/p>\n

\uc624\ub77c\ud074\uc740, drop\/truncate DDL\uc640 \uc9c8\uc758\ucc98\ub9ac\uac00 \ub3d9\uc2dc\uc5d0 \uc874\uc7ac\ud560 \uc218\uc788\uac8c \ud5c8\uc6a9\ud558\ub294\ub370, \uc774\uac83\uc740 \uc9c8\uc758 \ucc98\ub9ac\uac00
\n\ub77d\uc744 \ud544\uc694\ub85c \ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc774\ub2e4. \ub9cc\uc57d drop\/truncate \uc791\uc5c5\uc774 \ub05d\ub09c \ud6c4\ub77c\uba74, \ud574\ub2f9 \uacf5\uac04\uc740 \ub2e4\ub978 \uc138\uadf8\uba3c\ud2b8\uc5d0
\n\uc758\ud574 \uc0ac\uc6a9\ub418\uba70, \uc9c8\uc758\ub294 “8103 – object does not exist”\ub77c\ub294 \uc5d0\ub7ec \uba54\uc2dc\uc9c0\uc640 \ud568\uaed8 \uc2e4\ud328\ud558\uac8c \ub41c\ub2e4.<\/p>\n

\uc138\uadf8\uba3c\ud2b8\ub97c shrink\ud558\ub294 \ub3d9\uc548, \uc138\uadf8\uba3c\ud2b8\uc758 HWM\uac00 \ubcc0\uacbd\ub41c\ub2e4\uba74, \ud574\ub2f9 \uc138\uadf8\uba3c\ud2b8\uc640 \uad00\ub828\ub41c \ube44\ud2b8\ub9f5 \ube14\ub7ed\uacfc
\n\uc138\uadf8\uba3c\ud2b8 \ud5e4\ub354\uc758 incarnation number\uac00 \ubcc0\uacbd\ub41c\ub2e4. \ud6c4\uc18d \ub370\uc774\ud130 \ube14\ub7ed \uad00\ub828 \uc791\uc5c5\uc740 \uc0c8\ub85c \ubd80\uc5ec\ub41c
\nincarnation number\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n

\ub9cc\uc57d \uc774 \ub2e8\uacc4\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \uc9c8\uc758\uac00 \uc788\uc5c8\ub2e4\uba74, “10632 – invalid rowid” \uc5d0\ub7ec\uc640 \ud568\uaed8 \uc2e4\ud328\ud558\ub294\ub370
\n\ub2e4\uc74c\uacfc \uac19\uc740 \uc870\uac74\uc774 \ub9cc\uc871 \ub418\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

1) \uac31\uc2e0\ub41c \ube44\ud2b8\ub9f5 \ube14\ub7ed\uc744 \uc77d\ub294\ub2e4 (\uc0c8\ub85c\uc6b4 inc#). \uc774 \uacbd\uc6b0 failure\ub294, \ud574\ub2f9 \uacf5\uac04\uc774 \uc7ac \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74
\n\ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4.<\/p>\n

2) \uacf5\uac04\uc774 \ub3d9\uc77c\ud55c \uac1d\uccb4 \ub610\ub294 \ub2e4\ub978 \uac1d\uccb4\uc5d0 \uc758\ud574 \uc7ac \ud65c\uc6a9 \ub418\uc5c8\ub2e4.<\/p>\n

5. Online Segment Shrink\uc640 \uad00\ub828\ub41c \uc81c\uc57d\uc0ac\ud56d<\/p>\n

ASSM\uc758 \uc138\uadf8\uba3c\ud2b8\ub294 shrink \uac00\ub2a5\ud558\ub2e4. \uadf8\ub7ec\ub098, ASSM \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \uc704\uce58\ud558\ub294 \uac1d\uccb4
\n\uac00\uc6b4\ub370 \ub2e4\uc74c\uacfc \uac19\uc740 \uac1d\uccb4\uc5d0\ub294 \uc81c\uc57d\uc0ac\ud56d\uc774 \ub530\ub978\ub2e4 :<\/p>\n

1) \ud074\ub7ec\uc2a4\ud130\uc5d0 \uc18d\ud558\ub294 \ud14c\uc774\ube14
\n2) long \uceec\ub7fc\uc744 \ud3ec\ud568\ud55c \ud14c\uc774\ube14
\n3) on-commit materialized view\uc640 \uc5f0\uad00\ub41c \ud14c\uc774\ube14
\n4) rowid based materialized view\uc640 \uc5f0\uad00\ub41c \ud14c\uc774\ube14
\n5) Lob index<\/p>\n

6. Shrink \uc218\ud589\uc2dc \uc758\uc874 \uad00\uacc4 \uad00\ub9ac\uc640 \uc81c\uc57d\uc0ac\ud56d<\/p>\n

\uc138\uadf8\uba3c\ud2b8\ub97c shrink \ud558\ub294\ub3d9\uc548, \uace0\ub824\ub418\ub294 \uc720\uc77c\ud55c \uc758\uc874 \uad00\uacc4\ub294, \ud14c\uc774\ube14 – \uc778\ub371\uc2a4\uac04 \uad00\uacc4\uc774\ub2e4.
\n\uc778\ub371\uc2a4\ub294, shrink \ud6c4\uc5d0\ub3c4 unusable \uc0c1\ud0dc\ub85c \ub0a8\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

\uc138\uadf8\uba3c\ud2b8 shink\ub97c \uacfc\uc815\uc5d0\uc11c \uc555\ucd95 (compaction)\ub2e8\uacc4\ub294 insert\/delete \uc791\uc5c5\uc744 \uc30d\uc73c\ub85c \ucc98\ub9ac\ud558\uc5ec
\n\uc774\ub8e8\uc5b4\uc9c4\ub2e4. DML trigger\ub294 \ub370\uc774\ud130\ub97c \uc774\ub3d9\ud558\ub294 \ub2e8\uacc4\uc5d0\uc11c\ub294 \ud638\ucd9c\ub418\uc9c0 \uc54a\ub294\ub2e4. \ub370\uc774\ud130\uc758 \ub0b4\uc6a9\uc774
\n\ubcc0\uacbd\ub418\ub294 \uac83\uc774 \uc544\ub2c8\ubbc0\ub85c, trigger\uac00 \ud638\ucd9c \ub420 \ud544\uc694\uac00 \uc5c6\ub2e4.<\/p>\n

ROWID\uc5d0 \uae30\ubc18\uc744 \ub454 trigger\ub294, shrink\ub97c \ud558\uae30 \uc804 disable \uc2dc\ucf1c\uc57c \ud558\ub294\ub370 \uc774\uac83\uc740 shink \ud558\ub294\ub3d9\uc548
\n\ud2b8\ub9ac\uac70\uac00 \ud638\ucd9c \ub418\uc9c0 \uc54a\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c\uc774\ub2e4.<\/p>\n

on-commit materialized view\uc640 \uc5f0\uad00\ub41c \uc138\uadf8\uba3c\ud2b8\ub294 shrink \uc2dc\ud0ac \uc218 \uc5c6\ub2e4.
\nPrimary key\ub97c \uae30\ubc18\uc73c\ub85c \ud55c materialized view\ub294, shrink\ub97c \uc2dc\ud0a8 \uc774\ud6c4\uc5d0 refresh \ub610\ub294 rebuild
\n\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4.<\/p>\n

\ud558\uc9c0\ub9cc, rowid\uc5d0 \uae30\ubc18\uc744 \ub454 materialized view\uc5d0 \ub300\ud574\uc11c\ub294 refresh \ub610\ub294 rebuild\ub97c \uc218\ud589\ud574 \uc8fc\uc5b4\uc57c
\n\ud55c\ub2e4.<\/p>\n

7. \uac00\uc6a9\uc131<\/p>\n

\uc138\uadf8\uba3c\ud2b8 shrink\ub294, \uc628\ub77c\uc778\uc911\uc5d0 \uc218\ud589\ub420 \uc218 \uc788\ub2e4. \ub530\ub77c\uc11c, \uac1d\uccb4\uc5d0 \ub300\ud55c \uac00\uc6a9\uc131\uc774 \ud5a5\uc0c1 \ub418\uc5c8\ub2e4.
\nDML \uc791\uc5c5\uc740 \uc138\uadf8\uba3c\ud2b8 shrink \uc911\uc5d0\ub3c4 \uc218\ud589 \uac00\ub2a5\ud558\ub098, parallel DML\uc744 \uc218\ud589\ub420 \uc218 \uc5c6\ub2e4.<\/p>\n

\uc138\uadf8\uba3c\ud2b8\ub97c shrink \uc2dc\ud0a4\ub294\ub3d9\uc548 \ub370\uc774\ud130\ub294 \uc555\ucd95(compaction) \ub2e8\uacc4\uc5d0\uc11c \uc774\ub3d9\uc774\ub41c\ub2e4. \uc555\ucd95 \ub2e8\uacc4\uac00 \uc9c4\ud589\ub418\ub294
\n\ub3d9\uc548 \uac1c\ubcc4 row \ub610\ub294 \ub370\uc774\ud130 \ube14\ub7ed\uc5d0 \ub300\ud55c lock\uc774 \uc0ac\uc6a9\ub41c\ub2e4.
\n\uc774 \uc0c1\ud669\uc740, lock\uc744 \uc774\uc6a9\ud574, update\ub098 delete\uc640 \uac19\uc740 concurrent DML\uc774 \uc218\ud589\ub418\ub294 \uc0c1\ud669\uacfc \uc720\uc0ac\ud558\ub2e4.
\n\uc555\ucd95\uc740, \uc791\uc740 \ud2b8\ub79c\uc7ad\uc158 \ub2e4\ub258\ub85c \uc218\ud589\ub418\ubbc0\ub85c, \uac1d\uccb4\uc5d0 \ub300\ud55c \uac00\uc6a9\uc131\uc740 \uc2ec\uac01\ud558\uac8c \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

\ud558\uc9c0\ub9cc, \uc138\uadf8\uba3c\ud2b8\ub97c shrink \uc2dc\ud0a4\ub294 \ud2b9\uc815 \ub2e8\uacc4\uc5d0\uc11c\ub294 (HWM\uc744 \uc870\uc815\ud558\ub294 \ub2e8\uacc4), \uc138\uadf8\uba3c\ud2b8\ub294, exclusive \ubaa8\ub4dc\ub85c
\nlock\uc774 \uac78\ub9b0\ub2e4.
\n\uc774 \ub2e8\uacc4\ub294 \ub9e4\uc6b0 \uc9e7\uc740 \uae30\uac04\uc774\uba70, \uac1d\uccb4\uc5d0 \ub300\ud55c \uac00\uc6a9\uc131\uc5d0 \ubbf8\uce58\ub294 \uc601\ud5a5\uc774 \ucd5c\uc18c\ud638 \ub41c\ub2e4.<\/p>\n

8. \ubcf4\uc548<\/p>\n

\uc138\uadf8\uba3c\ud2b8 shrink\ub97c \uc218\ud589\ud558\uae30 \uc704\ud574\uc11c\ub294 \uac1d\uccb4\uc5d0 \ub300\ud574\uc11c ALTER \uc2dc\ud0a4\ub294 \uad8c\ud55c\uacfc \ub3d9\ub4f1\ud55c \uad8c\ud55c\uc774 \ud544\uc694\ud558\ub2e4.<\/p>\n

9. \uc0c1\uc138 \uc608\uc81c<\/p>\n

SQL> set serveroutput on
\nSQL> declare
\n2 v_unformatted_blocks number;
\n3 v_unformatted_bytes number;
\n4 v_fs1_blocks number;
\n5 v_fs1_bytes number;
\n6 v_fs2_blocks number;
\n7 v_fs2_bytes number;
\n8 v_fs3_blocks number;
\n9 v_fs3_bytes number;
\n10 v_fs4_blocks number;
\n11 v_fs4_bytes number;
\n12 v_full_blocks number;
\n13 v_full_bytes number;
\n14 begin
\n15 dbms_space.space_usage (‘SYSTEM’, ‘T_SHRINK’, ‘TABLE’, v_unformatted_blocks,
\n16 v_unformatted_bytes, v_fs1_blocks, v_fs1_bytes, v_fs2_blocks, v_fs2_bytes,
\n17 v_fs3_blocks, v_fs3_bytes, v_fs4_blocks, v_fs4_bytes, v_full_blocks, v_full_bytes);
\n18 dbms_output.put_line(‘Unformatted Blocks = ‘||v_unformatted_blocks);
\n19 dbms_output.put_line(‘FS1 Blocks = ‘||v_fs1_blocks);
\n20 dbms_output.put_line(‘FS2 Blocks = ‘||v_fs2_blocks);
\n21 dbms_output.put_line(‘FS3 Blocks = ‘||v_fs3_blocks);
\n22 dbms_output.put_line(‘FS4 Blocks = ‘||v_fs4_blocks);
\n23 dbms_output.put_line(‘Full Blocks = ‘||v_full_blocks);
\n24 end;
\n25 \/
\nUnformatted Blocks = 0
\nFS1 Blocks = 0
\nFS2 Blocks = 1
\nFS3 Blocks = 1
\nFS4 Blocks = 3
\nFull Blocks = 0<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

SQL> alter table t_shrink shrink space compact;
\nalter table t_shrink shrink space compact
\n*
\nERROR at line 1:
\nORA-10636: ROW MOVEMENT is not enabled<\/p>\n

SQL> ALTER TABLE t_shrink ENABLE ROW MOVEMENT;
\nTable altered.<\/p>\n

SQL> ALTER TABLE t_shrink SHRINK SPACE COMPACT;
\nTable altered.<\/p>\n

SQL> set serveroutput on
\nSQL> declare
\n2 v_unformatted_blocks number;
\n3 v_unformatted_bytes number;
\n4 v_fs1_blocks number;
\n5 v_fs1_bytes number;
\n6 v_fs2_blocks number;
\n7 v_fs2_bytes number;
\n8 v_fs3_blocks number;
\n9 v_fs3_bytes number;
\n10 v_fs4_blocks number;
\n11 v_fs4_bytes number;
\n12 v_full_blocks number;
\n13 v_full_bytes number;
\n14 begin
\n15 dbms_space.space_usage (‘SYSTEM’, ‘T_SHRINK’, ‘TABLE’, v_unformatted_blocks,
\n16 v_unformatted_bytes, v_fs1_blocks, v_fs1_bytes, v_fs2_blocks, v_fs2_bytes,
\n17 v_fs3_blocks, v_fs3_bytes, v_fs4_blocks, v_fs4_bytes, v_full_blocks, v_full_bytes);
\n18 dbms_output.put_line(‘Unformatted Blocks = ‘||v_unformatted_blocks);
\n19 dbms_output.put_line(‘FS1 Blocks = ‘||v_fs1_blocks);
\n20 dbms_output.put_line(‘FS2 Blocks = ‘||v_fs2_blocks);
\n21 dbms_output.put_line(‘FS3 Blocks = ‘||v_fs3_blocks);
\n22 dbms_output.put_line(‘FS4 Blocks = ‘||v_fs4_blocks);
\n23 dbms_output.put_line(‘Full Blocks = ‘||v_full_blocks);
\n24 end;
\n25 \/
\nUnformatted Blocks = 0
\nFS1 Blocks = 0
\nFS2 Blocks = 0
\nFS3 Blocks = 0
\nFS4 Blocks = 2
\nFull Blocks = 1<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

SQL> ALTER TABLE t_shrink SHRINK SPACE;
\nTable altered.<\/p>\n

SQL> declare
\n2 v_unformatted_blocks number;
\n3 v_unformatted_bytes number;
\n4 v_fs1_blocks number;
\n5 v_fs1_bytes number;
\n6 v_fs2_blocks number;
\n7 v_fs2_bytes number;
\n8 v_fs3_blocks number;
\n9 v_fs3_bytes number;
\n10 v_fs4_blocks number;
\n11 v_fs4_bytes number;
\nv_full_blocks number;
\n13 v_full_bytes number;
\n14 begin
\n15 dbms_space.space_usage (‘SYSTEM’, ‘T_SHRINK’, ‘TABLE’, v_unformatted_blocks,
\n16 v_unformatted_bytes, v_fs1_blocks, v_fs1_bytes, v_fs2_blocks, v_fs2_bytes,
\n17 v_fs3_blocks, v_fs3_bytes, v_fs4_blocks, v_fs4_bytes, v_full_blocks, v_full_bytes);
\n18 dbms_output.put_line(‘Unformatted Blocks = ‘||v_unformatted_blocks);
\n19 dbms_output.put_line(‘FS1 Blocks = ‘||v_fs1_blocks);
\n20 dbms_output.put_line(‘FS2 Blocks = ‘||v_fs2_blocks);
\n21 dbms_output.put_line(‘FS3 Blocks = ‘||v_fs3_blocks);
\n22 dbms_output.put_line(‘FS4 Blocks = ‘||v_fs4_blocks);
\n23 dbms_output.put_line(‘Full Blocks = ‘||v_full_blocks);
\n24 end;
\n25 \/
\nUnformatted Blocks = 0
\nFS1 Blocks = 0
\nFS2 Blocks = 0
\nFS3 Blocks = 0
\nFS4 Blocks = 1
\nFull Blocks = 1<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

Example
\n——-<\/p>\n

Reference Documents
\n——————-
\n<Note:242090.1<\/a>><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Oracle10g \ubd80\ud130 \uc138\uadf8\uba3c\ud2b8\ub97c shrink \uc2dc\ud0ac \uc635\uc158\uc774 \uc874\uc7ac\ud558\uba70, \uc774 \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uba74 DBA\uac00\uac00 \uacf5\uac04\uc744 \uc880\ub354 \ud6a8\uc728\uc801\uc73c\ub85c \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4 \uc774 \uae30\ub2a5\uc740, \ub610\ud55c \uc9c8\uc758 \ucc98\ub9ac \uc18d\ub3c4 \uac1c\uc120\uc5d0\ub3c4 \ub3c4\uc6c0\uc774 \ub41c\ub2e4. Explanation ———– 1. \uc900\ube44 \uc0ac\ud56d Init.ora \ud30c\ub77c\ubbf8\ud130\uc778 ‘Compatible’ \uac12\uc774 10.0 \uc774\uc0c1\uc774\uc5b4\uc57c \ud568. \uc138\uadf8\uba38\ud2b8\ub294, AUTO Segment Space Managed Tablespace\uc5d0 \uc874\uc7ac\ud574\uc57c \ud568. 2. \ub3d9\uc791 \ubc29\ubc95 1) \ud14c\uc774\ube14\uc758 row movement \uae30\ub2a5\uc744 \ud65c\uc131\ud654 […]<\/p>\n","protected":false},"author":1,"featured_media":2657,"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":[11],"tags":[857,429,858],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Auslogics-Disk-Defrag.png?fit=300%2C300","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2651"}],"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=2651"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2651\/revisions"}],"predecessor-version":[{"id":2658,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2651\/revisions\/2658"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2657"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2651"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}