{"id":2634,"date":"2018-02-02T16:14:30","date_gmt":"2018-02-02T07:14:30","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2634"},"modified":"2018-02-02T16:15:44","modified_gmt":"2018-02-02T07:15:44","slug":"log-file-sync-%ec%9d%b4%eb%b2%a4%ed%8a%b8-%ec%9d%b4%ec%8a%88-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2634","title":{"rendered":"Log File Sync \uc774\ubca4\ud2b8 \uc774\uc288 \uc815\ub9ac"},"content":{"rendered":"

Oracle Wait Event\ub97c \ubcf4\ub2e4 \ubcf4\uba74 log file sync \uc774\ubca4\ud2b8\uac00 \ub9ce\uc774 \ubc1c\uc0dd \ud569\ub2c8\ub2e4. \ub300\ud45c\uc801\uc778 \uacbd\uc6b0\uac00 \uba87 \uac1c \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

1.\u00a0 Redo Log File Size\ub97c \uc99d\uac00\uc2dc\ud0b4\uc73c\ub85c Log Switch \uc218\uce58 \uac10\uc18c<\/span><\/b><\/p>\n

\u00a0\u00a0\u00a0\u00a0 -> I\/O \uac10\uc18c\ub85c \uc131\ub2a5\uc5d0 \uc774\uc810<\/b><\/p>\n

\u00a0<\/strong><\/p>\n

2. SYS.AUDSES$ \uc2dc\ud000\uc2a4\uc758 CACHE \uac12\uc744 \ud06c\uac8c \uc870\uc815\ud558\uc5ec \ud574\uacb0<\/p>\n

->\u00a0 \ub3d9\uc2dc \uc811\uc18d \uacfc\ub2e4 \uc2dc\uc810\uc5d0 Log File Sync \ub300\uae30\uc774\ubca4\ud2b8\uc5d0 \uc758\ud55c Active Session\uc758 \uae09\uc99d \ud604\uc0c1 \ubc1c\uc0dd<\/b> \ud558\ub294 \uacbd\uc6b0<\/p>\n

SYS.AUDSES$ \uc2dc\ud000\uc2a4\uc758 CACHE Size\uac00 \uc791\uc544\uc11c SYS.SEQ$ \ub97c UPDATE\ud558\ub294 \ub0b4\ubd80 SQL \uc218\ud589 \ubc0f<\/p>\n

COMMIT \uacfc\ub2e4 \ubc1c\uc0dd\uc73c\ub85c \uc778\ud55c \uc9c0\uc5f0 \ubc1c\uc0dd<\/p>\n

SQL> alter sequence sys.audses$ cache 10000;<\/p>\n

 <\/p>\n

3. REDO Log \ud30c\uc77c\uc740 \ub370\uc774\ud130 \ud30c\uc77c\uc774\ub098 TEMP \ud30c\uc77c, SYSTEM \ud30c\uc77c\uacfc \ub2e4\ub978 \ub514\uc2a4\ud06c\uc5d0 \ubc30\uce58\ud558\uc5ec I\/O \ubd84\uc0b0<\/span><\/p>\n

 <\/p>\n

4. O\/S I\/O \uad00\ub828 Parameter \uc218\uc815<\/strong><\/p>\n

maxreqs (12288->24576)<\/p>\n

maxservers (32->64) (kproc = maxservers*cpu count)<\/p>\n

 <\/p>\n

5. COMMIT_WRITE \uba85\ub839\uc5d0 \uc758\ud574 Redo Buffer\ub97c Redo Log File\uc5d0 \uae30\ub85d\ud558\ub294 \ubc29\uc2dd\uc744 \uc0ac\uc6a9\uc790\uac00 \uc81c\uc5b4\u00a0 (10gR2\ubd80\ud130 \uc81c\uacf5)<\/span><\/b><\/p>\n

\ub300\uae30\uc5ec\ubd80\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WAIT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uae30\uc874\uc758 Commit\uacfc \uac19\uc774 Redo Buffer\uac00 Redo Log File\uc5d0 \uae30\ub85d\uc744 \uc644\ub8cc \ud560 \ub54c \uae4c\uc9c0 Session\uc740 \ub300\uae30\ud568<\/p>\n

NOWAIT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Redo Buffer\uac00 Redo Log File\uc5d0 \uae30\ub85d\uc774 \uc644\ub8cc \uc2dc \uae4c\uc9c0 \ub300\uae30\ud558\uc9c0 \uc54a\uace0 \ub2e4\ub978 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc74c<\/p>\n

\ub300\uae30\uc5ec\ubd80\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IMMEDIATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Redo Log File\uc5d0 \uc4f0\uae30 \uc791\uc5c5\uc744 \ubc14\ub85c \ubc14\ub85c \uc218\ud589\ud568<\/p>\n

BATCH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Redo Log File\uc5d0 \uc4f0\uae30 \uc791\uc5c5\uc744 Batch \ud615\ud0dc\ub85c \ubab0\uc544\uc11c \uc218\ud589\ud568<\/p>\n

 <\/p>\n

EX) SQL> alter system set commit_write=NOWAIT, BATCH<\/p>\n

 <\/p>\n

