{"id":1082,"date":"2016-01-02T13:18:25","date_gmt":"2016-01-02T04:18:25","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1082"},"modified":"2018-09-11T14:32:16","modified_gmt":"2018-09-11T05:32:16","slug":"automatic-undo-management","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1082","title":{"rendered":"Automatic Undo Management"},"content":{"rendered":"<ul>\n<li><span style=\"COLOR: black\">Oracle \uc11c\ubc84\ub294 Commit \ub418\uc9c0 \uc54a\uc740 \ud2b8\ub79c\uc7ad\uc158\uc744 Rollback \uc2dc\ud0a4\uae30 \uc704\ud574, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcf5\uad6c \uacfc\uc815\uc744 \uc704\ud574, \uadf8\ub9ac\uace0 \ub3d9\uc2dc \uc0ac\uc6a9\uc790 \ud658\uacbd\uc5d0 \ud544\uc694\ud55c \uc77d\uae30 \uc77c\uad00\uc131\uc758 \ubcf4\uc7a5\uc744 \uc704\ud574 \ub864\ubc31 \uc815\ubcf4 \ub610\ub294 Undo \uc815\ubcf4\ub97c \uad00\ub9ac\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c Undo \uc815\ubcf4\uc758 \uad00\ub9ac\ub294 \uc804\ud1b5\uc801\uc73c\ub85c \ub864\ubc31 \uc138\uadf8\uba3c\ud2b8\uc5d0 \uc758\ud558\uc5ec \uc774\ub8e8\uc5b4\uc838 \uc654\uc2b5\ub2c8\ub2e4. Oracle database\ub294 \uc790\ub3d9\ud654\ub41c Undo \uad00\ub9ac \uae30\ub2a5\uc744 \uc81c\uacf5\ud568\uc73c\ub85c\uc368 \ubcf4\ub2e4 \ud5a5\uc0c1\ub41c Undo \uad00\ub9ac\ub97c \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4. <\/span><\/li>\n<li><span style=\"COLOR: black\">Oracle Database 11g\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\uc2a4\ub85c UNDO SEGMENT\ub97c \uad00\ub9ac\ud569\ub2c8\ub2e4. \uc989, DBA\ub294 \uc774 \uc138\uadf8\uba3c\ud2b8\uc5d0 \ub300\ud55c \ud06c\uae30 \uc0b0\uc815\uacfc \ud29c\ub2dd\uc744 \uc218\ud589\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \ub2e8\uc9c0, undo \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub9cc\uc744 \uc0dd\uc131\ud558\uc5ec \ud560\ub2f9\ud558\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 UNDO \uacbd\ud569 \ud604\uc0c1, \uc77c\uad00\uc131 \ubb38\uc81c\ud574\uacb0 \uadf8\ub9ac\uace0 \uacf5\uac04 \ud65c\uc6a9\ub3c4\ub97c \uadf9\ub300\ud654 \ud569\ub2c8\ub2e4. <\/span><\/li>\n<li><span style=\"COLOR: black\">\uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74, UNDO_RETENTION PARAMETER\ub97c \uc124\uc815\ud558\uc5ec COMMIT \ub41c UNDO \uc815\ubcf4\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc77c\uc815\uae30\uac04\ub3d9\uc548 \ubcf4\uc874\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc704 \uac12\uc744 \uc801\uc808\ud558\uac8c \uc124\uc815\ud568\uc73c\ub85c\uc368 \uc2dc\uac04\uc774 \uc624\ub798 \uac78\ub9ac\ub294 Query\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc885\ub8cc\ub418\uac8c\ub054 \uc870\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc791\uc5c5 \uc2dc, V$UNDOSTAT\uc774\ub77c\ub294 \ubdf0\ub97c \ud1b5\ud574 \ubaa8\ub2c8\ud130\ub9c1 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Oracle \uc11c\ubc84\ub294 Commit \ub418\uc9c0 \uc54a\uc740 \ud2b8\ub79c\uc7ad\uc158\uc744 Rollback \uc2dc\ud0a4\uae30 \uc704\ud574, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcf5\uad6c \uacfc\uc815\uc744 \uc704\ud574, \uadf8\ub9ac\uace0 \ub3d9\uc2dc \uc0ac\uc6a9\uc790 \ud658\uacbd\uc5d0 \ud544\uc694\ud55c \uc77d\uae30 \uc77c\uad00\uc131\uc758 \ubcf4\uc7a5\uc744 \uc704\ud574 \ub864\ubc31 \uc815\ubcf4 \ub610\ub294 Undo \uc815\ubcf4\ub97c \uad00\ub9ac\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c Undo \uc815\ubcf4\uc758 \uad00\ub9ac\ub294 \uc804\ud1b5\uc801\uc73c\ub85c \ub864\ubc31 \uc138\uadf8\uba3c\ud2b8\uc5d0 \uc758\ud558\uc5ec \uc774\ub8e8\uc5b4\uc838 \uc654\uc2b5\ub2c8\ub2e4. Oracle database\ub294 \uc790\ub3d9\ud654\ub41c Undo \uad00\ub9ac \uae30\ub2a5\uc744 \uc81c\uacf5\ud568\uc73c\ub85c\uc368 \ubcf4\ub2e4 \ud5a5\uc0c1\ub41c Undo \uad00\ub9ac\ub97c \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4. Oracle Database 11g\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","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":[72,576,577,578,579],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1082"}],"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=1082"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1082\/revisions"}],"predecessor-version":[{"id":4152,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1082\/revisions\/4152"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1082"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}