{"id":3567,"date":"2018-02-05T09:46:09","date_gmt":"2018-02-05T00:46:09","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3567"},"modified":"2023-04-14T15:31:24","modified_gmt":"2023-04-14T06:31:24","slug":"oracle-%ec%9d%98-shrink-%ea%b8%b0%eb%8a%a5","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=3567","title":{"rendered":"Oracle \uc758 Shrink \uae30\ub2a5"},"content":{"rendered":"<p style=\"text-align: justify; margin-left: 56pt;\">\uc5b4\ub5a4 \uc138\uadf8\uba3c\ud2b8\ub97c \uc704\ud574 \uacf5\uac04\uc774 \ud06c\uac8c \ud560\ub2f9\ub41c \uacbd\uc6b0 High Water Mark \uc774\ud6c4\uc758 \uacf5\uac04\uc740 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc740 \ucc44\ub85c \ub0a8\uc544 \uc788\uac8c \ub420 \uc218 \uc788\ub2e4. \ub610\ud55c High Water Mark \uc774\uc804\uc758 \uc601\uc5ed\uc5d0\ub3c4 \ub204\uc801\ub41c delete \uc5f0\uc0b0\uc758 \uacb0\uacfc\ub85c \ube48 \uacf5\uac04\uc774 \uc874\uc7ac\ud560 \uc218 \uc788\ub2e4. \uc774 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc81c\uc810\uc774 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\ub2e4:<\/p>\n<ul style=\"margin-left: 96pt;\">\n<li>\n<div style=\"text-align: justify;\">\ub370\uc774\ud130\uac00 \ubcf4\ub2e4 \ub9ce\uc740 \ube14\ub85d\ub4e4\uc5d0 \uac78\uccd0 \ud769\uc5b4\uc838 \uc788\uc73c\ubbc0\ub85c \uc2a4\uce94\uc2dc \ubcf4\ub2e4 \ub9ce\uc740 I\/O\uac00 \ud544\uc694\ud558\ub2e4.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">\ub0b4\ubd80 \ub2e8\ud3b8\ud654\ub85c \uc778\ud574 row-chaining\/row migration\uc774 \uc77c\uc5b4\ub0a0 \uac00\ub2a5\uc131\uc774 \ub192\ub2e4.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">\uc804\uccb4\uc801\uc778 \uacf5\uac04 \ub0ad\ube44\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/div>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Oracle9i\uc5d0\uc11c \uc774\ub7ec\ud55c \ubb38\uc81c\uc810\ub4e4\uc744 \ud574\uacb0\ud558\ub294 \ubc29\uc548\uc740 \ud574\ub2f9 \uc624\ube0c\uc81d\ud2b8\ub97c \uc774\ub3d9\ud558\uac70\ub098 \uc7ac\uc0dd\uc131\ud558\ub294 \uac83\uc774\uc5c8\ub2e4. Oracle Database 10g\uc5d0\uc11c\ub294 \uc774 \ubb38\uc81c\ub97c \uc704\ud574 Segment Shrink \uae30\ub2a5\uc744 \ucd94\uac00\uc801\uc73c\ub85c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 56pt;\">\ud55c\ud3b8 Oracle Database 10g\uc758 Advisory framework\ub294 Segment\uc758 \uacf5\uac04 \uc0ac\uc6a9\uc5d0 \uad00\ud558\uc5ec \uac01\uc885 \ud1b5\uacc4 \ubcf4\uace0 \ubc0f Segment Shrink\ub97c \ud3ec\ud568\ud55c \uad8c\uace0\uc548 \uc81c\uc2dc\ub97c \uc704\ud574 Segment Advisor\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h3>Segment Shrink\uc758 \uc6d0\ub9ac<\/h3>\n<p style=\"text-align: justify; margin-left: 56pt;\">Segment Shrink\ub294 \ub2e4\uc74c\uc758 \ub450 \ub2e8\uacc4\uc5d0 \uac78\uccd0 \uc774\ub8e8\uc5b4\uc9c4\ub2e4.<\/p>\n<ul style=\"margin-left: 74pt;\">\n<li>\n<div style=\"text-align: justify;\">\ub370\uc774\ud130\uc758 compact<\/div>\n<p style=\"text-align: justify; margin-left: 9pt;\">\uc774 \ub2e8\uacc4\ub294 HWM \uc544\ub798 \uc601\uc5ed\uc5d0 \uc788\ub294 hole\ub4e4\uc744 \ucc44\uc6b0\ub294 \uc791\uc5c5\uc774\ub2e4. \uc774\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c INSERT\/DELETE \uc5f0\uc0b0\uc5d0 \uc758\ud574 \uc774\ub8e8\uc5b4\uc9c4\ub2e4: HWM\uc5d0 \uac00\uae4c\uc774 \uc788\ub294 \ud589\uc744 \uc548\ucabd\uc758 \ube48 \uacf5\uac04\uc744 \ucc3e\uc544 INSERT\ud558\uace0, \uadf8\uac83\uc774 \ub05d\ub098\uba74 \ud574\ub2f9 \ud589\uc744 DELETE\ud568\uc73c\ub85c\uc368 \ud589\uc744 \uc62e\uae30\ub294 \uac83\uc774\ub2e4.<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\">\ub2e4\ub9cc, \uc2e4\uc81c \ub370\uc774\ud130\uac00 \ubc14\ub00c\ub294 \uac83\uc740 \uc544\ub2c8\uae30 \ub54c\ubb38\uc5d0 DML \ud2b8\ub9ac\uac70\uac00 \uc815\uc758\ub418\uc5b4 \uc788\ub2e4 \ud558\ub354\ub77c\ub3c4 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">Segment Shrink\uac00 row-chaining\uc744 \uc644\uc804\ud788 \uc81c\uac70\ud558\ub294 \uac83\uc744 \ubcf4\uc7a5\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">\ubcf4\ud1b5\uc758 DML\uacfc \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\ubbc0\ub85c \uc778\ub371\uc2a4 dependency\ub294 \uc790\ub3d9\uc73c\ub85c \ucc98\ub9ac\ub41c\ub2e4. \ub2e4\ub9cc IOT\uc5d0 \ub300\ud55c 2\ucc28 \uc778\ub371\uc2a4\ub294 shrink \uc9c1\ud6c4 \uc7ac\uc0dd\uc131\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud55c\ub2e4.<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">HWM\uc758 push down<\/div>\n<p style=\"text-align: justify; margin-left: 9pt;\">1\ubc88 \ub2e8\uacc4\uc5d0 \uc758\ud574 \ub370\uc774\ud130\ub294 HWM\uc5d0\uc11c \uba3c \ucabd\uc5d0 \ucd18\ucd18\ud788 \ucc44\uc6cc\uc838 \uc788\uc744 \uac83\uc774\uace0, \ubc18\ub300\ub85c HWM\uc5d0\uc11c \uac00\uae4c\uc6b4 \ucabd\uc758 \uacf5\uac04\uc740 \ube44\uc5b4 \uc788\ub294 \uc0c1\ud0dc\uac00 \ub41c\ub2e4. \uc774\uc81c HWM\ub97c \ub0b4\ub9ac\uace0, \uc0c8\ub86d\uac8c \uc124\uc815\ub41c HWM \uc774\ud6c4\uc758 \ubaa8\ub4e0 \uacf5\uac04\uc744 \ud574\ub2f9 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ubc18\ub0a9\ud568\uc73c\ub85c\uc368 segment shrink\uac00 \uc644\ub8cc\ub41c\ub2e4.<\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Segment Shrink\ub294 online\uc774\uc790 in-place \uc5f0\uc0b0\uc774\ub2e4. 1\ubc88 \ub2e8\uacc4\uc5d0\uc11c\ub294 \ud1b5\uc0c1\uc758 row-level lock\uc774 \ud544\uc694\ud560 \ubfd0, \ub2e4\ub978 \uc138\uc158\uc758 DML\uc744 \ubd88\ud5c8\ud558\ub294 \uac83\uc740 \uc544\ub2c8\uae30 \ub54c\ubb38\uc5d0 \uc624\ube0c\uc81d\ud2b8\uc758 \uac00\uc6a9\uc131\uc740 \uc81c\ud55c\ub418\uc9c0 \uc54a\ub294\ub2e4. \ub610\ud55c 2\ubc88 \ub2e8\uacc4\uc5d0\uc11c HWM\ub97c \ub0b4\ub9ac\ub294 \ub370 \ud544\uc694\ud55c exclusive \ud14c\uc774\ube14 lock\uc740 \ub9e4\uc6b0 \uc9e7\uc740 \uc2dc\uac04 \ub3d9\uc548\ub9cc \ud544\uc694\ud558\ub2e4. \ud55c\ud3b8 Segment Shrink\uac00 Oracle9i\uc758 online redefinition\uacfc \ub2e4\ub978 \uc810\uc740 \ubcc4\ub3c4\uc758 \uc784\uc2dc \uacf5\uac04\uc774 \uc5c6\uc774 \ubc14\ub85c \uadf8 \uc624\ube0c\uc81d\ud2b8\uc5d0 \ub300\ud574\uc11c (in-place) \uc218\ud589\ub420 \uc218 \uc788\ub2e4\ub294 \uc810\uc774\ub2e4.<\/p>\n<h3><\/h3>\n<h3>Segment Shrink\uc758 \uc870\uac74<\/h3>\n<p>&nbsp;<\/p>\n<ol style=\"margin-left: 74pt;\">\n<li>\n<div style=\"text-align: justify;\">\uc624\uc9c1 Automatic Segment Space Management(ASSM)\ub97c \uc0ac\uc6a9\ud558\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub0b4\uc758 \uc138\uadf8\uba3c\ud2b8\ub9cc\uc774 shrink\ub420 \uc218 \uc788\ub2e4. \ub370\uc774\ud130\uc758 compaction \uc815\ubcf4\ub294 \uc138\uadf8\uba3c\ud2b8 \ud5e4\ub354\uc758 bitmap block\uc744 \uc774\uc6a9\ud558\uae30 \ub54c\ubb38\uc774\ub2e4. \ub2e4\ub9cc \ub2e4\uc74c\uc758 \uc138\uadf8\uba3c\ud2b8\ub4e4\uc740 ASSM \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub0b4\uc5d0 \uc788\ub354\ub77c\ub3c4 shrink\ub420 \uc218 \uc5c6\ub294 \uc81c\ud55c\uc774 \uc788\ub2e4:<\/div>\n<\/li>\n<\/ol>\n<ul style=\"margin-left: 92pt;\">\n<li>\n<div style=\"text-align: justify;\">\uc784\uc2dc \uc138\uadf8\uba3c\ud2b8 \ubc0f Undo \uc138\uadf8\uba3c\ud2b8<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">\ud074\ub7ec\uc2a4\ud130 \ub0b4\uc758 \ud14c\uc774\ube14<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">LONG \uceec\ub7fc\uc744 \uac00\uc9c4 \ud14c\uc774\ube14<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">ROWID \uae30\ubc18\uc758 materialized view\uac00 \uc815\uc758\ub41c \ud14c\uc774\ube14<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">LOB \uc778\ub371\uc2a4<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">IOT mapping \ud14c\uc774\ube14<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">IOT overflow \uc138\uadf8\uba3c\ud2b8<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">\uacf5\uc720\ub41c LOB \uc138\uadf8\uba3c\ud2b8<\/div>\n<\/li>\n<\/ul>\n<div style=\"text-align: justify;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02. \ub370\uc774\ud130 compaction \ub2e8\uacc4\uc5d0\uc11c rowid\uac00 \ubcc0\uacbd\ub418\ubbc0\ub85c \ud574\ub2f9 <span style=\"color: #ff0000;\">\uc138\uadf8\uba3c\ud2b8\uc5d0 \ub300\ud574 \ubbf8\ub9ac ROW MOVEMENT\uac00 enable<\/span>\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4.<\/div>\n<div><\/div>\n<h3>SHRINK SPACE \uba85\ub839<\/h3>\n<p style=\"text-align: justify; margin-left: 56pt;\">\ud14c\uc774\ube14 \uc138\uadf8\uba3c\ud2b8\uc5d0 \ub300\ud55c segment shrink \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4:<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">ALTER table table_name SHRINK SPACE [COMPACT] [CASCADE];<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<ul style=\"margin-left: 96pt;\">\n<li>\n<div style=\"text-align: justify;\">\ubb3c\ub860 \ud14c\uc774\ube14 \ubfd0\ub9cc \uc544\ub2c8\ub77c segment shrink\ub97c \uc9c0\uc6d0\ud558\ub294 \ubaa8\ub4e0 \uc624\ube0c\uc81d\ud2b8\ub4e4\uc5d0 \ub300\ud574 \uc704\uc640 \uac19\uc740 \uba85\ub839\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">COMPACT \uc635\uc158\uc774 \uc9c0\uc815\ub41c \uacbd\uc6b0 segment shrink\ub294 1\ub2e8\uacc4\uc778 \ub370\uc774\ud130 compaction\uae4c\uc9c0\ub9cc \uc218\ud589\ub418\uac8c \ub41c\ub2e4.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">CASCADE \uc635\uc158\uc774 \uc9c0\uc815\ub41c \uacbd\uc6b0 segment shrink\ub294 dependent\ud55c \uc624\ube0c\uc81d\ud2b8\ub4e4\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc790\ub3d9\uc73c\ub85c \uc218\ud589\ub418\uac8c \ub41c\ub2e4. \uc608\ub97c \ub4e4\uba74 \ud14c\uc774\ube14\uc744 shrink\ud558\uba74\uc11c, \uadf8 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 \uc815\uc758\ub41c \uc778\ub371\uc2a4\ub4e4 \ub610\ud55c \uc790\ub3d9\uc73c\ub85c \ub3d9\uc2dc\uc5d0 shrink\ud560 \uc218 \uc788\ub2e4.<\/div>\n<\/li>\n<\/ul>\n<h3>Segment Advisor<\/h3>\n<p style=\"text-align: justify; margin-left: 56pt;\">Segment Advisor\ub294 Segment Shrink\ub97c \ud3ec\ud568\ud55c Segment \uad00\ub9ac\ub97c \uc704\ud574 EM\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 GUI\uc774\ub2e4. \uc774\ub294 EM\uc758 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ud398\uc774\uc9c0, \uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8 \ud398\uc774\uc9c0, \uadf8\ub9ac\uace0 Advisor Central \ud398\uc774\uc9c0 \uc911 \ud558\ub098\ub85c\ubd80\ud130 access\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 56pt;\">Segment Advisor\uc758 \uae30\ub2a5\uc740 \ub2e4\uc74c\uacfc \uac19\uc73c\uba70 \ud544\uc694\ud55c \uc790\ub8cc\ub4e4\uc740 AWR\ub85c\ubd80\ud130 \uc81c\uacf5\ubc1b\ub294\ub2e4.<\/p>\n<ul style=\"margin-left: 96pt;\">\n<li>\n<div style=\"text-align: justify;\">Segment Shrink<\/div>\n<p style=\"text-align: justify; margin-left: 9pt;\">Segment Advisor\ub294 \uc5b4\ub5a4 \uc624\ube0c\uc81d\ud2b8\uac00 shrink \uc5f0\uc0b0\uc744 \uc704\ud55c \uc88b\uc740 \ud6c4\ubcf4\uc778\uc9c0\ub97c \uad8c\uace0\ud55c\ub2e4. \uc774\ub7ec\ud55c \uacb0\uc815\uc740 \uadf8 \uc138\uadf8\uba3c\ud2b8\uc5d0 \ud560\ub2f9\ub418\uc5c8\uc73c\ub098 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacf5\uac04\uc758 \ud06c\uae30, \uc138\uadf8\uba3c\ud2b8\uc758 \uacf5\uac04 \uc0ac\uc6a9 \uacbd\ud5a5 \ub4f1\uc5d0 \uadfc\uac70\ud55c\ub2e4.<\/p>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">Growth Trend Report<\/div>\n<p style=\"text-align: justify; margin-left: 9pt;\">\uc138\uadf8\uba3c\ud2b8\uc758 \uacf5\uac04 \uc0ac\uc6a9 \uacbd\ud5a5\uc744 \ubcf4\uace0\ud568\uc73c\ub85c\uc368 DBA\uc758 \uc6a9\ub7c9 \uacc4\ud68d\uc744 \ub3d5\ub294\ub2e4. \uc774\ub294 \ub098\uc544\uac00 Proactive Tablespace Monitoring \uae30\ub2a5\uacfc \uc5f0\ub3d9\ub41c\ub2e4.<\/p>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">New Segment Resource Estimation<\/div>\n<p style=\"text-align: justify; margin-left: 9pt;\">EM\uc758 \uc0c8\ub85c\uc6b4 \uc138\uadf8\uba3c\ud2b8 \uc0dd\uc131 \ud398\uc774\uc9c0\uc5d0\ub294 &#8220;\ud06c\uae30 \uc608\uce21&#8221; \ubc84\ud2bc\uc774 \uc788\uc5b4 \uc774\ub97c \uc774\uc6a9\ud558\uba74 \ud544\uc694\ud55c \ub514\uc2a4\ud06c \ud06c\uae30\ub97c \uc608\uce21\ud560 \uc218 \uc788\ub2e4. \uc774\ub294 \uc138\uadf8\uba3c\ud2b8\uc758 \uad6c\uc870, \uc608\uc0c1\ub418\ub294 \ud589\uc758 \uc218 \ub4f1\uc5d0 \uadfc\uac70\ud55c\ub2e4.<\/p>\n<\/li>\n<\/ul>\n<h2><\/h2>\n<h2>\ud14c\uc2a4\ud2b8<\/h2>\n<h3>\ud14c\uc2a4\ud2b8 1: Segment Shrink<\/h3>\n<p style=\"text-align: justify; margin-left: 56pt;\">1. \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \ud14c\uc774\ube14\uc744 \ud558\ub098 \uc0dd\uc131\ud558\uace0 \ub370\uc774\ud130\ub97c \uc785\ub825\ud574\ub454\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; conn scott\/tiger<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc5f0\uacb0\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create table employees as select * from hr.employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; insert into employees select * from employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">107 <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uac1c\uc758\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud589\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; \/<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">. . .<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; \/<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier; background-color: #d9d9d9;\">27392 <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515; background-color: #d9d9d9;\">\uac1c\uc758\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515; background-color: #d9d9d9;\">\ud589\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515; background-color: #d9d9d9;\">\ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier; background-color: #d9d9d9;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"><span style=\"background-color: #d9d9d9;\">SQL&gt; commit;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ucee4\ubc0b\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">2. \uc774\uc81c employees \ud14c\uc774\ube14\uc774 \uc5bc\ub9c8\ub9cc\ud07c\uc758 \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub294\uc9c0\ub97c \ud655\uc778\ud574\ubcf4\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select count(distinct dbms_rowid.rowid_block_number(rowid)) blocks from employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> BLOCKS<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">&#8212;&#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 556<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select blocks, extents from user_segments where segment_name = &#8216;EMPLOYEES&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> BLOCKS EXTENTS<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 640 20<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">\uccab\ubc88\uc9f8 \uc870\ud68c\uc5d0\uc11c \uc5bb\ub294 blocks\ub294 \uc2e4\uc81c\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 block\uc758 \uac1c\uc218\ub97c \ub098\ud0c0\ub0b8\ub2e4. \ubc18\uba74\uc5d0 \ub450\ubc88\uc9f8 \uc870\ud68c\uc5d0\uc11c \uc5bb\uc740 blocks\ub294 \ud560\ub2f9\ub41c block\uc758 \uac1c\uc218, \uc989 HWM\ub97c \ub098\ud0c0\ub0b8\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 56pt;\">3. \uc774\uc81c \uc774 \ud14c\uc774\ube14\uc5d0 &#8220;hole&#8221;\uc744 \ub9cc\ub4e4\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; delete employees where department_id = 50;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">23040 <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud589\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0ad\uc81c\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"><span style=\"background-color: #d9d9d9;\">SQL&gt; commit;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ucee4\ubc0b\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">4. \uc774\uc81c HWM \uc544\ub798\uc5d0 \ub9ce\uc740 \ube48 \uacf5\uac04\uc774 \uc0dd\uae34 employee \ud14c\uc774\ube14\uc744 shrink\ud574\ubcf4\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees shrink space compact;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">alter table employees shrink space compact<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">*<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">1<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud589\uc5d0\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc624\ub958<\/span><span style=\"font-family: Courier;\">:<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">ORA-10636: ROW MOVEMENT is not enabled<br \/>\n<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">5. ROW MOVEMENT\ub294 default\ub85c disable\ub418\uc5b4 \uc788\ub2e4. \uc774\uac83\uc744 \uc218\uc815\ud558\uace0 \uc7ac\uc2dc\ub3c4 \ud574\ubcf4\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees enable row movement;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees shrink space compact;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">6. Shrink space \uba85\ub839\uc5d0 compact \uc635\uc158\uc744 \uc8fc\uc5c8\ub2e4. \uc774\ub294 \ub370\uc774\ud130\uc758 compaction\ub9cc \uc77c\uc73c\ud0a4\uace0, HWM\ub294 \uadf8\ub300\ub85c \ub450\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4. \uc774\ub294 \ub2e4\uc74c\uc758 \uc870\ud68c\ub85c \ud655\uc778\ud574\ubcfc \uc218 \uc788\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select count(distinct dbms_rowid.rowid_block_number(rowid)) blocks from employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"> BLOCKS<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">&#8212;&#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"> 304<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select blocks, extents from user_segments where segment_name = &#8216;EMPLOYEES&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"> BLOCKS EXTENTS<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"> 640 20<br \/>\n<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">\uc2e4\uc81c \uc0ac\uc6a9\ud558\ub294 block\uc758 \uac1c\uc218\uac00 556\uac1c\uc5d0\uc11c 304\uac1c\ub85c \ub298\uc5c8\ub2e4. \ub2e4\ub9cc HWM\ub294 640\uc73c\ub85c \ubcc0\ud55c \uac8c \uc5c6\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify; margin-left: 56pt;\">7. \uc774\uc81c HWM\uae4c\uc9c0 \uc870\uc815\ud55c \ud6c4 \ub2e4\uc2dc \uacb0\uacfc\ub97c \ud655\uc778\ud574\ubcf4\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees shrink space;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select blocks, extents from user_segments where segment_name = &#8216;EMPLOYEES&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"> BLOCKS EXTENTS<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"> 320 18<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">HWM\uac00 640 \uc5d0\uc11c 320 \uc73c\ub85c \ub0b4\ub824\uac14\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h3>\ud14c\uc2a4\ud2b8 2: Segment Advisor<\/h3>\n<p style=\"text-align: justify; margin-left: 57pt;\">1. \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ud558\ub098\ub97c \uc0c8\ub85c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create tablespace segment_test<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 2 datafile &#8216;D:\\SW\\oracle\\oradata\\cook\\segment_test.dbf&#8217; size 5m<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 3 logging<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 4 extent management local<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 5 segment space management auto;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc601\uc5ed\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 57pt;\">2. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc784\uacc4\uac12\uc744 \ud655\uc778\ud574\ubcf4\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select warning_value,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 2 critical_value,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 3 object_name<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 4 from dba_thresholds<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 5 where metrics_name = &#8216;Tablespace Space Usage&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">WARNING_VALUE CRITICAL_VALUE OBJECT_NAME<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">85 97<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\uae30\ubcf8\uac12\uc744 \uadf8\ub300\ub85c \uc4f0\uace0 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\ub2e4. \uc774\uc81c 1\ubc88\uc5d0\uc11c \uc0dd\uc131\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574 warning \ubc0f critical value\ub97c \uac01\uac01 50, 60\uc73c\ub85c \uc218\uc815\ud558\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; exec dbms_server_alert.set_threshold(9000, dbms_server_alert.OPERATOR_GT, 50, dbms_server_alert.OPERATOR_GT, 60, 1, 1, null, dbms_server_alert.OBJECT_TYPE_TABLESPACE, &#8216;SEGMENT_TEST&#8217;);<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">PL\/SQL <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ucc98\ub9ac\uac00\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc815\uc0c1\uc801\uc73c\ub85c\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select warning_value,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 2 critical_value,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 3 object_name<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 4 from dba_thresholds<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 5 where metrics_name = &#8216;Tablespace Space Usage&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">WARNING_VALUE CRITICAL_VALUE OBJECT_NAME<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">50 60 SEGMENT_TEST<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">85 97<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 57pt;\">3. \uc774\uc81c \uc774 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub0b4\uc5d0 \ud14c\uc774\ube14\uc744 \ud558\ub098 \uc0dd\uc131\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucda9\ubd84\ud788 \uc785\ub825\ud55c\ub2e4. \uadf8\ub9ac\uace0 DELETE \uc5f0\uc0b0\uc744 \ud1b5\ud574 hole\uc744 \ub9cc\ub4e0\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; conn scott\/tiger<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc5f0\uacb0\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create table employees1 tablespace segment_test as select * from hr.employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create table employees2 tablespace segment_test as select * from hr.employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create table employees3 tablespace segment_test as select * from hr.employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create table employees4 tablespace segment_test as select * from hr.employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; create table employees5 tablespace segment_test as select * from hr.employees;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; begin<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 2 for i in 1..5 loop<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 3 insert into employees1 select * from employees1;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 4 insert into employees2 select * from employees2;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 5 insert into employees3 select * from employees3;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 6 insert into employees4 select * from employees4;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 7 insert into employees5 select * from employees5;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 8<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 9 commit;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 10 end loop;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 11 end;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\"> 12 \/<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">PL\/SQL <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ucc98\ub9ac\uac00\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc815\uc0c1\uc801\uc73c\ub85c\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; insert into employees1 select * from employees1;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">3424 <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uac1c\uc758\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud589\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; insert into employees2 select * from employees2;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">3424 <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uac1c\uc758\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud589\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; insert into employees3 select * from employees3;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: Courier;\">3424 <\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uac1c\uc758\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud589\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\"><span style=\"background-color: #d9d9d9;\">SQL&gt; commit;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ucee4\ubc0b\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<br \/>\n<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 57pt;\">4. \ub9ce\uc740 \ud589\uc774 \uc785\ub825\ub418\uc5c8\uc73c\ubbc0\ub85c \uc7a0\uc2dc \ud6c4 \ub2e4\uc74c\uacfc \uac19\uc740 alert\uac00 \uc0dd\uc131\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select reason from dba_outstanding_alerts;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">REASON<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt;\">Tablespace [SEGMENT_TEST] is [52 percent] full<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 57pt;\">5. \uc5ec\uae30\uc11c \ubbf8\ub9ac 3\ubc88\uc5d0\uc11c \ub2e4\ub8e8\uc5c8\ub358 \ud14c\uc774\ube14\ub4e4 \uc911 \uc77c\ubd80\uc5d0 \ub300\ud574 ROW MOVEMENT\ub97c enable\uc2dc\ucf1c \ub454\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees1 enable row movement;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees2 enable row movement;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees3 enable row movement;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774\u00a0<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 57pt;\">6. \uc774\uc81c EM\uc758 Advisor Central \ub9c1\ud06c\ub97c \uc774\uc6a9\ud558\uc5ec Segment Advisor\uc5d0 \uc811\uc18d\ud558\uc790.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin1.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\ub300\uc0c1\uc73c\ub85c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc120\ud0dd\ud558\uace0, \ubd84\uc11d\uc740 Comprehensive \ubaa8\ub4dc\ub97c \uc120\ud0dd\ud55c \ud6c4 &#8220;\uacc4\uc18d&#8221;\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin2.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">Add\ub97c \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin3.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\ud14c\uc2a4\ud2b8 \ub300\uc0c1\uc778 segment_test\ub97c \uc120\ud0dd\ud558\uace0 \ud655\uc778\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin4.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\ub2e4\uc74c\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin5.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\ub2e4\uc74c\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin6.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\ub2e4\uc74c\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin7.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">Submit\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin8.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\uc7a0\uc2dc \ud6c4 Advisor Central \ud398\uc774\uc9c0\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 \ubc29\uae08 Submit\ud588\ub358 \ubd84\uc11d \uc791\uc5c5\uc774 \uc644\ub8cc\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/02\/020518_0040_OracleShrin9.png?w=640\" alt=\"\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"text-align: justify; margin-left: 57pt;\">\uacb0\uacfc \ubcf4\uae30\ub97c \ud074\ub9ad\ud558\uba74 Segment Advisor\uac00 Employees1, 2, 3 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 Segment Shrink\ub97c \ud560 \uac83\uc744 \uad8c\uace0\ud558\ub294 \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify; margin-left: 56pt;\">7. \uc774\uc81c employees1, 2, 3 \uc138\uac1c \ud14c\uc774\ube14\uc5d0 \ub300\ud574 shrink\ub97c \uc218\ud589\ud558\uc790.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees1 shrink space;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774<\/span><span style=\"font-family: Courier;\"><br \/>\n<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees2 shrink space;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774<\/span><span style=\"font-family: Courier;\"><br \/>\n<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<span style=\"background-color: #d9d9d9;\"><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; alter table employees3 shrink space;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc774<\/span><span style=\"font-family: Courier;\"><br \/>\n<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 56pt;\">8. \uc7a0\uc2dc \ud6c4 \uc544\uae4c \ubc1c\uc0dd\ud558\uc600\ub358 alert\uac00 \ud574\uc81c\ub418\uc5c8\uc74c\uc744 \uc54c \uc218 \uc788\ub2e4.<\/p>\n<div style=\"margin-left: 56pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 557px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: solid 0.5pt;\"><span style=\"font-family: Courier; font-size: 9pt; background-color: #d9d9d9;\">SQL&gt; select reason from dba_outstanding_alerts;<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: 9pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc120\ud0dd\ub41c<\/span><span style=\"font-family: Courier;\"><br \/>\n<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub808\ucf54\ub4dc\uac00<\/span><span style=\"font-family: Courier;\"><br \/>\n<\/span><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc5c6\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family: Courier;\">.<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2><\/h2>\n<h2><\/h2>\n<p><span style=\"color: #0000ff; font-size: 24px;\">Oracle10g \uc774\ud6c4 \ubc84\uc804\uc5d0\uc11c Segment Shrink \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc73c\ub85c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub0b4\uc758 <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff; font-size: 24px;\">\uacf5\uac04 \ub0ad\ube44\ub97c \uc904\uc774\uace0 \uadf8\uc5d0 \ub530\ub77c \uc131\ub2a5\uc744 \ub192\uc77c \uc218\uac00 \uc788\ub2e4. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff; font-size: 24px;\">\ub610\ud55c \uc774\ub97c Segment Advisor\uac00 \uc81c\uacf5\ud558\ub294 GUI\ub97c \ud1b5\ud574 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ub354\uc6b1 \uac04\ud3b8\ud558\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc5b4\ub5a4 \uc138\uadf8\uba3c\ud2b8\ub97c \uc704\ud574 \uacf5\uac04\uc774 \ud06c\uac8c \ud560\ub2f9\ub41c \uacbd\uc6b0 High Water Mark \uc774\ud6c4\uc758 \uacf5\uac04\uc740 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc740 \ucc44\ub85c \ub0a8\uc544 \uc788\uac8c \ub420 \uc218 \uc788\ub2e4. \ub610\ud55c High Water Mark \uc774\uc804\uc758 \uc601\uc5ed\uc5d0\ub3c4 \ub204\uc801\ub41c delete \uc5f0\uc0b0\uc758 \uacb0\uacfc\ub85c \ube48 \uacf5\uac04\uc774 \uc874\uc7ac\ud560 \uc218 \uc788\ub2e4. \uc774 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc81c\uc810\uc774 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\ub2e4: \ub370\uc774\ud130\uac00 \ubcf4\ub2e4 \ub9ce\uc740 \ube14\ub85d\ub4e4\uc5d0 \uac78\uccd0 \ud769\uc5b4\uc838 \uc788\uc73c\ubbc0\ub85c \uc2a4\uce94\uc2dc \ubcf4\ub2e4 \ub9ce\uc740 I\/O\uac00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3435,"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":[1011,429],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/databackup_article_008.jpg?fit=1200%2C400&ssl=1","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3567"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3567"}],"version-history":[{"count":4,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3567\/revisions"}],"predecessor-version":[{"id":4816,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3567\/revisions\/4816"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3435"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}