6. Redo Buffer<\/b>\uc758 \ud06c\uae30\uac00 \uc9c0\ub098\uce58\uac8c \ud070 \uacbd\uc6b0\uc5d0 log file sync \ub300\uae30 \uc99d\uac00 \ubc1c\uc0dd \uac00\ub2a5<\/b><\/p>\n

Redo Buffer\uc758 \ud06c\uae30\uac00 \uc9c0\ub098\uce58\uac8c \ud070 \uacbd\uc6b0 Commit\uc744 \uc218\ud589\ud560 \ub54c, LGWR \ud504\ub85c\uc138\uc2a4\ub294 \ub354 \ub9ce\uc740 \uc591\uc758 Redo Entry\ub97c \ub514\uc2a4\ud06c\uc5d0 \uae30\ub85d\ud574\uc57c \ud558\ubbc0\ub85c sync write \uc2dc\uac04\uc740 \ub354 \uc624\ub798 \uc18c\uc694.<\/p>\n

log buffer space\uac00 \uc99d\uac00\ud560 \uacbd\uc6b0 Redo Buffer\uc758 \ud06c\uae30\ub97c \uc99d\uac00\uc2dc\ud0a4\uace0 log file sync \ub300\uae30\uac00 \uc99d\uac00 \ud560 \uacbd\uc6b0\u00a0 Redo Buffer\uc758 \ud06c\uae30\ub97c \uac10\uc18c\uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/b><\/p>\n

\ub530\ub77c\uc11c Redo Buffer\uc758 \ud06c\uae30\uac00 \uc801\uc808\ud55c \ud06c\uae30\uac00 \ub418\uc5b4\uc57c \ud558\uc9c0\ub9cc \uc801\uc815 \uac12\uc740 \uc815\ud574\uc838 \uc788\uc9c0 \uc54a\uc73c\uba74 \uc9c0\uc18d\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud1b5\ud574\uc11c \uc870\uc815 \ud574\uc57c \ud569\ub2c8\ub2e4.<\/u><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Wait Event\ub97c \ubcf4\ub2e4 \ubcf4\uba74 log file sync \uc774\ubca4\ud2b8\uac00 \ub9ce\uc774 \ubc1c\uc0dd \ud569\ub2c8\ub2e4. \ub300\ud45c\uc801\uc778 \uacbd\uc6b0\uac00 \uba87 \uac1c \uc788\uc2b5\ub2c8\ub2e4.   1.\u00a0 Redo Log File Size\ub97c \uc99d\uac00\uc2dc\ud0b4\uc73c\ub85c Log Switch \uc218\uce58 \uac10\uc18c \u00a0\u00a0\u00a0\u00a0 -> I\/O \uac10\uc18c\ub85c \uc131\ub2a5\uc5d0 \uc774\uc810 \u00a0 2. SYS.AUDSES$ \uc2dc\ud000\uc2a4\uc758 CACHE \uac12\uc744 \ud06c\uac8c \uc870\uc815\ud558\uc5ec \ud574\uacb0 ->\u00a0 \ub3d9\uc2dc \uc811\uc18d \uacfc\ub2e4 \uc2dc\uc810\uc5d0 Log File Sync \ub300\uae30\uc774\ubca4\ud2b8\uc5d0 \uc758\ud55c Active Session\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":2499,"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":[856,434],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/digital4-300x241.jpg?fit=300%2C241","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2634"}],"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=2634"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2634\/revisions"}],"predecessor-version":[{"id":2637,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2634\/revisions\/2637"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2499"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2634"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}