{"id":343,"date":"2015-03-18T01:52:46","date_gmt":"2015-03-18T01:52:46","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=343"},"modified":"2015-03-18T01:52:46","modified_gmt":"2015-03-18T01:52:46","slug":"killed-session-%ec%97%90%eb%8c%80%ed%95%9c-smon-rollback-%ec%9d%84-%eb%b9%a0%eb%a5%b4%ea%b2%8c%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=343","title":{"rendered":"KILLED SESSION \uc5d0\ub300\ud55c SMON rollback \uc744 \ube60\ub974\uac8c\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"

\uc5b4\uc81c\ubc24\uc5d0 \uac1c\ubc1c\uc790\uac00 \uc62c\ub798\uac78\ub9ac\ub294 \uc791\uc5c5\uc774 \uc788\uc5b4\uc11c \ub3cc\ub9ac\uace0 \ud1f4\uadfc \ud588\ub2e4<\/p>\n

<\/p>\n

\ub2e4\uc74c\ub0a0 \ucd9c\uadfc\ud574\uc11c \uc640\ubcf4\ub2c8 \uc798\ubabb\ub41c \uc870\uac74\uc73c\ub85c \uc798\ubabb\ub41c DML\uc774 \uc544\uc9c1\ub3c4 \uc548\ub05d\ub0ab\ub2e4.. \uac1c\ubc1c\uc790\ub294 \uc544\ubb34\ub807\uc9c0 \uc54a\uac8c X\ubc84\ud2bc\uc744 \ub20c\ub7ec \ud504\ub85c\uadf8\ub7a8\uc744 \uaecf\ub2e4. \uc5b4\ub5a4 \uc0c1\ud669\uc774 \ubc1c\uc0dd\ud560\uae4c.?<\/p>\n

<\/p>\n

\uadf8 \ud14c\uc774\ube14\uc758 Rollback\uc774 \uc774\ub904 \uc9c0\uba74\uc11c \uc791\uc5c5 \uc2dc\uac04 \ub9cc\ud07c Lock \ud604\uc0c1\uc73c\ub85c \uadf8 \ud14c\uc774\ube14\uc758 \uc11c\ube44\uc2a4\ub294 \ubd88\uac00 \ud558\ub2e4..<\/p>\n

<\/p>\n

\uc544\ub798 \uc138\ud305\uc744 \ubbf8\ub9ac \ud574\ub193\uc73c\uba74 \uc774\ub54c \ubcf5\uad6c \uc2dc\uac04\uc744 \ube60\ub974\uac8c \ud560 \uc218 \uc788\ub2e4.<\/p>\n


<\/span><\/b><\/p>\n

_CLEANUP_ROLLBACK_ENTRIES <\/span>\uac00<\/span> <\/span>\ud55c\ubc88\uc5d0<\/span> rollback
\n<\/span>\ud558\ub294<\/span> count
\n(V$TRANSACTION.USED_UREC) <\/span>\ub97c<\/span> <\/span>\uacb0\uc815\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/b><\/p>\n


<\/span><\/b><\/p>\n

\uff03\uc21c\uc11c

<\/span><\/span><\/b><\/p>\n

1.
\n<\/span><\/span>\ud604\uc7ac\uac12\uc740<\/span> <\/span>\uc544\ub798<\/span> query <\/span>\ub85c<\/span> <\/span>\ud655\uc778\ud569\ub2c8\ub2e4<\/span>.<\/span><\/p>\n

select
\na.ksppinm “Parameter”,<\/span>
b.ksppstvl “Session Value”,<\/span>
c.ksppstvl “Instance
\nValue”<\/span>
from x$ksppi a, x$ksppcv b, x$ksppsv c<\/span>
where a.indx = b.indx and
\na.indx = c.indx<\/span>
and a.ksppinm like ‘%_cleanup_rollback%’<\/span>
\/<\/span><\/p>\n

2.
\n‘_cleanup_rollback_entries’ <\/span><\/span>\uc744<\/span> <\/span>\uc6d0\ud558\ub294<\/span> <\/span>\uc22b\uc790\ub85c<\/span> <\/span>\ud558\uc2dc\uace0<\/span>
\nfast_start_parallel_rollback=false <\/span>\ub85c<\/span> <\/span>\ubcc0\uacbd<\/span> <\/span>\ud6c4<\/span> DB restartup
\n<\/span>\ud558\uc138\uc694<\/span>.<\/span><\/p>\n

(<\/span><\/span>\uacbd\ud5d8\uc0c1<\/span>
\n_cleanup_rollback_entries = <\/span>\uba87\ub9cc<\/span> <\/span>\uae4c\uc9c0<\/span> <\/span>\uc0ac\uc6a9\ud574\ubd24\uc2b5\ub2c8\ub2e4<\/span><\/b>.)<\/span><\/p>\n

<\uadfc\uac70<\/span>><\/span><\/span>
Note
\n414242.1 – Database Hangs Because SMON is taking 100% CPU doing transaction
\nrecovery<\/span>
Note 1060831.6 – Rollback Is Taking A Long Time After Session
\nKilled<\/span><\/b>
<\/span><\/p>\n


<\/span><\/b><\/span><\/p>\n


<\/span><\/b><\/span><\/p>\n

\uff03\ucd94\uac00 \ucc38\uace0 <\/span><\/b><\/span><\/p>\n

1. _cleanup_rollback_entries’ <\/span>\uc744<\/span> <\/span>\ub108\ubb34<\/span> <\/span>\ud06c\uac8c\ud558\ub294<\/span> <\/span>\uacbd\uc6b0<\/span> rollback
\n<\/span>\ubd80\ud558\ub85c<\/span> <\/span>\ub2e4\ub978<\/span> <\/span>\uc791\uc5c5<\/span> <\/span>\uc601\ud5a5<\/span> <\/span>\ubc1b\uc744<\/span> <\/span>\uc218<\/span> <\/span>\uc788\uc74c<\/span>.<\/span><\/span><\/u><\/b><\/p>\n


2. RAC
\n<\/span><\/span>\uc774\ub77c\ub3c4<\/span> <\/span>\ud55c\ucabd<\/span> instance
\n<\/span>\uc5d0\ub9cc<\/span> <\/span>\uc801\uc6a9<\/span> <\/span>\uac00\ub2a5\ud568<\/span>.<\/span><\/u><\/b><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc5b4\uc81c\ubc24\uc5d0 \uac1c\ubc1c\uc790\uac00 \uc62c\ub798\uac78\ub9ac\ub294 \uc791\uc5c5\uc774 \uc788\uc5b4\uc11c \ub3cc\ub9ac\uace0 \ud1f4\uadfc \ud588\ub2e4 \ub2e4\uc74c\ub0a0 \ucd9c\uadfc\ud574\uc11c \uc640\ubcf4\ub2c8 \uc798\ubabb\ub41c \uc870\uac74\uc73c\ub85c \uc798\ubabb\ub41c DML\uc774 \uc544\uc9c1\ub3c4 \uc548\ub05d\ub0ab\ub2e4.. \uac1c\ubc1c\uc790\ub294 \uc544\ubb34\ub807\uc9c0 \uc54a\uac8c X\ubc84\ud2bc\uc744 \ub20c\ub7ec \ud504\ub85c\uadf8\ub7a8\uc744 \uaecf\ub2e4. \uc5b4\ub5a4 \uc0c1\ud669\uc774 \ubc1c\uc0dd\ud560\uae4c.? \uadf8 \ud14c\uc774\ube14\uc758 Rollback\uc774 \uc774\ub904 \uc9c0\uba74\uc11c \uc791\uc5c5 \uc2dc\uac04 \ub9cc\ud07c Lock \ud604\uc0c1\uc73c\ub85c \uadf8 \ud14c\uc774\ube14\uc758 \uc11c\ube44\uc2a4\ub294 \ubd88\uac00 \ud558\ub2e4.. \uc544\ub798 \uc138\ud305\uc744 \ubbf8\ub9ac \ud574\ub193\uc73c\uba74 \uc774\ub54c \ubcf5\uad6c \uc2dc\uac04\uc744 \ube60\ub974\uac8c \ud560 \uc218 \uc788\ub2e4. _CLEANUP_ROLLBACK_ENTRIES \uac00 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[14],"tags":[49,50,51],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/343"}],"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=343"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/343\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=343"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}