{"id":442,"date":"2015-09-07T02:50:02","date_gmt":"2015-09-07T02:50:02","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=442"},"modified":"2015-09-07T02:50:02","modified_gmt":"2015-09-07T02:50:02","slug":"oracle-lock%ec%9d%98-%ec%9c%a0%ed%98%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=442","title":{"rendered":"Oracle LOCK\uc758 \uc720\ud615"},"content":{"rendered":"

LOCK<\/span>\uc758<\/span>
\n\uc720\ud615<\/span><\/span><\/p>\n

   <\/span>\ub370\uc774\ud0c0\uc758<\/span> concurrency<\/span>\ub97c<\/span> \ubcf4\uc7a5\ud558\uae30<\/span> \uc704\ud574<\/span>
\n\uc624\ub77c\ud074\uc740<\/span> lock<\/span>\uacfc<\/span> transaction<\/span>\uc744<\/span> \uc0ac\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

   Lock<\/span>\uc740<\/span> \uac19\uc740<\/span> \uc790\uc6d0\uc744<\/span> access<\/span>\ud558\ub294<\/span> \uc0ac\uc6a9\uc790\ub4e4<\/span> \uc0ac\uc774\uc5d0<\/span> \uc0c1\ud638\uac04\uc5d0<\/span> \ud574\ub97c<\/span> \ub07c\uce58\ub294<\/span> \uac83\uc744<\/span> \uc608\ubc29\ud558\uae30<\/span> \uc704\ud574\uc11c<\/span> <\/span>\uc0ac\uc6a9\ub418\ub294<\/span> <\/span>\uba54\uce74\ub2c8\uc998\uc774\ub2e4<\/span>.<\/span><\/p>\n

   Lock<\/span>\uc758<\/span> \uc885\ub958<\/span><\/span><\/p>\n

      –
\nExclusive : lock<\/span>\uc774<\/span> \uac78\ub9b0<\/span>
\n\uc790\uc6d0\uc758<\/span> \uacf5\uc720\ub97c<\/span> \ud5c8\uc6a9\ud558\uc9c0<\/span> \uc54a\ub294\ub2e4<\/span>.<\/span><\/p>\n

      –
\nShare : <\/span>\uc790\uc6d0\uc5d0<\/span> \ub300\ud574<\/span>
\n\uc218\ud589\ub418\ub294<\/span> \uba85\ub839\uc758<\/span> \uc720\ud615\uc5d0<\/span> \ub530\ub77c<\/span>
\nlock<\/span>\ub41c<\/span> \uc790\uc6d0\uc758<\/span>
\n\uacf5\uc720\ub418\ub294<\/span> \uac83\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

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

   <\/span>\uc624\ub77c\ud074\uc5d0\uc11c\uc758<\/span> Lock<\/span>\uc758<\/span> \uc77c\ubc18\uc801\uc778<\/span> \ubc94\uc8fc<\/span><\/span><\/p>\n

      –
\nData or DML (row locks TX and table locks TM) : <\/span>\ub3d9\uc2dc\uc5d0<\/span>
\n\ub2e4\uc911\uc758<\/span> \uc0ac\uc6a9\uc790<\/span>\uc5d0<\/span> <\/span>\uc758\ud574<\/span> access<\/span>\ub418\ub294<\/span> <\/span>\ud14c\uc774\ube14<\/span> <\/span>\ub370\uc774\ud0c0\uc758<\/span> <\/span>\ubcf4\ud638\ub97c<\/span> <\/span>\uc704\ud574<\/span> <\/span>\uc0ac\uc6a9\ub41c\ub2e4<\/span>.<\/span><\/p>\n

      –
\nDictionary or DDL(TD) : <\/span>\ud2b8\ub79c\uc7ad\uc158\uc5d0\uc11c<\/span> access<\/span>\ub418\ub294<\/span> \ud14c\uc774\ube14\uacfc<\/span> \uac19\uc740<\/span>
\nObject<\/span>\uc758<\/span> <\/span>\uc815\uc758\ub97c<\/span> <\/span>\ubcf4\ud638\ud558\uae30<\/span> <\/span>\uc704\ud574\uc11c<\/span> <\/span>\uc0ac\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

      –
\nInternal and Latches (RT, MR) : SGA <\/span>\uc601\uc5ed\uc5d0\uc11c\uc758<\/span>
\n\ub0b4\ubd80\uc801\uc778<\/span> \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc640<\/span> <\/span>\uba54\ubaa8\ub9ac<\/span> <\/span>\uad6c\uc870\ub97c<\/span> <\/span>\ubcf4\ud638\ud558\uae30<\/span> <\/span>\uc704\ud574<\/span> <\/span>\uc0ac\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

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

   1.
\nTABLE LOCKS<\/span><\/p>\n

      <\/span>\ud14c\uc774\ube14\uc758<\/span> \ud2b9\uc815\ud55c<\/span>
\nrow<\/span>\ub97c<\/span> \uc218\uc815\ud558\ub294<\/span>
\n\ubb38\uc7a5\uc740<\/span> \ud56d\uc0c1<\/span> \uadf8\ub7ec\ud55c<\/span> row<\/span>\uc5d0<\/span>
\n\ub300\ud574<\/span> exclusive row<\/span> lock<\/span>\uc744<\/span> <\/span>\ud68d\ub4dd\ud558\uace0<\/span> <\/span>\ud14c\uc774\ube14<\/span> lock<\/span>\uc744<\/span> <\/span>\uc804\uc720\ud55c\ub2e4<\/span>.<\/span><\/p>\n

      (1)
\nRow Share Table Locks (RS)<\/span><\/p>\n

         
\n– row<\/span>\ub97c<\/span> lock <\/span>\uc2dc\ud0a4\uace0<\/span> lock<\/span>\ub41c<\/span>
\n\ud14c\uc774\ube14\uc744<\/span> UPDATE <\/span>\ud560<\/span> \ubaa9\uc801\uc774\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ubaa8\ub4e0<\/span> row<\/span>\ub97c<\/span> SELECT <\/span>\ud558\ub824\ub294<\/span>
\n\ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span> \ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ub3d9\uc77c<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span> lock <\/span>\ub418\uc9c0<\/span> \uc54a\uc740<\/span> row<\/span>\ub97c<\/span> INSERT, UPDATE,
\nDELETE <\/span>\ud558\ub294<\/span> \ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ud14c\uc774\ube14\uc5d0<\/span> \ub300\ud55c<\/span> ROW SHARE, ROW EXCLUSIVE, SHARE, SHARE ROW<\/span> EXCLUSIVE lock<\/span>\uc744<\/span> <\/span>\ud68d\ub4dd\ud558\ub824\ub294<\/span> <\/span>\ub2e4\ub978<\/span> <\/span>\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– EXCLUSIVE <\/span>\ubaa8\ub4dc\uc5d0\uc11c\uc758<\/span> \ud14c\uc774\ube14<\/span> locking<\/span>\uc73c\ub85c\ubd80\ud130<\/span> \ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span> \uc608\ubc29\ud55c\ub2e4<\/span>.<\/span><\/p>\n


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

      (2)
\nRow Exclusive Table Locks (RX)<\/span><\/p>\n

         
\n– row<\/span>\ub97c<\/span> lock <\/span>\uc2dc\ud0a4\uace0<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span> row<\/span>\ub97c<\/span> \ubcc0\ud654\uc2dc\ud0a8\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ubaa8\ub4e0<\/span> row<\/span>\ub97c<\/span> SELECT <\/span>\ud558\ub824\ub294<\/span>
\n\ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span> \ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ub3d9\uc77c<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span> lock <\/span>\ub418\uc9c0<\/span> \uc54a\uc740<\/span> row<\/span>\ub97c<\/span> INSERT, UPDATE,
\nDELETE <\/span>\ud558\ub294<\/span> \ub2e4\ub978<\/span> <\/span>\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ud14c\uc774\ube14\uc5d0<\/span> \ub300\ud55c<\/span> ROW SHARE, ROW EXCLUSIVE lock<\/span>\uc744<\/span>
\n\ud68d\ub4dd\ud558\ub824\ub294<\/span> \ub2e4\ub978<\/span> <\/span>\ud2b8\ub79c\uc7ad\uc158\uc744<\/span>
\n<\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– SHARE, EXCLUSIVE, SHARE ROW EXCLUSIVE <\/span>\ubaa8\ub4dc\uc5d0\uc11c\uc758<\/span>
\n\ud14c\uc774\ube14<\/span> locking<\/span>\uc73c<\/span>\ub85c\ubd80\ud130<\/span> <\/span>\ub2e4\ub978<\/span>
\n<\/span>\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\uc608\ubc29\ud55c\ub2e4<\/span>.<\/span><\/p>\n


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

      (3)
\nShare Table Locks (S)<\/span><\/p>\n

         
\n– <\/span>\ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span>
\n\uc81c\uacf5\ud558\uc9c0<\/span> \uc54a\ub294<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span> row<\/span>\ub97c<\/span> INSERT, UPDATE, DELETE<\/span> <\/span>\ud558\ub294<\/span> <\/span>\uac83\uc774<\/span> SHARE lock<\/span>\uc744<\/span> <\/span>\ud640\ub529\ud55c\ub2e4<\/span>.<\/span><\/p>\n

          –
\n<\/span>\ub3d9\uc77c<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span>
\n\uc9c0\uc815\ub41c<\/span> row<\/span>\ub97c<\/span> QUERY <\/span>\ub610\ub294<\/span>
\nLOCK <\/span>\ud558\ub824\ub294<\/span> \ub2e4\ub978<\/span>
\n\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ud14c\uc774\ube14\uc5d0<\/span> \ub300\ud574<\/span>
\n\ub354<\/span> \ub098\uc544\uac00<\/span> SHARE lock<\/span>\uc744<\/span> \uc5bb\uc73c\ub824\ub294<\/span> \ub2e4\ub978<\/span>
\n\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> \ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– EXCLUSIVE <\/span>\ub610\ub294<\/span>
\nSHARE ROW EXCLUSIVE <\/span>\ubaa8\ub4dc\ub85c<\/span> \ud14c\uc774\ube14\uc744<\/span> locking <\/span>\ud558\ub294<\/span> \uac83\uc73c\ub85c\ubd80\ud130<\/span> <\/span>\ub2e4\ub978<\/span>
\n<\/span>\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ubcf4\ud638\ud55c\ub2e4<\/span>.<\/span><\/p>\n


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

      (4)
\nShare Row Exclusive Table Locks (SRX)<\/span><\/p>\n

         
\n– <\/span>\ud14c\uc774\ube14\uc5d0<\/span> row<\/span>\ub97c<\/span> INSERT, UPDATE, DELETE <\/span>\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ub3d9\uc77c<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span>
\n\uc9c0\uc815\ub41c<\/span> row<\/span>\ub97c<\/span> QUERY <\/span>\ub610\ub294<\/span>
\nLOCK <\/span>\ud558\ub824\ub294<\/span> \ub2e4\ub978<\/span>
\n\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– SHARE, EXCLUSIVE <\/span>\ub610\ub294<\/span>
\nSHARE ROW EXCLUSIVE <\/span>\ubaa8\ub4dc\ub85c<\/span> \ud14c\uc774\ube14\uc744<\/span> locking<\/span> <\/span>\ud558\ub294<\/span> <\/span>\uac83\uc73c\ub85c<\/span>
\n<\/span>\ubd80\ud130<\/span> <\/span>\ub2e4\ub978<\/span> <\/span>\ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ubcf4\ud638\ud55c\ub2e4<\/span>.<\/span><\/p>\n


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

      (5)
\nExclusive Table Locks (S)<\/span><\/p>\n

         
\n– <\/span>\ud14c\uc774\ube14\uc5d0<\/span> row<\/span>\ub97c<\/span> INSERT, UPDATE, DELETE <\/span>\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\ub3d9\uc77c<\/span> \ud14c\uc774\ube14\uc5d0\uc11c<\/span>
\n\uc9c0\uc815\ub41c<\/span> row<\/span>\ub97c<\/span> QUERY<\/span>\ud558\ub294<\/span> \uac83\uc5d0<\/span>
\n\ub300\ud574\uc11c\ub9cc<\/span> \ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span> <\/span>\ud5c8\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/p>\n

         
\n– <\/span>\uc5b4\ub5a0\ud55c<\/span> lock <\/span>\ubb38\uc7a5\uc744<\/span> \ub0b4\ub9ac\ub294<\/span> \uac83\uc73c\ub85c\ubd80\ud130<\/span> \ub2e4\ub978<\/span> \ud2b8\ub79c\uc7ad\uc158\uc744<\/span> \ubcf4\ud638\ud55c\ub2e4<\/span>.<\/span><\/p>\n

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

   2.
\nDICTIONARY LOCKS<\/span><\/p>\n

     
\nDictionary lock<\/span>\uc740<\/span>
\nObject<\/span>\uc5d0<\/span> \ub300\ud55c<\/span> DDL <\/span>\uba85\ub839\uc774<\/span> \uc218\ud589\ub418\ub294<\/span>
\n\ub3d9\uc548<\/span> Object<\/span>\uc758<\/span>
\n\uc815\uc758\ub97c<\/span> <\/span>\ubcf4\ud638\ud55c\ub2e4<\/span>.<\/span><\/p>\n

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

   3.
\nINTERNAL LOCKS <\/span>\uacfc<\/span> LATCHES<\/span><\/p>\n

     
\nLatches <\/span>\uc640<\/span> Internal lock<\/span>\uc740<\/span> \uba54\ubaa8\ub9ac<\/span> \uad6c\uc870\ub97c<\/span>
\n\ubcf4\ud638\ud558\uae30<\/span> \uc704\ud55c<\/span> \uba54\uce74\ub2c8\uc998\uc774\ub2e4<\/span>.<\/span><\/p>\n

      –
\nLatches <\/span>\ub294<\/span> SGA <\/span>\uc601\uc5ed\uc5d0<\/span> \uc788\ub294<\/span>
\nshared data structure<\/span>\ub97c<\/span> \ubcf4\ud638\ud558\uae30<\/span> \uc704\ud55c <\/span>low-level <\/span>\uc5f0\uc18d<\/span> <\/span>\uba54\uce74\ub2c8\uc998\uc774\ub2e4<\/span>.<\/span><\/p>\n

      –
\nInternal lock<\/span>\uc740<\/span> data dictionary
\nentry<\/span>\ub97c<\/span> \ubcf4\ud638\ud558\uace0<\/span> database file,<\/span>  tablespace, rollback segment<\/span>\ub97c<\/span> lock<\/span>\ud55c\ub2e4<\/span>.<\/span><\/p>\n<\/p>\n

     
\nLatches <\/span>\uc640<\/span> Internal locks<\/span>\ub294<\/span> \ub370\uc774\ud0c0\ubca0\uc774\uc2a4<\/span> \uc0ac\uc6a9\uc790\uc5d0<\/span>
\n\uc758\ud574<\/span> \ucee8\ud2b8\ub864<\/span> \ub420<\/span> \uc218<\/span> \uc5c6\ub2e4<\/span>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

LOCK\uc758 \uc720\ud615    \ub370\uc774\ud0c0\uc758 concurrency\ub97c \ubcf4\uc7a5\ud558\uae30 \uc704\ud574 \uc624\ub77c\ud074\uc740 lock\uacfc transaction\uc744 \uc0ac\uc6a9\ud55c\ub2e4.    Lock\uc740 \uac19\uc740 \uc790\uc6d0\uc744 access\ud558\ub294 \uc0ac\uc6a9\uc790\ub4e4 \uc0ac\uc774\uc5d0 \uc0c1\ud638\uac04\uc5d0 \ud574\ub97c \ub07c\uce58\ub294 \uac83\uc744 \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9\ub418\ub294 \uba54\uce74\ub2c8\uc998\uc774\ub2e4.    Lock\uc758 \uc885\ub958       – Exclusive : lock\uc774 \uac78\ub9b0 \uc790\uc6d0\uc758 \uacf5\uc720\ub97c \ud5c8\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4.       – Share : \uc790\uc6d0\uc5d0 \ub300\ud574 \uc218\ud589\ub418\ub294 \uba85\ub839\uc758 \uc720\ud615\uc5d0 \ub530\ub77c lock\ub41c \uc790\uc6d0\uc758 \uacf5\uc720\ub418\ub294 \uac83\uc744 \ud5c8\uc6a9\ud55c\ub2e4.      \uc624\ub77c\ud074\uc5d0\uc11c\uc758 […]<\/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":[11],"tags":[152],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/442"}],"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=442"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/442\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}