<\/p>\n
Enqueue Lock \ub300\uae30 \ud604\uc0c1 \uc0ac\ub840 \ubaa8\uc74c<\/p>\n
<\/p>\n
<\/p>\n
– \uc774 \uc774\uc678\uc758 \uc5ec\ub7ec \uac00\uc9c0 \uacbd\uc6b0\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n
– \uc790\uc8fc \ubaa9\uaca9\ub418\ub294 \uba87 \uac00\uc9c0 \uc0ac\ub840 \uc704\uc8fc\ub85c \uc815\ub9ac <\/p>\n
<\/p>\n
<\/p>\n
Enq : US<\/p>\n
<\/p>\n
Undo Segments\ub97c Online \/ Offline \uc2dc\ud0a4\uae30 \uc704\ud574 \ud68d\ub4dd\ud558\ub294 \ub77d<\/p>\n
<\/p>\n
\ubc1c\uc0dd\uc6d0\uc778 : Automatic Undo Management\ud658\uacbd\uc5d0\uc11c \uc77c\uc2dc\uc801\uc73c\ub85c \ub300\ub7c9\uc758 \ud2b8\ub79c\uc7ad\uc158\uc774 \ubab0\ub9ac\uba74\uc11c \uacfc\ub3c4\ud558\uac8c Undo Segment\uac00 Online\ub418\uba74\uc11c \uacbd\ud569\uc774 \ubc1c\uc0dd<\/p>\n
<\/p>\n
\ud655\uc778\ubc29\ubc95 : session_wait \ubdf0\uc758 Enq : US \uacbd\ud569 \ubaa9\uaca9 , row cache lock (P1=3)\ub3d9\uc77c \uc2dc\uac04\ub300 Alert Log \ud30c\uc77c\uc5d0 Undo Segment Online \uba54\uc2dc\uc9c0 \ub2e4\ub7c9 \ubc1c\uc0dd<\/p>\n
<\/p>\n
\uc870\uce58\ubc29\ubc95 : \uc0ac\uc6a9 \uc548\ud558\ub294(Idle) Undo Segment\uc5d0 \ub300\ud558\uc5ec SMON\uc774 Offline \uc2dc\ud0a4\uc9c0 \ubabb\ud558\uac8c \ud568<\/p>\n
<\/p>\n
event=\u201910511 trace name context forever, level 2\u201d \ucd94\uac00<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
Enq : SQ<\/p>\n
<\/p>\n
\uc2dc\ud000\uc2a4 \uc0ac\uc6a9\uc2dc \ud68d\ub4dd \ud558\ub294 \ub77d<\/p>\n
<\/p>\n
\ubc1c\uc0dd\uc6d0\uc778 : Sequence\ub97c \uc0ac\uc6a9\ud568\uc5d0 \uc788\uc5b4\uc11c Cache \uc635\uc158 \uac12\uc774 \uc791\uac70\ub098 , \uc5c6\ub294 \uc2dc\ud000\uc2a4\uc5d0 \ub300\ud55c \uc778\ucd9c \uc694\uccad\uc774 \uacfc\ub3c4\ud560 \uacbd\uc6b0 \ubc1c\uc0dd<\/p>\n
<\/p>\n
\ud655\uc778\ubc29\ubc95 : session_wait \ubdf0\uc758 Enq : SQ \uacbd\ud569 \ubaa9\uaca9 , row cache lock(P1=13)\ubc1c\uc0dd<\/p>\n
<\/p>\n
\uc870\uce58\ubc29\ubc95 : Enq : SQ \uacbd\ud569 \uba54\uc2dc\uc9c0\uc758 P2\uac12\uc744 \uc774\uc6a9\ud558\uc5ec Object\ub97c \ud655\uc778 \ud6c4 Cache\uac12\uc744 \uc99d\uac00<\/p>\n
<\/p>\n
Object\uba85\uc774 AUDSES$ \uc778 \uac83\uc740 \uc138\uc158 \ub85c\uadf8 \uc778\uc2dc \uc0ac\uc6a9\ud558\ub294 \uc2dc\ud000\uc2a4 \uc784<\/p>\n
Default \uac12\uc774 200\uc774\ub098 1000\uc774\ub098 2000 \uc815\ub3c4\ub85c \ubcc0\uacbd\ud574 \uc8fc\uba74 \uc870\uce58 \uac00\ub2a5<\/p>\n
<\/p>\n
<\/p>\n
Enq : TM(S) or TM(SSX)<\/p>\n
<\/p>\n
\ubc1c\uc0dd\uc6d0\uc778 : Parent – Child \uad00\uacc4\uac00 \uc788\ub294 \ud14c\uc774\ube14 \uad00\uacc4\uc5d0\uc11c Child \ud14c\uc774\ube14\uc758 FK \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4 \ubd80\uc7ac\ub85c \ubd80\ubaa8\ud14c\uc774\ube14\uc758 PK \ub610\ub294 row\uac00 \ubcc0\uacbd \ub420 \uacbd\uc6b0 Child \ud14c\uc774\ube14\uc5d0 \ub300\ud558\uc5ec TM(S) , TM(SSX) \ub77d \ub300\uae30 \uc694\uccad \ubc1c\uc0dd<\/p>\n
<\/p>\n
\ud655\uc778\ubc29\ubc95 : session_wait \ubdf0\uc758 Enq : TM \uacbd\ud569 \ubaa9\uaca9<\/p>\n
<\/p>\n
\uc870\uce58\ubc29\ubc95 : Child \ud14c\uc774\ube14\uc758 FK \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4 \uc0dd\uc131<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
Enq : TX(S)<\/p>\n
<\/p>\n
\ubc1c\uc0dd\uc6d0\uc778 : Unique Constraint \ub610\ub294 Unique Index\uac00 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc5d0 \ub3d9\uc2dc Insert \ubc1c\uc0dd \uc2dc \uc911\ubcf5 \uac12\uc774 \ub4e4\uc5b4 \uac08 \uacbd\uc6b0 . ITL\uc758 maxtrans\uc758 \uac12\uc744 \ucd08\uacfc \ud558\uac70\ub098 \ube14\ub85d\ub0b4\uc758 \uc5ec\uc720 \uacf5\uac04\uc774 \ubd80\uc871\ud55c \uacbd\uc6b0(PCTFREE\uac00 \ub108\ubb34 \uc801\uc740 \uacbd\uc6b0) . \uc778\ub371\uc2a4 \ub9ac\ud504 \ub178\ub4dc\uac00 Split \ub418\ub294 \uacbd\uc6b0 , Bitmap index\ub97c \uc0ac\uc6a9\ud558\ub294 \uacf3\uc5d0 \ub300\ub7c9 DML \ubc1c\uc0dd \uc2dc<\/p>\n
\ubd84\uc0b0 \ud2b8\ub79c\uc7ad\uc158 \ud658\uacbd\uc5d0\uc11c \ub2e4\ub978 \uc138\uc158\uc5d0\uc11c \uc77d\uace0 \uc788\ub294 \ub3d9\uc2dc\uc5d0 \uc77d\uace0\uc790 \ud558\ub294 \uacbd\uc6b0<\/p>\n
<\/p>\n
\ud655\uc778\ubc29\ubc95 : session_wait \ubdf0\uc758 Enq : TX(S) \uacbd\ud569 \ubaa9\uaca9<\/p>\n
<\/p>\n
\uc870\uce58\ubc29\ubc95 : \uc911\ubcf5 \uac12\uc774 \ub4e4\uc5b4\uac00\uc9c0 \uc54a\ub3c4\ub85d APP\uc5d0\uc11c\uc758 \uc815\ucc45 \ucd94\uac00\ub098, \uc2dc\ud000\uc2a4 \uc0ac\uc6a9\uac00\ub2a5 \ud55c \uceec\ub7fc\uc77c \uacbd\uc6b0 \uc2dc\ud000\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \uad8c\uc7a5<\/p>\n
ITL \uc5d4\ud2b8\ub9ac \ubd80\uc871\uc77c \uacbd\uc6b0 PCTFREE \uacf5\uac04\uc744 \uc801\uc808\ud788 \uc124\uc815.<\/p>\n
\ubd84\uc0b0 \ud2b8\ub79c\uc7ad\uc158\uc758 \uacbd\uc6b0 \uc0ac\uc6a9\uc774 \ub05d\ub098\uba74 commit\uc774\ub098 rollback\uc744 \uc801\uc808\ud788 \uc0ac\uc6a9\ud574 \uc8fc\uace0 \uadf8\ub807\uc9c0 \ubabb\ud55c \uc138\uc158\uc5d0 \ub300\ud574\uc11c\ub294 dba_2pc_pending \ubdf0\ub97c \uc774\uc6a9\ud558\uc5ec \uc138\uc158\uc5d0 \ub300\ud55c \uc870\uce58 \ud544\uc694<\/p>\n
<\/p>\n
<\/p>\n
Enq : SS<\/p>\n
<\/p>\n
SS : Sort Segment<\/p>\n
<\/p>\n
\ubc1c\uc0dd\uc6d0\uc778 : Startup \uc774\ud6c4 Temporary Tablespace\uc5d0 \uc0dd\uc131\ub41c Sort Segment Clean up\uc5d0 \uc624\ub79c \uc2dc\uac04\uc774 \uc18c\uc694. Instance Crash \/ Shutdown abort \uc774\ud6c4 Transaction Recovery \ud558\ub294\ub370 \uc774\ub54c \ub2e4\ub978 \uc138\uc158\ub4e4\uc774 Sort Segement\uc5d0 \ub300\ud55c SS \uc774\ubca4\ud2b8 \ub300\uae30.<\/p>\n
<\/p>\n
\ud655\uc778\ubc29\ubc95 : session_wait \ubdf0\uc758 Enq : SS \uacbd\ud569 \ubaa9\uaca9<\/p>\n
<\/p>\n
\uc870\uce58\ubc29\ubc95 : \ub300\uae30\ub97c \uacaa\ub294 \uc720\uc800\uc758 Temporary Tablespace \ubcc0\uacbd. event = \u201c10513 trace name context forever, level 2\u201d \uc774\ubca4\ud2b8\ub97c \ucd94\uac00 \ud568\uc73c\ub85c SMON\uc774 \ud2b8\ub79c\uc7ad\uc158 \ub9ac\ucee4\ubc84\ub9ac\ub97c \uc218\ud589\ud558\uc9c0 \ubabb\ud558\uac8c \ud568<\/p>\n
\uc774\ud6c4 \uc138\uc158\uc5d0\uc11c Temporary Segment\ub97c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub97c \uc218\ud589 \ud6c4 \uc815\uc0c1\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \uac83\uc744 \ud655\uc778 \ud6c4 Event Off \uc2dc\ud0b4<\/p>\n
oradebug event 10513 trace name context off<\/p>\n
<\/p>\n
Enq : WL<\/p>\n
<\/p>\n
WL : Being Written Redo Log<\/p>\n
<\/p>\n
\ubc1c\uc0dd\uc6d0\uc778 : \uc790\uc8fc \ubaa9\uaca9\uc774 \ub418\ub294 \uc774\ubca4\ud2b8\ub294 \uc544\ub2c8\uae30\uc5d0 \ubc1c\uc0dd\uc6d0\uc778 \ubcf4\ub2e4\ub294 \uc0ac\uc6a9\uc2dc\uae30\ub97c \uc801\uc5b4 \ubd04<\/p>\n
<\/p>\n
When adding a new member to a redo log group.<\/p>\n
When removing a logfile from a redo log group.<\/p>\n
When clearing a logfile’s contents.<\/p>\n
When renaming a logfile.<\/p>\n
When archiving the logfile..<\/p>\n","protected":false},"excerpt":{"rendered":"
Enqueue Lock \ub300\uae30 \ud604\uc0c1 \uc0ac\ub840 \ubaa8\uc74c – \uc774 \uc774\uc678\uc758 \uc5ec\ub7ec \uac00\uc9c0 \uacbd\uc6b0\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. – \uc790\uc8fc \ubaa9\uaca9\ub418\ub294 \uba87 \uac00\uc9c0 \uc0ac\ub840 \uc704\uc8fc\ub85c \uc815\ub9ac Enq : US Undo Segments\ub97c Online \/ Offline \uc2dc\ud0a4\uae30 \uc704\ud574 \ud68d\ub4dd\ud558\ub294 \ub77d \ubc1c\uc0dd\uc6d0\uc778 : Automatic Undo Management\ud658\uacbd\uc5d0\uc11c \uc77c\uc2dc\uc801\uc73c\ub85c \ub300\ub7c9\uc758 \ud2b8\ub79c\uc7ad\uc158\uc774 \ubab0\ub9ac\uba74\uc11c \uacfc\ub3c4\ud558\uac8c Undo Segment\uac00 Online\ub418\uba74\uc11c \uacbd\ud569\uc774 \ubc1c\uc0dd […]<\/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":[124,125,71,126],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/404"}],"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=404"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/404\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=404"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}