\ub85c\uadf8\ubc84\ud37c(Log Buffer) \uc601\uc5ed\uc758 \ud29c\ub2dd<\/p>\n
<\/p>\n
<\/p>\n
– \uc0ac\uc6a9\uc790\ub4e4\uc774 \ub370\uc774\uce74\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c \ud6c4 INSERT, DELETE, UPDATE \uc791\uc5c5\uc744 \uc2e4\ud589\ud558\uba74 \ud2b8\ub79c\uc81d\uc158\uc5d0 \uc758\ud574 \ub9cc\ub4e4\uc5b4\uc9c4 \ubaa8\ub4e0 \ubcc0\uacbd \uc815\ubcf4(UPDATE\ubb38\uc774 \uc2e4\ud589\ub418\uc5c8\ub2e4\uba74 \ubcc0\uacbd \uc804 \ub370\uc774\ud0c0\uc640 \ubcc0\uacbd \ud6c4 \ub370\uc774\ud0c0) \uac00 \ub85c\uadf8 \ubc84\ud37c\uc5d0 \uc800\uc7a5\ub41c\ub2e4. \uadf8\ub7ec\ub098, \ub85c\uadf8\ubc84\ud37c \uc601\uc5ed\uc5d0\ub294 \uc0ac\uc6a9\uc790\uc758 \ubaa8\ub4e0 \ubcc0\uacbd\ub41c \ub370\uc774\ud0c0\ub97c \uc800\uc7a5\ud574 \ub458 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \uc774 \ub370\uc774\uce74\ub4e4\uc744 \uc601\uad6c\ud788 \uc800\uc7a5\ud558\uae30 \uc704\ud574 LGWR \uc5d0 \uc758\ud574 \ub85c\uadf8 \ud30c\uc77c\uc5d0 \uae30\ub85d\ud558\uac8c \ub41c\ub2e4.<\/p>\n
<\/p>\n
– \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c \uc601\uc5ed\uc740 \uc5ec\ub7ec \uba85\uc758 \uc0ac\uc6a9\uc790\uac00 \uac19\uc774 \uc0ac\uc6a9\ud558\ub294 \uacf5\uac04\uc774\uae30 \ub54c\ubb38\uc5d0 \ub108\ubb34 \ub9ce\uc740 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 \ub3d9\uc2dc\uc5d0 \ub9ce\uc740 \ubcc0\uacbd\ub41c \ub370\uc774\ud0c0\ub97c \uc800\uc7a5\ud558\ub824\uace0 \ud558\uba74 \uc11c\ubc84 \ud504\ub85c\uc138\uc11c \uac04\uc5d0 \uacb0\ud569(Contention)\uc774 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4. \ub610\ud55c \uc0ac\uc6a9\uc790\uc758 \ubcc0\uacbd\ub41c \uc815\ubcf4\ub97c \uc800\uc7a5\ud560 \ucda9\ubd84\ud55c \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c \uacf5\uac04\uc774 \uc5c6\ub2e4\uba74 \ubbf8\ucc98 \ubcc0\uacbd\ub41c \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uc9c0 \ubabb\ud558\uace0 Waiting \ud574\uc57c \ud558\ub294 \uacbd\uc6b0\ub3c4 \ubc1c\uc0dd\ud560 \uac83\uc774\ub2e4. \uc774\ub7ec\ud55c \ubb38\uc81c \ubc1c\uc0dd\uc2dc \uacb0\uad6d UPDATE, DELETE, INSERT \uc2dc\uc5d0 \uc88b\uc740 \uc131\ub2a5\uc744 \uae30\uacc4\ud560 \uc218 \uc5c6\ub2e4.<\/p>\n
<\/p>\n
– \uad00\ub828 \ud30c\ub77c\uba54\ud130 LOG_BUFFER \uc5d0 \uc758\ud574 \ub85c\uadf8 \ubc84\ud37c \uc601\uc5ed\uc758 \ud06c\uae30\uac00 \uacb0\uc815\ub41c\ub2e4. \uc774 \ud30c\ub77c\uba54\ud130\ub97c \uc124\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 Oracle Server\ub294 DB_BLOCK_SIZE \uc758 4\ubc30 \uac12\uc744 \uae30\ubcf8 \ub85c\uadf8\ubc84\ud37c \uc601\uc5ed\uc758 \ud06c\uae30\ub85c \ud560\ub2f9\ud55c\ub2e4.<\/p>\n
<\/p>\n
\u25a0 \ub85c\uadf8 \ubc84\ud37c \uce90\uc2dc \uc601\uc5ed\uc744 \ubcf4\ub2e4 \ud06c\uac8c \ud560\ub2f9\ud55c\ub2e4.<\/p>\n
1) V$SESSION_WAIT \uc790\ub8cc\uc0ac\uc804\uc744 \ucc38\uc870\ud558\uba74 \uc774 \uc601\uc5ed\uc5d0 \ub300\ud55c \ud29c\ub2dd\uc5ec\ubd80\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n
SQL>select sid , event , seconds_in_wait , state from v$session_wait where event = ‘log buffer space%’ ;<\/p>\n
SID EVENT SECOND_IN_WAIT STATE<\/p>\n
—- ——————– —————– ——–<\/p>\n
5 log buffer space 110 WAIT<\/p>\n
<\/p>\n
<= SECOND_IN_WAIT \uac12\uc774 \uacc4\uc18d \uc99d\uac00\ub418\ub294 \uac12\uc744 \ub098\ud0c0\ub0b4\uace0 STATE \uac12\uc774 ‘WAIT’\uc744 \ub098\ud0c0\ub0b4\uba74<\/p>\n
\ub85c\uadf8\ubc84\ud37c \uc601\uc5ed\uc774 \uc791\uc544\uc11c \uc11c\ub85c \ud504\ub85c\uc138\uc2a4 \uac04\uc5d0 \uacbd\ud569\uc774 \ubc1c\uc0dd\ud558\uace0 \uc788\uc74c\uc744 \uc758\ubbf8\ud55c\ub2e4.<\/p>\n
<\/p>\n
2) V$SYSSTAT \uc790\ub8cc\uc0ac\uc804\uc5d0\uc11c \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 \ub85c\uadf8 \uc815\ubcf4\ub97c \uc800\uc7a5\ud588\ub358 \ub85c\uadf8\ubc84\ud37c\uc758 \ube14\ub85d\uc218<\/p>\n
(Redo Entries) \uc640 \ub85c\uadf8 \ubc84\ud37c\uc758 \uacbd\ud569\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud55c \ub300\uae30\uc0c1\ud0dc\uc5d0\uc11c \ub2e4\uc2dc \ub85c\uadf8 \ubc84\ud37c \uacf5\uac04\uc744<\/p>\n
\ud560\ub2f9 \ubc1b\uc558\ub358 \ube14\ub85d\uc218(Redo Buffer Allocation Entries) \ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n
SQL> select name,value from v$sysstat where name in (‘redo buffer allocation retries’,’redo entries’) ;<\/p>\n
NAME VALUE<\/p>\n
—————————————<\/p>\n
redo entries 2010<\/p>\n
redo buffer allocation retries 15<\/p>\n
<= redo buffer allocation retries\uc758 \uac12\uc774 0 \uc774\uc5b4\uc57c \ud558\uace0 redo entries \uac12\uc758 1% \ubbf8\ub9cc\uc77c \ub54c \uc88b\uc740 \uc131\ub2a5 \uae30\ub300<\/p>\n
<= \uae30\uc900\uce58\uc5d0 \uc801\ud569\ud558\uc9c0 \uc54a\uc740 \uacb0\uacfc\uac00 \ub098\uc624\uba74 \ub9ac\ub450 \ub85c\uadf8 \uc601\uc5ed\uc774 \uc791\uc544\uc11c \ubc1c\uc0dd\ud55c \ubb38\uc81c\uc774\ubbc0\ub85c LOG_BUFFER \ud30c\ub77c\uba54\ud130 \uac12\uc744 \ub354 \ub192\uac8c \uc124\uc815\ud55c\ub2e4.<\/p>\n
<\/p>\n
<\/p>\n
\u25a0 \uc778\ub371\uc2a4 \uc0dd\uc131\uc2dc NOLOGGING \uc808\uc744 \uc801\uc6a9\ud55c\ub2e4.<\/p>\n
– \uc0ac\uc6a9\uc790\uac00 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \ub370\uc774\ud130\ub97c INSERT, DELETE, UPDATE \ud558\uba74 \ud2b8\ub79c\uc81d\uc158\uc5d0 \uc758\ud574 \ubc1c\uc0dd \ud55c \ubaa8\ub4e0 \ubcc0\uacbd\uc804, \ubcc0\uacbd \ud6c4 \uc815\ubcf4\uac00 \ub85c\uadf8 \ubc84\ud37c \uc601\uc5ed\uc5d0 \uc800\uc7a5\ub418\ub294\ub370 \uc774\ub7ec\ud55c \ubc29\ubc95\uc744 Logging Mode \ub77c \ud55c\ub2e4.<\/p>\n
TABLE, INDEX \ub97c \uc0dd\uc131\ud560 \ub54c NOLOGGING \ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 \uc0dd\uc131 \ud6c4 \ubc1c\uc0dd\ud558\ub294 \ubaa8\ub4e0 \ud2b8\ub79c\uc81d\uc158\uc758 \ub85c\uadf8 \uc815\ubcf4\uac00 \ub85c\uadf8 \ubc84\ud37c \uc601\uc5ed\uc5d0 \uc800\uc7a5\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n
<\/p>\n
– \ub9cc\uc57d \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\uac00 \ub2e4\ub978 \uc2dc\uc2a4\ud15c \ub610\ub294 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ubd80\ud130 \uc774\ub3d9\ub418\uc5c8\uac70\ub098 \uc5b8\uc81c\ub4e0\uc9c0 \ubcf5\uad6c \uac00\ub2a5\ud55c \ud14c\uc774\ube14\uc774\ub77c\uba74 LOGGING \ubaa8\ub4dc\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\ubcf4\ub2e4 NOLOGGING \ubaa8\ub4dc\ub85c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ub85c\uadf8 \ubc84\ud37c \uc601\uc5ed\uc744 \uc801\uac8c \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0 \ub85c\uadf8 \ubc84\ud37c \uc601\uc5ed\uc5d0 \ub300\ud55c \uacbd\ud569 \ud604\uc0c1\uc744 \ucd5c\uc18c\ud654 \ud560 \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n
– \uc778\ub371\uc2a4\ub294 \ud14c\uc774\ube14\uc744 \ud1b5\ud574 \uc5b8\uc81c\ub4e0\uc9c0 \ub9cc\ub4e4 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 NOLOGGING \ubaa8\ub4dc\ub85c \ub9cc\ub4dc\ub294 \uac83\uc774 \uc131\ub2a5\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub2e4<\/p>\n
<\/p>\n
SQL>create table emp10 (<\/p>\n
no number(5),<\/p>\n
name varchar2(10) )<\/p>\n
NOLOGGING ;<\/p>\n
SQL>alter table emp10 logging ;<\/p>\n
SQL>create index i_emp10 on emp10(no) nologging;<\/p>\n","protected":false},"excerpt":{"rendered":"
\ub85c\uadf8\ubc84\ud37c(Log Buffer) \uc601\uc5ed\uc758 \ud29c\ub2dd – \uc0ac\uc6a9\uc790\ub4e4\uc774 \ub370\uc774\uce74\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c \ud6c4 INSERT, DELETE, UPDATE \uc791\uc5c5\uc744 \uc2e4\ud589\ud558\uba74 \ud2b8\ub79c\uc81d\uc158\uc5d0 \uc758\ud574 \ub9cc\ub4e4\uc5b4\uc9c4 \ubaa8\ub4e0 \ubcc0\uacbd \uc815\ubcf4(UPDATE\ubb38\uc774 \uc2e4\ud589\ub418\uc5c8\ub2e4\uba74 \ubcc0\uacbd \uc804 \ub370\uc774\ud0c0\uc640 \ubcc0\uacbd \ud6c4 \ub370\uc774\ud0c0) \uac00 \ub85c\uadf8 \ubc84\ud37c\uc5d0 \uc800\uc7a5\ub41c\ub2e4. \uadf8\ub7ec\ub098, \ub85c\uadf8\ubc84\ud37c \uc601\uc5ed\uc5d0\ub294 \uc0ac\uc6a9\uc790\uc758 \ubaa8\ub4e0 \ubcc0\uacbd\ub41c \ub370\uc774\ud0c0\ub97c \uc800\uc7a5\ud574 \ub458 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \uc774 \ub370\uc774\uce74\ub4e4\uc744 \uc601\uad6c\ud788 \uc800\uc7a5\ud558\uae30 \uc704\ud574 LGWR \uc5d0 \uc758\ud574 \ub85c\uadf8 \ud30c\uc77c\uc5d0 […]<\/p>\n","protected":false},"author":1,"featured_media":2876,"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":[1066,1067],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Cover1.png?fit=1000%2C730","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3760"}],"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=3760"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3760\/revisions"}],"predecessor-version":[{"id":3762,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3760\/revisions\/3762"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2876"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3760"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}