Library cache lock\uacfc library cache pin \uad00\ub828 \uc124\uba85\uc740 \ubc11\uc5d0 \uc5ec\ub7ec\ubc88 \uc5b8\uae09\uc744 \ud558\uc600\uc73c\ubbc0\ub85c ..<\/p>\n
<\/p>\n
\uc5ec\uae30\uc11c\ub294 \ub2e8\uc21c\ud788 Library cache lock\uacfc library cache pin\uc774 \uc77c\uc5b4\ub0a0 \uacbd\uc6b0 \ubaa8\ub2c8\ud130\ub9c1 \ud558\ub294 \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uc558\ub2e4.<\/p>\n
<\/p>\n
dba_kgllock : library cache \uad00\ub828 lock , pin Holder, waiter \uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub2e4.<\/p>\n
x$kglob : library cache \uc5d0 Cache \ub418\uc5b4 \uc788\ub294 Object\uc5d0 \ub300\ud55c \uc815\ubcf4 \ud655\uc778 ( v$db_object_cache\uc758 \uae30\ubcf8 \ud14c\uc774\ube14 )<\/p>\n
v$session : \uc138\uc158 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ubdf0<\/p>\n
<\/p>\n
\uae30\ubcf8\uc774 \ub418\ub294 \ud14c\uc774\ube14\uc740 dba_kgllock \ud14c\uc774\ube14\uc774\ub2e4.<\/p>\n
\uc774 \ud14c\uc774\ube14\uc744 \uc870\ud68c \ud568\uc73c\ub85c\uc368 \ud604\uc7ac library cache lock\uacfc Pin \uc5d0 \ub300\ud55c lock \uc815\ubcf4\ub97c \ud655\uc778 \ud574 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n
SELECT \/*+ ORDERED *\/<\/p>\n
lo.kglnaobj AS object ,<\/p>\n
decode( ll.kgllkmod , 0 , ‘none’ , 1 , ‘null’ , 2 , ‘share’ , 3 , ‘exclusive’ , ll.kgllkmod ) AS CurrentLockMode ,<\/p>\n
decode( ll.kgllkreq , 0 , ‘none’ , 1 , ‘null’ , 2 , ‘share’ , 3 , ‘exclusive’ , ll.kgllkreq ) AS RequestLockMode ,<\/p>\n
ll.kgllktype Type ,<\/p>\n
s.schemaname HolderSchema,<\/p>\n
s.program HolderProgram,<\/p>\n
s.module HolderModule<\/p>\n
FROM dba_kgllock ll ,<\/p>\n
x$kglob lo ,<\/p>\n
v$session s<\/p>\n
WHERE ll.kgllkhdl = lo.kglhdadr<\/p>\n
AND ll.kgllkuse = s.saddr ;<\/p>\n
<\/p>\n
<\/p>\n
\uc704\uc758 \ucffc\ub9ac\ub294 \ub2e8\uc21c\ud788 \ud604\uc7ac library cache lock \uc774\ub098 pin \uad00\ub828 Holder\ub098 waiter\uc815\ubcf4\ub97c \uc870\ud68c \ud558\ub294 \ucffc\ub9ac\uc774\ub2e4.<\/p>\n
lock \uc778\uc9c0 pin \uc778\uc9c0 \ud655\uc778\ud574 \ubcfc \ub824\uba74 ll.kgllktype \uceec\ub7fc\uac12\uc744 \ud655\uc778\ud574 \ubcf4\uba74 \ub428.<\/p>\n
<\/p>\n
\uc2e4\uc81c Wait\uc774 \ubc1c\uc0dd\ud558\ub294 \uc2dc\uc810\uc5d0\uc11c\ub294 v$session_wait\ubdf0\ub97c \uc870\ud68c \ud558\ub2e4\uac00 P1RAW\uac12\uc744 \uac00\uc9c0\uace0 x$kglob \ubdf0\uc758 kglhdadr\uacfc \uc870\ud68c\ud574 \ubcf4\uba74 \ub41c\ub2e4.<\/p>\n
<\/p>\n
\uc544\ub2c8\uba74 dba_kgllock \ubdf0\uc5d0\uc11c waiter\uac00 0 \uc774 \uc544\ub2cc\uac83\uc744 \uc870\ud68c \ud568\uc73c\ub85c\uc368 \uac19\uc740 \uc5ed\ud65c\uc744 \ud560 \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n
v$session_wait\uc744 \uc870\ud68c \ud558\ub2e4\uac00 P1RAW\uac12\uc744 \uc774\uc6a9\ud558\uc5ec \ud655\uc778 \ud558\ub294 \ubc29\ubc95<\/p>\n
SELECT kglnaown , kglnaobj<\/p>\n
FROM x$kglob<\/p>\n
WHERE kglhdadr = ‘P1RAW\uac12 ‘ ;<\/p>\n
<\/p>\n
dba_kgllock\ub97c \uc870\ud68c \ud558\uba74\uc11c lock , pin \uad00\ub828 \ubaa8\ub2c8\ud130\ub9c1<\/p>\n
<\/p>\n
SELECT \/*+ ORDERED *\/<\/p>\n
lo.kglnaobj AS object ,<\/p>\n
decode( ll.kgllkmod , 0 , ‘none’ , 1 , ‘null’ , 2 , ‘share’ , 3 , ‘exclusive’ , ll.kgllkmod ) AS CurrentLockMode ,<\/p>\n
decode( ll.kgllkreq , 0 , ‘none’ , 1 , ‘null’ , 2 , ‘share’ , 3 , ‘exclusive’ , ll.kgllkreq ) AS RequestLockMode ,<\/p>\n
ll.kgllktype Type ,<\/p>\n
s.schemaname HolderSchema,<\/p>\n
s.program HolderProgram,<\/p>\n
s.module HolderModule<\/p>\n
FROM dba_kgllock ll ,<\/p>\n
x$kglob lo ,<\/p>\n
v$session s<\/p>\n
WHERE ll.kgllkhdl = lo.kglhdadr<\/p>\n
AND ll.kgllkuse = s.saddr<\/p>\n
AND ll.kgllkreq > 0 ;<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Library cache lock\uacfc library cache pin \uad00\ub828 \uc124\uba85\uc740 \ubc11\uc5d0 \uc5ec\ub7ec\ubc88 \uc5b8\uae09\uc744 \ud558\uc600\uc73c\ubbc0\ub85c .. \uc5ec\uae30\uc11c\ub294 \ub2e8\uc21c\ud788 Library cache lock\uacfc library cache pin\uc774 \uc77c\uc5b4\ub0a0 \uacbd\uc6b0 \ubaa8\ub2c8\ud130\ub9c1 \ud558\ub294 \ucffc\ub9ac\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uc558\ub2e4. dba_kgllock : library cache \uad00\ub828 lock , pin Holder, waiter \uc815\ubcf4\ub97c \ud655\uc778 \ud560 \uc218 \uc788\ub2e4. x$kglob : library cache \uc5d0 Cache \ub418\uc5b4 \uc788\ub294 Object\uc5d0 \ub300\ud55c […]<\/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":[119,120,121],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/401"}],"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=401"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/401\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=401"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}