{"id":4436,"date":"2019-08-08T09:28:31","date_gmt":"2019-08-08T00:28:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4436"},"modified":"2019-08-08T10:41:37","modified_gmt":"2019-08-08T01:41:37","slug":"%ec%98%a4%eb%9e%ab%eb%8f%99%ec%95%88-%ec%88%98%ed%96%89%ed%96%88%eb%8d%98-dml-%ec%84%b8%ec%85%98%ec%9d%84-kill-%ec%b7%a8%ec%86%8c-%ed%96%88%ec%9d%84-%ea%b2%bd%ec%9a%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4436","title":{"rendered":"\uc624\ub7ab\ub3d9\uc548 \uc218\ud589\ud588\ub358 DML \uc138\uc158\uc744 \uac15\uc81c \ucde8\uc18c (\uc138\uc158 KILL) \ud588\uc744 \uacbd\uc6b0 &#8230;"},"content":{"rendered":"\n<p>\uc624\ub7ab\ub3d9\uc548 \uc218\ud589\ud588\ub358 DML \uc138\uc158\uc744 Kill \ucde8\uc18c \ud588\uc744 \uacbd\uc6b0 \uc0ac\uc6a9\ud55c Undo \ub9b4\ub9ac\uc988 \ud558\ub294 \ub0a8\uc740 \uc2dc\uac04 \ud655\uc778 \ud558\ub294 \ubc29\ubc95<\/p>\n\n\n\n<p><strong>\uc218\ud589 \uc2dc\uac04\uc774 \uae34 \ud2b8\ub79c\uc7ad\uc158\uc744 kill \ud588\uc744 \uacbd\uc6b0 SMON\uc774 \ubcf5\uad6c<\/strong>\ud558\ub294 \uacfc\uc815\uc5d0\uc11c<\/p>\n\n\n\n<p>wait for a undo record \uc774\ubca4\ud2b8\uc640 &nbsp;PX Deq: Txn Recovery Start \uc774\ubca4\ud2b8\uac00 \ub3d9\uc2dc\uc5d0 \ub300\ub7c9\uc73c\ub85c&nbsp;\ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>1 ) update \ud558\ub358 \uc138\uc158\uc774 \ub108\ubb34 \uc624\ub798 \uac78\ub824\uc11c \uc544\ub798\uc640 \uac19\uc774 \uc138\uc158 kill \uc744 \uc218\ud589\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">alter system kill session 'sid,seiral#' immediate;<\/pre>\n\n\n<p>\uc774\ub807\uac8c \ud558\uba74 <strong>SMON \uc740 \uc5ec\ub7ec\uac1c\uc758 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\ub97c \uc774\uc6a9\ud574\uc11c \ud2b8\ub79c\uc7ad\uc158\uc744 rollback \ucc98\ub9ac<\/strong>\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc0c1\ub2f9\ud788 \ub9ce\uc740 \ub7c9\uc758 <strong>wait for a undo record <\/strong>\uc774\ubca4\ud2b8\uc640&nbsp; <strong>PX Deq: Txn Recovery Start<\/strong>\uac00 \uac10\uc9c0\uac00 \ub41c \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">===========================================================================================\n\nSession Information\n\n===========================================================================================\n\nSID-SERIAL     HashValue    Spid       Machine-Program                 COMMAND LOGON_TIME  Call(s)    EVENT\n\n-------------- ------------ ---------- --------------------------      ------  ---------- ---------- -------------------------\n\n[9874,46615]   0            7472078    orcl@db01 (P000)  n\/a     0620.20:12    000.000  db file sequential read\n\n[245,61609]    0            61670314   orcl@db01 (P059)  n\/a     0620.20:12    000.000  wait for a undo record\n\n[5681,17633]   0            35717294   orcl@db01 (P035)  n\/a     0620.20:12    000.000  row cache lock\n\n[5480,33199]   0            24707536   orcl@db01 (P007)  n\/a     0620.20:12    000.000  wait for a undo record\n\n[5238,20611]   0            20578538   orcl@db01 (P036)  n\/a     0620.20:12    000.000  wait for a undo record\n...\n\n================================================================================\n\nSession Information\n\n================================================================================\n\nSID-SERIAL     HashValue    Spid       Machine-Program             COMMAND LOGON_TIME  Call(s)    EVENT\n\n-------------- ------------ ---------- --------------------------  ------- ----------- ---------- ---------------------------\n\n[9867,18343]   0            7472078    orcl@db01 (P000)   n\/a     0620.20:24    000.000  wait for a undo record\n\n[5238,20743]   0            20578538   orcl@db01 (P036)   n\/a     0620.20:24    000.000  PX Deq: Txn Recovery Start\n\n[3256,43759]   791757000    52822524   orcl@db01 (P029)   select  0620.20:24    000.000  PX Deq: Txn Recovery Start\n\n[8495,57391]   0            12518128   orcl@db01 (P056)   n\/a     0620.20:24    000.000  PX Deq: Txn Recovery Start\n\n...<\/pre>\n\n\n<p>\uc774\uac83\uc744 <strong>Fast Start Parallel&nbsp;Rollback<\/strong> \uc774\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ucd08\uae30\ud654 \ud30c\ub77c\uba54\ud130&nbsp;<strong>FAST_START_PARALLEL_ROLLBACK <\/strong>\uc758 \uac12\uc5d0 \ub530\ub77c\uc11c \ubcf5\uad6c\ud560 \ub54c \uc758 parallel degree \uac00 \uacb0\uc815\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>FALSE \uc77c \uacbd\uc6b0\ub294 Parallel Rollback\uc744 \uc218\ud589\ud558\uc9c0 \uc54a\ub294 \uac83\uc774\uba70,<\/p>\n\n\n\n<p>LOW (default) \uc77c \uacbd\uc6b0\ub294 CPU_COUNT * 2 \uae4c\uc9c0 \ubcd1\ub82c\ub85c \ub864\ubc31\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>HIGH \uc77c \uacbd\uc6b0\ub294 CPU_COUNT * 4 \uae4c\uc9c0 \ubcd1\ub82c\ub85c \ub864\ubc31\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>parallel rollback \uc774 \ud56d\uc0c1 \uc88b\uc740 \uac83\ub9cc\uc740 \uc544\ub2d9\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubcc0\uacbd\uc774 \ub9ce\uc740 \uc11c\ube44\uc2a4\uc758 \uacbd\uc6b0\uc5d0\ub294 \uc774\ub85c \uc778\ud574\uc11c undo segment \ubd80\uc871 \ud604\uc0c1\uc73c\ub85c \uc544\ub798\uc640 \uac19\uc740 \uc5d0\ub7ec \uba54\uc2dc\uc9c0\ub85c \uc7a5\uc560\uc0c1\ud669\uc774 \ub420 \uc218 \ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-syntaxhighlighter-code \">ORA-30036: unable to extend segment by 8 in undo tablespace \"UNDO TABLESPACE NAME\"<\/pre>\n\n\n<p>Parallel rollback \ucc98\ub9ac\uc911\uc5d0&nbsp;V$FAST_START_SERVERS \ub85c \uc0c1\ud0dc\ub97c&nbsp;\uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-syntaxhighlighter-code \">select state, count(*) from V$FAST_START_SERVERS group by state;\n\nSTATE         COUNT(*)\n----------- ----------\nRECOVERING          60\n\n\/\n\nSTATE         COUNT(*)\n----------- ----------\nIDLE                59\nRECOVERING           1<\/pre>\n\n\n<p>\uadf8\ub9ac\uace0, <strong>\uc5b8\uc81c\ucbe4 \ub05d\ub0a0\uc9c0<\/strong>\ub3c4 V$FAST_START_TRANSACTIONS \ubdf0\ub85c&nbsp;<strong>\uc608\uce21\ud574\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/p>\n\n\n<pre class=\"wp-block-syntaxhighlighter-code \">ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY\/MM\/DD HH24:MI:SS';\n\nSELECT usn, state, undoblockstotal \"Total\", undoblocksdone \"Done\",\n undoblockstotal-undoblocksdone \"ToDo\",\nDECODE(cputime,0,'unknown',SYSDATE+(((undoblockstotal-undoblocksdone) \/ (undoblocksdone \/ cputime)) \/ 86400)) \"Finish at\"  \nFROM v$fast_start_transactions; \n\n       USN STATE                 Total       Done       ToDo Finish at\n---------- ---------------- ---------- ---------- ---------- -------------------       \n1109 RECOVERING          2269489      31317    2238172 2019\/08\/08 00:06:03<\/pre>\n<p><!-- \/wp:syntaxhighlighter\/code --><\/p>\n<p><!-- wp:table --><\/p>\n<table class=\"wp-block-table\">\n<tbody>\n<tr>\n<td>\ub2e4\uc74c\uacfc \uac19\uc774 \uc608\uce21\ud574\ubcfc \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-- \/wp:table --><\/p>\n<p><!-- wp:syntaxhighlighter\/code {\"language\":\"oracle8\"} --><\/p>\n<pre class=\"wp-block-syntaxhighlighter-code \"> select ktuxeusn, to_char(sysdate,'YYYY\/MM\/DD HH24:MI:SS') \"Time\", ktuxesiz, ktuxesta\nfrom x$ktuxe\nwhere ktuxecfl = 'DEAD'; \n\n\n   KTUXEUSN Time                  KTUXESIZ KTUXESTA\n---------- ------------------- ---------- --------------       \n1109 2019\/07\/20 23:07:22    1800231 ACTIVE<\/pre>\n<pre class=\"wp-block-syntaxhighlighter-code\">ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY\/MM\/DD HH24:MI:SS';\n\nSELECT usn, state, undoblockstotal \"Total\", undoblocksdone \"Done\", \nundoblockstotal-undoblocksdone \"ToDo\",\nDECODE(cputime,0,'unknown',SYSDATE+(((undoblockstotal-undoblocksdone) \/ (undoblocksdone \/ cputime)) \/ 86400)) \"Finish at\"  \nFROM v$fast_start_transactions; \n\n\n       USN STATE                 Total       Done       ToDo Finish at\n---------- ---------------- ---------- ---------- ---------- -------------------       \n1109 RECOVERING          2269489      31317    2238172 2019\/07\/21 00:06:03<\/pre>\n<p><!-- wp:table --><\/p>\n<table class=\"wp-block-table\">\n<tbody>\n<tr>\n<td><strong>\ub2e4\uc74c\uacfc \uac19\uc774 \uc608\uce21\ud574\ubcfc \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-- \/wp:table --><\/p>\n<p><!-- wp:syntaxhighlighter\/code {\"language\":\"oracle8\"} --><\/p>\n<pre class=\"wp-block-syntaxhighlighter-code\">select ktuxeusn, to_char(sysdate,'YYYY\/MM\/DD HH24:MI:SS') \"Time\", ktuxesiz, ktuxesta\nfrom x$ktuxewhere ktuxecfl = 'DEAD'; \n\n\n  KTUXEUSN Time                  KTUXESIZ KTUXESTA\n---------- ------------------- ---------- --------------       \n1109 2019\/07\/20 23:07:22    1800231 ACTIVE<\/pre>\n<p><!-- \/wp:syntaxhighlighter\/code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\uc644\ub8cc\uac00 \ub418\uba74 \uc774\ub807\uac8c \uc870\ud68c\uac00 \ub429\ub2c8\ub2e4.<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:syntaxhighlighter\/code {\"language\":\"oracle8\"} --><\/p>\n<pre class=\"wp-block-syntaxhighlighter-code\"> ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY\/MM\/DD HH24:MI:SS';\nSELECT usn, state, undoblockstotal \"Total\", undoblocksdone \"Done\",\n undoblockstotal-undoblocksdone \"ToDo\",\nDECODE(cputime,0,'unknown',SYSDATE+(((undoblockstotal-undoblocksdone) \/ (undoblocksdone \/ cputime)) \/ 86400)) \"Finish at\"  \nFROM v$fast_start_transactions; \n\n\n       USN STATE                 Total       Done       ToDo Finish at\n---------- ---------------- ---------- ---------- ---------- -------------------      \n1109 RECOVERED             32874      32874          0 2019\/07\/21 00:24:21<\/pre>\n<p><!-- \/wp:syntaxhighlighter\/code --><\/p>\n<p><!-- wp:table --><\/p>\n<table class=\"wp-block-table\">\n<tbody>\n<tr>\n<td style=\"width: 567.083px;\">\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-- \/wp:table --><\/p>","protected":false},"excerpt":{"rendered":"<p>\uc624\ub7ab\ub3d9\uc548 \uc218\ud589\ud588\ub358 DML \uc138\uc158\uc744 Kill \ucde8\uc18c \ud588\uc744 \uacbd\uc6b0 \uc0ac\uc6a9\ud55c Undo \ub9b4\ub9ac\uc988 \ud558\ub294 \ub0a8\uc740 \uc2dc\uac04 \ud655\uc778 \ud558\ub294 \ubc29\ubc95 \uc218\ud589 \uc2dc\uac04\uc774 \uae34 \ud2b8\ub79c\uc7ad\uc158\uc744 kill \ud588\uc744 \uacbd\uc6b0 SMON\uc774 \ubcf5\uad6c\ud558\ub294 \uacfc\uc815\uc5d0\uc11c wait for a undo record \uc774\ubca4\ud2b8\uc640 &nbsp;PX Deq: Txn Recovery Start \uc774\ubca4\ud2b8\uac00 \ub3d9\uc2dc\uc5d0 \ub300\ub7c9\uc73c\ub85c&nbsp;\ubc1c\uc0dd\ud569\ub2c8\ub2e4. 1 ) update \ud558\ub358 \uc138\uc158\uc774 \ub108\ubb34 \uc624\ub798 \uac78\ub824\uc11c \uc544\ub798\uc640 \uac19\uc774 \uc138\uc158 kill \uc744 \uc218\ud589\ud588\uc2b5\ub2c8\ub2e4. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3402,"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":[1152],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how-1.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4436"}],"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=4436"}],"version-history":[{"count":32,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4436\/revisions"}],"predecessor-version":[{"id":4514,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4436\/revisions\/4514"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3402"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4436"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}