{"id":383,"date":"2024-11-21T13:15:39","date_gmt":"2024-11-21T04:15:39","guid":{"rendered":"https:\/\/sejiwon.com\/?p=383"},"modified":"2024-11-21T13:15:39","modified_gmt":"2024-11-21T04:15:39","slug":"rollback-%ec%a4%91%ec%9d%b8%ec%a7%80-%ed%99%95%ec%9d%b8%ed%95%98%ea%b3%a0-%ec%8b%b6%ec%9d%84-%eb%95%8c%ec%98%a4%eb%9d%bc%ed%81%b4","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=383","title":{"rendered":"RollBack \uc911\uc778\uc9c0 \ud655\uc778\ud558\uace0 \uc2f6\uc744 \ub54c(\uc624\ub77c\ud074)"},"content":{"rendered":"\n<p>\ub300\uc6a9\ub7c9 \ud14c\uc774\ube14 \ubc0f \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub2e4 \ubcf4\uba74 \ub9ce\uc740 \uc591\uc758 Insert, Delete, Update\ub97c \ud55c \ud6c4, Rollback\uc744 \ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \ub54c, \ub864\ubc31\uba85\ub839\uc744 \ud55c \ud6c4 \uc774\uac8c \uc815\ub9d0 \ub864\ubc31\uc774 \ub418\uace0 \uc788\ub098 \uc2f6\uc744 \uc815\ub3c4\ub85c \uc624\ub7ab\ub3d9\uc548 \uc548 \ub04a\uae30\uace0 \uc788\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub7f4 \ub54c \ub864\ubc31\uc774 \ub418\uace0 \uc788\ub294\uc9c0\ub97c \ud655\uc778\ud558\uace0 \uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 SQL\uc744 \ud558\ub098 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\uba3c\uc800, \ub3d9\uc791\uc2dc\ud0a8 sql_id \uc758 \uac12\uc740 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc744 \uc2e4\ud589\uc2dc\ucf1c\uc11c \uc5ec\uae30\uc5d0 \uacb0\uacfc\uac00 \ub098\uc624\uace0 \uc788\uc73c\uba74 \ub864\ubc31\uc744 \ud558\uace0 \uc788\ub294 \uac81\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT S.SID\n      ,S.SERIAL#\n      ,S.USERNAME\n      ,T.START_DATE\n      ,T.USED_UBLK\n      ,T.USED_UREC\n      ,S.EVENT\n      ,R.NAME\n  FROM V$SESSION S\n      ,V$TRANSACTION T\n      ,V$ROLLNAME R\n WHERE S.TADDR = T.ADDR\n   AND T.XIDUSN = R.USN\n   AND S.PREV_SQL_ID = 'sqlid\uac12'\n;\n<\/code><\/pre>\n\n\n\n<p>\uc704 \ucc98\ub7fc \ud655\uc778\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub300\uc6a9\ub7c9 \ud14c\uc774\ube14 \ubc0f \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub2e4 \ubcf4\uba74 \ub9ce\uc740 \uc591\uc758 Insert, Delete, Update\ub97c \ud55c \ud6c4, Rollback\uc744 \ud574\uc57c\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ub54c, \ub864\ubc31\uba85\ub839\uc744 \ud55c \ud6c4 \uc774\uac8c \uc815\ub9d0 \ub864\ubc31\uc774 \ub418\uace0 \uc788\ub098 \uc2f6\uc744 \uc815\ub3c4\ub85c \uc624\ub7ab\ub3d9\uc548 \uc548 \ub04a\uae30\uace0 \uc788\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f4 \ub54c \ub864\ubc31\uc774 \ub418\uace0 \uc788\ub294\uc9c0\ub97c \ud655\uc778\ud558\uace0 \uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 SQL\uc744 \ud558\ub098 \uc18c\uac1c\ud569\ub2c8\ub2e4. \uba3c\uc800, \ub3d9\uc791\uc2dc\ud0a8 sql_id \uc758 \uac12\uc740 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc744\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=383\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/383"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=383"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/383\/revisions"}],"predecessor-version":[{"id":385,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/383\/revisions\/385"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}