{"id":504,"date":"2015-11-03T01:46:20","date_gmt":"2015-11-03T01:46:20","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=504"},"modified":"2015-11-03T01:46:20","modified_gmt":"2015-11-03T01:46:20","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-touch-count-%ec%95%8c%ea%b3%a0%eb%a6%ac%ec%a6%98","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=504","title":{"rendered":"\uc624\ub77c\ud074 Touch Count \uc54c\uace0\ub9ac\uc998"},"content":{"rendered":"<p>1. \ud130\uce58 \uce74\uc6b4\ud2b8 \uc18c\uac1c<\/p>\n<p>\uc624\ub77c\ud074\uc740 \ubcfc\ub968\uc758 \uc99d\uac00, \uc131\ub2a5\uc0c1\uc758 \uc694\uad6c \ubc0f \ucd5c\uadfc \uc2dc\uc2a4\ud15c\ub4e4\uc758 \ubcf5\uc7a1\uc131 \ub4f1\uc758 \uc774\uc720\ub85c Touch-&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">Count \uc5d0 \uadfc\uac04\ud55c Data Buffer Management Algorithm\uc744 \uc81c\uc2dc\ud558\uc600\ub2e4. \ub370\uc774\ud130 \ube14\ub85d \ubc84\ud37c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub4e4\uc740 Modified LRU \uc54c\uace0\ub9ac\uc998\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub354 \uc774\uc0c1 \uad00\ub9ac\ub418\uc9c0 \uc54a\ub294\ub2e4. Touch-Count \uc54c\uace0\ub9ac<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc998\uc740 \uc624\ub77c\ud074 8i\ubd80\ud130 \uc18c\uac1c\ub418\uc5c8\ub294\ub370 Latch Contention\uc744 \uc904\uc774\uace0 \ubc84\ud37c \uc131\ub2a5\uc758 \ucd5c\uc801\ud654\ub97c \uc704\ud55c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uae30\ud68c\ub97c \uc99d\uac00\uc2dc\ud0a4\uae30 \uc704\ud574\uc11c\uc774\ub2e4.&nbsp;<\/span><\/p>\n<p><\/p>\n<p>2. \ud130\uce58 \uce74\uc6b4\ud2b8 \ub098\uc628 \uc774\uc720<\/p>\n<p><b><span style=\"color: rgb(255, 94, 0);\">\uc624\ub77c\ud074 \ub370\uc774\ud130 \ube14\ub85d \ubc84\ud37c \uce90\uc2dc\uc758 \ud06c\uae30\uac00 \uae09\uaca9\ud558\uac8c \uc99d\uac00<\/span><\/b>\ud558\uc600\ub2e4. \ub370\uc774\ud130 \ube14<span style=\"font-size: 9pt; line-height: 1.5;\">\ub85d \uce90\uc2dc \ud06c\uae30\uac00 1 Giga \ubc14\uc774\ud2b8 \uc774\uc0c1\ub418\ub294 \uc0ac\uc774\ud2b8\ub4e4\ub3c4 \ub9ce\uc774 \ubcf4\uc558\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774 \uc815\ub3c4\uc758 \uce90\uc2dc \ud06c\uae30\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uad8c\uace0\ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc774\ub294 \uc0ac\ub78c\ub4e4\uc758 \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc0c1\uc5d0\uc11c\uc758 \uce90\uc2dc\uc5d0 \ub300\ud55c \uc694\uad6c\uac00 \uc5b4\ub5bb\uac8c \ubcc0<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud654\ud558\uc600\ub294\uc9c0\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uc788\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uadf8\ub7ec\ub098 \ubb38\uc81c\uc810\ub4e4\uc774 \uc874\uc7ac\ud558\uace0 \uc788\ub2e4. \uc624\ub77c\ud074\uc758 \ub370\uc774\ud130 \ube14\ub85d \ubc84<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud37c \uc54c\uace0\ub9ac\uc998\uc740 \uc911\uc694\ud55c Physical I\/O\uc5d0 \ub300\ud55c \uc608\uce21\uc744 \uae30\ubc18\uc73c\ub85c \uc124\uacc4\ub418\uace0 \ub9cc\ub4e4\uc5b4 \uc84c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 94, 0);\">\ub370\uc774\ud130&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 94, 0);\">\ube14\ub85d \ubc84\ud37c \ud06c\uae30\ub97c \ub9e4\uc6b0 \ud06c\uac8c \ud558\uc5ec&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 94, 0);\">\ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf8 DBA\ub77c\uba74 \uc774\ub7ec\ud55c \uacbd\uc6b0\uc5d0 \uc131\ub2a5\uc774 \uc800\ud558<\/span>\ub418\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac83\uc744 \uacbd\ud5d8\ud558\uc600\uc744 \uac83\uc774\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\uc131\ub2a5\uc774 \uc800\ud558\ub418\ub294 \uac83\uc740 \ub2f9\uc5f0\ud55c \uac83\uc774\ub2e4. \uadf8\ub7ec\uba74 \uc65c \uadf8\ub7f0 \uac83\uc77c \uae4c?&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uc740 I\/O\ub97c \uc704\ud558\uc5ec \ub514\uc790\uc778\ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 Buffer Cache Nature Shift\uac00 \ubc1c\uc0dd\ud560 \uacbd\uc6b0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4\ub978 \uc54c\uace0\ub9ac\uc998\uc774 \ubc18\ub4dc\uc2dc \uc0ac\uc6a9\ub418\uc5b4\uc57c \ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e8\uc21c\ud558\uac8c \ub9e4\uc6b0 \ud070 \ubc84\ud37c \uce90\uc2dc\ub97c \uad00\ub9ac\ud560 \uc218&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc788\ub294 \uac83\ub9cc\uc73c\ub85c\ub294 \ucda9\ubd84\ud558\uc9c0\uac00 \uc54a\ub2e4. \uc0ac\uc2e4\uc0c1 \ubc84\ud37c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uce90\uc2dc \ud06c\uae30\uac00 \ud070 \uacbd\uc6b0 \uc131\ub2a5\uc744 \uc720\uc9c0\ud558\ub294 \uac83\uc774\ub780 \uc27d\uc9c0 \uc54a\ub2e4. \ub530\ub77c\uc11c \uacbd\uc7c1\ub825\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574\uc11c &nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074 \uc2dc\uc2a4\ud15c\uc740 \ub300\uaddc\ubaa8\uc758 \uce90\uc2dc\ub97c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc9c0\uc6d0\ud560 \ubfd0 \uc544\ub2c8\ub77c \uc8fc\uc694\ud55c \uc131\ub2a5\uc0c1\uc758 \uc787\uc810\uc744 \uc81c\uacf5\ud574\uc57c \ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4\uc2dc \ub9d0\ud574\uc11c \uc0c8\ub85c\uc6b4 \uc54c\uace0\ub9ac\uc998\uc774 \uc694\uad6c\ub418\ub294 \uac83\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubcf4\ub2e4 \ud070 \uce90\uc2dc\uc640 \uc99d\uac00\ub41c \uc131\ub2a5\uc0c1\uc758 \uc694\uad6c\uc5d0 \ub354\ud558\uc5ec \uc624\ub77c\ud074\uc740&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uc758 \ub9c8\ucf00\ud305\uacfc \ud14c\ud06c\ub2c8\uceec \ud3ec\uc9c0\uc158<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc744 \ubd84\uc0b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uac15\ub825\ud55c \uc911\uc559 \uc9d1\uc911\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc804\ud658\ud558\uace0 \uc788\ub2e4. \uc774\ub7ec\ud55c \ubcc0\ud654&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub4e4\uc740 \uc81c\uc5b4\uc5d0 \ub300\ud55c \uc694\uad6c\ub97c \uc99d\uac00\uc2dc\ucf30\uc73c\uba70&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uc740 \ub2e8\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \ubcf4\ub2e4 \uc791\uc740 \uc11c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ube0c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ubd84\ud560\ud558\ub294 \ubc29\ubc95\uc744 DBA\ub4e4\uc5d0\uac8c \uc81c\uacf5\ud558\uace0 \uc788\ub2e4. \uc624\ub77c\ud074\uc758 Touch-Count \uad6c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud604\uc740 \uc0c1\ub2f9\ud788 \ucd5c\uc801\ud654\ub418\uc5c8\uc73c\uba70&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub530\ub77c\uc11c <span style=\"color: rgb(9, 0, 255);\">\ub2e4\uc774\ub098\ubbf9\ud558\uace0 \ub9e4\uc6b0 \ud070 \uce90\uc2dc\ub0b4\uc5d0\uc11c \ubc84\ud37c \uce90\uc2dc\ub97c \uad00\ub9ac\ud558<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(9, 0, 255);\">\uae30 \uc704\ud574 \ud544\uc694\ud55c \uc81c\uc5b4<\/span>\ub97c \uc81c\uacf5\ud560 \uac83\uc774\ub2e4.<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub300\uaddc\ubaa8\uc758 \uce90\uc2dc,\uc131\ub2a5\uc0c1 \uc694\uad6c\uc758 \uc99d\uac00\uc640 \uc81c\uc5b4\ub97c \ud568\uaed8 \ub193\uace0 \ubcf4\uc558\uc744 \ub54c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uc774 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ube14\ub85d \ubc84\ud37c \uce90\uc2dc \uc54c\uace0\ub9ac\uc998\uc744 \uc120\ud0dd\ud55c \uac83\uc774 \ud0c1\uc6d4\ud558\ub2e4\uace0 \ub9cc\uc740 \ud560 \uc218 \uc5c6\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uc774 \uc218\ub144\uac04\uc5d0 \uac78\uccd0 \ub370\uc774\ud130 \ube14\ub85d \ubc84\ud37c \uc54c\uace0\ub9ac\uc998\uc744 \ubcc0\uacbd\ud558\uc5ec \uc654\ub2e4\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac83\uc774\ub2e4.<\/span><\/p>\n<p><\/p>\n<p>3. \ubc84\ud37c \uce90\uc26c \uad00\ub9ac\uc758 \uc5ed\uc0ac<\/p>\n<p>\uc624\ub77c\ud074\uc740 \ub370\uc774\ud130 \ube14\ub85d \ubc84\ud37c \uc54c\uace0\ub9ac\uc998\uc744 \uc218\uc815\ud574\uc654\ub2e4.&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uc758 \uc911\uc2ec\uc5d0\ub294 <b>LRU(Least Recently Used List)<\/b>\uac00 \uc788\ub2e4. LRU\ub294 \ub2e8\uc21c\ud788 \uce90\uc2f1\ub41c \ub370\uc774\ud130 \ube14\ub85d<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5d0 \ub300\ud55c \ud3ec\uc778\ud130\ub4e4\uc758 \ub9ac\uc2a4\ud2b8\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc77c\ubc18\uc801\uc73c\ub85c \uc774\ub4e4 \ub9ac\uc2a4\ud2b8\uc758 \uc55e\ucabd\uc740 \uc790\uc8fc \uc4f0\uc774\ub294 \ube14\ub85d\ub4e4\uc774&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4\ub978 \ud3b8\uc758 \ub05d\ucabd\uc5d0\ub294 \uc790\uc8fc \uc4f0\uc774\uc9c0 \uc54a\ub294 \ube14\ub85d\ub4e4\uc774 \uc874\uc7ac\ud55c\ub2e4. LRU \uccb4\uc778\uc758 \uc790\uc8fc \uc4f0\uc774\ub294 \ub05d\ucabd\uc744&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">MRU(Most Recently Used) \ub9ac\uc2a4\ud2b8\uc758<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub05d\uc774\ub77c\uace0 \ubd80\ub978\ub2e4. <span style=\"color: rgb(255, 0, 0);\">LRU \uccb4\uc778\uc758 \uc790\uc8fc \uc4f0\uc774\uc9c0 \uc54a\ub294 \ub05d<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\">\ucabd\uc744 LRU\uc758 \ub05d<\/span>\uc774\ub77c\uace0 \ubd80\ub978\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc885\uc885 LRU \uccb4\uc778\uc758 LRU \ub05d\uc5d0 \ub300\ud558\uc5ec \ud63c\ub3d9\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc73c\ub098&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub7ec\ud55c Naming Convention\uc5d0 \uc0c1\uad00\uc5c6\uc774 \uc77c\ubc18\uc801\uc778 \uc544\uc774\ub514\uc5b4\ub294 <span style=\"color: rgb(255, 0, 0);\">Physcial I\/O\ub97c \ucd5c\uc801\ud654\ud558\uae30&nbsp;<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 0, 0);\">\uc704\ud558\uc5ec \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \ube14\ub85d\uc744&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\">\uce90\uc2f1\ud558\uc5ec \ubc84\ud37c \uce90\uc2dc\ub0b4\uc5d0 \uc720\uc9c0\ud558\ub294 \uac83<\/span>\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ucd08\uae30\uc5d0 \uc624\ub77c\ud074\uc740 \ud45c\uc900 LRU \uc54c\uace0\ub9ac\uc998\uc774\ub77c\uace0 \ubd88\ub9ac\ub294 \uac83\uc744 \ub9cc\ub4e4\uc5c8\ub2e4. \ubc84\ud37c\uac00 \uce90\uc2dc\ub85c \uc62e\uaca8\uc9c0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac70\ub098 \uce90\uc2dc\ub0b4\uc5d0\uc11c \ub2e4\uc2dc \uc561\uc138\uc2a4\ub420 \ub54c \ub9c8\ub2e4&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc84\ud37c\uc758 \ud3ec\uc778\ud130\ub294 LRU \uccb4\uc778\uc758 MRU end\ub85c \uc774\ub3d9\ub41c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">(\uae30\uc5b5\ud560 \uac83\uc740 <b><u>\ube14\ub85d\uc740 \uc808\ub300\ub85c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc774\ub3d9\ub418\uc9c0 \uc54a\uc73c\uba70 \ub2e8\uc9c0 \ubb3c\ub9ac\uc801\uc778 \uba54\ubaa8\ub9ac \ube14\ub85d\uc5d0&nbsp;<\/u><\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b><u>\ub300\ud55c \ud3ec\uc778\ud130\ub9cc \uc774\ub3d9<\/u><\/b>\ud558\ub294 \uac83\uc784).&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5ec\uae30\uc11c \uc0dd\uac01\ud574 \ubcf4\uc544\uc57c \ud560 \uac83\uc740 \uc790\uc8fc \uc4f0\uc774\uc9c0 \uc54a\ub294 \ube14\ub85d\uc740 \uc790<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5f0\uc801\uc73c\ub85c LRU \ub9ac\uc2a4\ud2b8\uc758 LRU end\ub85c \uc774\ub3d9\ub418\uba70 \uc544\ub9c8\ub3c4 \uc774\ub4e4\uc758 \ub0b4\uc6a9\uc740 \ub354 \uc790\uc8fc \uc4f0\uc774\ub294 \ube14\ub85d&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub4e4\ub85c \ucc44\uc6cc\uc838 \uc788\uc744 \uac83\uc774\ub2e4.<\/span><b style=\"font-size: 9pt; line-height: 1.5;\">Full Table \uc2a4\uce94<\/b><span style=\"font-size: 9pt; line-height: 1.5;\">\uc740 Cache Killer\uc640 \uac19\uc740\ub370 \ubaa8\ub4e0 \ud14c\uc774\ube14 \ube14\ub85d\uc774 \ubc84\ud37c\uc5d0 \ub193\uc5ec\uc9c0\uac8c \ub41c\ub2e4. \ub9cc\uc57d&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc84\ud37c \uce90\uc2dc\uac00 500 Block\uc774\uace0 \ud14c\uc774\ube14\uc774 600 Block\uc744 \ud3ec\ud568\ud558\uace0 \uc788\ub2e4\uba74&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubaa8\ub4e0 \uc790\uc8fc \uc4f0\uc774\ub294 \ube14<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85d\ub4e4\uc740 \uc774 Full-Table \uc2a4\uce94\ub41c \ud14c\uc774\ube14\uc758 \ube14\ub85d\ub4e4\ub85c \uad50\uccb4\ub420 \uac83\uc774\ub2e4. \uc774\ub294 <b>\uacfc\ub3c4\ud55c \ucef4\ud4e8\ud130 \uc2dc\uc2a4<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b>\ud15c\uc758 \uc0ac\uc6a9\uacfc \uae30\ubcf8\uc801\uc73c\ub85c \uc798 \uad6c\uc131\ub418\uc5b4\uc9c4 \uce90\uc2dc\ub97c \ud30c\uad34\ud558\ub294 \ud604\uc0c1\uc744&nbsp;<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b>\ucd08\ub798\ud558\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ubca0<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b>\uc774\uc2a4 \uc131\ub2a5 \uc800\ud558\uc758 \uc8fc\uc694\ud55c \uc694\uc778\uc73c\ub85c \uc791\uc6a9<\/b>\ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub7ec\ud55c \uc694\uc18c\ub4e4\uc744 \uc81c\uac70\ud558\uae30 \uc704\ud574\uc11c \uadf8 \uc720\uba85\ud55c <span style=\"color: rgb(255, 0, 0);\"><b>Modified Least Recently Used(LRU) \uc54c\uace0<\/b><\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>\ub9ac\uc998\uc774 \uad6c\ud604<\/b><\/span>\ub418\uc5c8\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uc774 \uc218\ub144\ub3d9\uc548 \uc774 \uc54c\uace0\ub9ac\uc998\uc744 \ubcc0\uacbd\ud558\ub294 \ub3d9\uc548\uc5d0\ub3c4 \uae30\ubcf8\uc801\uc740 \uc624\ud37c\ub808<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uc158\ub4e4\uc740 \ub3d9\uc77c\ud558\uac8c \uc720\uc9c0\ub418\uc5c8\ub2e4. <span style=\"color: rgb(9, 0, 255);\">Modified LRU \uc54c\uace0\ub9ac\uc998\uc740 Full-Table \uc2a4\uce94\ub41c \ube14\ub85d\ub4e4\uc744 \uc77d\uc5b4<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(9, 0, 255);\">\uc11c LRU \uccb4\uc778\uc758<\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(9, 0, 255);\">LRU end\uc5d0 \uc62c\ub824 \ub193\uc73c\uba70 \uc774\ub4e4 \ube14\ub85d\uc911\uc5d0\uc11c \uc81c\ud55c\ub41c \uc218\uc758 \ube14\ub85d\ub9cc\uc774 \ub3d9\uc2dc\uc5d0 \uce90<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(9, 0, 255);\">\uc2dc\ub0b4\uc5d0 \uc874\uc7ac\ud558\ub3c4\ub85d \ud5c8\uc6a9\ud55c\ub2e4<\/span>. \uc774\uac83\uc740 <span style=\"color: rgb(255, 94, 0);\"><b>Full-table \uc2a4\uce94\uc774 \uc804\uccb4 \ubc84\ud37c \uce90\uc2dc\ub97c \ud50c\ub7ec\uc2f1(Flush)\ud558<\/b><\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 94, 0);\"><b>\ub294 \uac83\uc744&nbsp;<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 94, 0);\"><b>\ubc29\uc9c0\ud558\uae30 \uc704\ud574\uc11c\uc774\ub2e4.<\/b><\/span>&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uac83\uc774 \ub9c8\uce58 \ubaa8\ub4e0 \ubc84\ud37c \uce90\uc2dc \ubb38\uc81c\ub97c \ud574\uacb0\ud55c \uac83\ucc98\ub7fc \ubcf4\uc77c\uc9c0 \ubaa8\ub974\uc9c0\ub9cc \ub2e4\uc2dc \uc0dd\uac01\ud574 \ubcf4\uc544\uc57c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud560 \uac83\ub4e4\uc774 \uc788\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">Large Index Range \uc2a4\uce94\uc740 \uc5b4\ub5bb\uac8c \ud560 \uac83\uc778\uac00? \uc218\ubc31\uac1c\uc758 \uc778\ub371\uc2a4 \ub9ac\ud504 \ube14<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85d\ub4e4\uc774 \ubc84\ud37c \uce90\uc2dc\ub0b4\ub85c \uc720\uc785\ub418\ub294 \uc0c1\ud669\uc744 \uc0c1\uc0c1\ud574 \ubcf4\uc790.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\uc218\uc815\ub41c LRU \uc54c\uace0\ub9ac\uc998\uc740 \uc624\uc9c1 Full-<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Table \uc2a4\uce94 \uc774\uc288\ub9cc\uc744 \uace0\ub824\ud558\uc600\uc73c\uba70 Index Block\uc5d0 \ub300\ud55c \uac83\uc740 \uc544\ub2c8\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc77c\uc2dc\uc801\uc778 \uc194\ub8e8\uc158\uacfc \uacbd\uc7c1\ub825\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud558\uc5ec&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b><span style=\"color: rgb(9, 0, 255);\">\uc624\ub77c\ud074\uc740 Multiple Buffer Pool\uc744 \uace0\uc548<\/span><\/b>\ud558\uc600<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4. \ub300\ubd80\ubd84\uc758 DBA\ub4e4\uc740 Multiple Buffer Pool\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba70 Touch-Count \uc54c\uace0\ub9ac\uc998\uc740&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub97c \ub9e4\ub825\uc801\uc774\uc9c0 \uc54a\uac8c \ud558\uc600\uc73c\uba70&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub4e4\uc740 \uc0c1\ub2f9\ud788 \uc815\uad50\ud558\uac8c \uc0ac\uc6a9\ub420 \ub54c\uc5d0\ub9cc \ub9e4\uc6b0 \ud6a8\uacfc\uc801\uc77c \uc218&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc788\ub2e4.<b> Keep Pool<\/b>\uc740 \uc791\uc740 \uc624\ube0c\uc81d\ud2b8\ub4e4\uc744 \uc704\ud574 \uace0\uc548\ub418\uc5c8\ub294\ub370 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc751\ub2f5 \uc2dc\uac04 \uc774\uc288<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub97c \uace0\ub824\ud560 \ub54c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud56d\uc0c1 \uce90\uc2dc\ud574 \ub193\uc544\uc57c \ud55c\ub2e4. <b>Recycle Pool<\/b>\uc740 \uc77c\ubc18\uc801\uc774\uba70 \uc815\uc0c1\uc801\uc778 \ubc84\ud37c \uce90\uc2dc \uc624<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud37c\ub808\uc774\uc158\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 \ud070 \uc624\ube0c\uc81d\ud2b8\ub4e4\uc744 \uc704\ud574 \uace0\uc548\ub418\uc5c8\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\ub9c8\uc9c0\ub9c9\uc73c\ub85c Default Pool\uc740 \uadf8&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc678 \ubaa8\ub4e0 \uacbd\uc6b0\ub97c \uc704\ud574 \uace0\uc548\ub418\uc5c8\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc77c\ubc18\uc801\uc774\uba70 \ud6a8\uacfc\uc801\uc778 \ubc84\ud37c \uce90\uc2dc \uc624\ud37c\ub808\uc774\uc158\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud558\uc5ec \ub9e4\uc6b0 \ube60\ub978 \uc54c\uace0\ub9ac\uc998\uc774 \ubc18\ub4dc<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc2dc \ud544\uc694\ud558\uba70&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub294 \ud575\uc2ec\uc801\uc73c\ub85c \ubaa8\ub4e0 \ubc84\ud37c\uac00 \ubc84\ud37c \uce90\uc2dc\ub0b4\uc5d0 \uc774\ub4e4\uc758 \uc790\ub9ac\ub97c \ud655\ubcf4\ud558\uace0 \ub610\ud55c \ubc84<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud37c \uce90\uc2dc\ub0b4\uc5d0 \uba38\ubb34\ub97c \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \uac83\uc774\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 0, 0);\">Touch-count \uc54c\uace0\ub9ac\uc998\uc740 \uac01\uac01\uc758 \uadf8\ub9ac\uace0 \ubaa8\ub4e0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 0, 0);\">\ube14\ub85d\ub4e4\uc774 \ubc84\ud37c \uce90\uc2dc\uc5d0 \uacf5\uac04\uc744 \ud560\ub2f9 \ubc1b\uac8c \ud560 \ubfd0 \uc544\ub2c8\ub77c \ubc84\ud37c \uce90\uc2dc\ub0b4\uc5d0 \uba38\ubb34\ub97c \uc218 \uc788\ub3c4\ub85d \ud55c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\">\ub2e4.<\/span>&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\ube44\ub85d \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\uba54\ud130\uc640 \uad00\ub828\ub41c Default Touch-count\ub294 \ube14\ub85d\uc774 \ub2e8\uc21c\ud558\uac8c \ubc84\ud37c \uce90\uc2dc&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub0b4\uc5d0 \uc720\uc9c0\ub418\ub294 \uac83\uc744 \uc5b4\ub835\uac8c \ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc84\ud37c \uce90\uc2dc\ub0b4\uc5d0 \uc720\uc9c0\ub418\uae30 \uc704\ud574\uc11c\ub294 \uc0c1\ub2f9\ud788 \ub9ce\uc740 \uc7a5\uc560\ub4e4\uc774&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc874\uc7ac\ud55c\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p>4. \ud130\uce58 \uce74\uc6b4\ud2b8 \ubc84\ud37c \uad00\ub9ac \ubc29\ubc95<\/p>\n<p>Touch-Count Based \uc54c\uace0\ub9ac\uc998(Count Frequency Scheme\ub77c\uace0\ub3c4 \ubd88\ub9bc)\uc740 Simple LRU&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\uc54c\uace0\ub9ac\uc998\ubcf4\ub2e4 \ubcf5\uc7a1\ud558\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc5d0\ub294 Touch-Count \uc54c\uace0\ub9ac\uc998 \uc0ac\uc6a9\uc2dc \ube44\uc6a9\uc0c1\uc5d0\uc11c \uadf8\ub9ac<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uace0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uc804 LRU \uc54c\uace0\ub9ac\uc998\uacfc \ube44\uad50\ud560 \ub54c, \ubcf4\ub2e4 \ud5a5\uc0c1\ub41c \uc131\ub2a5\uc744 \uc81c\uacf5\ud558\ub294 \ub4f1\uacfc \uac19\uc740 \uc787\uc810\ub4e4\uc5d0 \uc55e<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc11c \ubb34\uc5c7\uc778\uac00 Motivating Factor\ub4e4\uc774 \uc874\uc7ac\ud574\uc57c \ud560\uac83\uc774\ub2e4. \uc774\ubbf8 \uc774\ub7ec\ud55c Motivating Factor\ub4e4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5d0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub300\ud574\uc11c\ub294 \uc5b8\uae09\ud558\uc600\ub294\ub370 \uc989, Bigger Cache, \uc131\ub2a5\uc0c1\uc758 \uc694\uad6c \uc0ac\ud56d\ub4e4, \uc99d\uac00\ub41c \uc81c\uc5b4, Full-<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">table Scan \uc5b5\uc138\uc2a4, Index \uc5b5\uc138\uc2a4\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub7ec\ud55c \uc694\uc18c\ub4e4\uc740 \uce90\uc2dc \ud658\uacbd\uc744 \ub9e4\uc6b0 \uaca9\ub82c\ud558\uace0 \uae34\uc7a5&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub418\uac8c \ub9cc\ub4e0\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Touch-count Based \uc54c\uace0\ub9ac\uc998\uc758 \ud575\uc2ec\uc740 \uac01 \ubc84\ud37c\uac00 \uce90\uc2dc\ub0b4\uc5d0 \uc720\uc9c0\ub418\uac8c \ud558\ub294 \uac83 \ubfd0\ub9cc\uc774 \uc544<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2c8\ub77c LRU \ub9ac\uc2a4\ud2b8\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">MRU end\uc5d0 \uacc4\uc18d \ub193\uc5ec\uc9c0\ub3c4\ub85d \ud558\ub294 \uac83\uc774\ub2e4. \uc77c\ubc18\uc801\uc778 Touch-count \uc54c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uace0\ub9ac\uc998\uc740 \uc774\ub97c \uc704\ud558\uc5ec \uac01 \ubc84\ud37c\uc5d0 Counter\ub97c \ud560\ub2f9\ud55c\ub2e4. \ube14\ub85d\uc774 Touch\ub420 \ub54c \ub9c8\ub2e4 \uc774\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Counter\uac00 \uc99d\uac00\ub41c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774 Touch Counter\uc758 \uac12\uc740 \uac01 \ubc84\ud37c\ub9c1\ub41c \ube14\ub85d\uc5d0 Value \ud639\uc740&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Polularity\ub97c \ubd80\uc5ec\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub41c\ub2e4. \uc774 Touch Count\ub294 \ubc84\ud37c \uce90\uc2dc \ud65c\ub3d9 \uc911\uc5d0 Reference<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub418\uba70 Manipulate\ub420 \uac83\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Reference\uc640 Manipulation \ud2b9\uc131\ub4e4\uc740 Touch-Count \uc54c\uace0\ub9ac\uc998&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uad6c\ud604\uc758 \ud2b9\uc131\uc774\ub2e4.&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 2em;\">4.1. Oracle\u2019s Touch-Count Implementation<\/p>\n<p style=\"margin-left: 2em;\">\uc624\ub77c\ud074\uc740 \ubc84\ud37c\uac00 \uce90\uc2dc\ub0b4\uc5d0 \uc720\uc9c0\ub418\ub294 \uac83\uc744 \ub9e4\uc6b0 \uc5b4\ub835\uac8c \ub9cc\ub4dc\ub294 \uc77c\ubd80 \uc131\uac00\uc2e0 \uc791\uc5c5\ub4e4\uc744 \uc218\ud589<span style=\"font-size: 9pt; line-height: 1.5;\">\ud55c\ub2e4. \uc624\uc9c1 \uc120\ud0dd\ub41c \uc18c\uc218\ub9cc\uc774 LRU \uccb4\uc778\uc758 MRU end\uc5d0 \ub0a8\uc544 \uc788\uc744 \uc218 \uc788\ub2e4.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 2em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\">4.1.1. MIDPOINT INSERTION<\/p>\n<p style=\"margin-left: 4em;\"><b>LRU\ub294 \ub450\uac1c\uc758 \uae30\ubcf8\uc801\uc778 \uc601\uc5ed, Hot Region\uacfc Cold Region<\/b>\uc73c\ub85c \ub098\ub258\uc5b4 \uc9c4\ub2e4. Hot Region\ub0b4<span style=\"font-size: 9pt; line-height: 1.5;\">\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ubc84\ud37c\ub4e4\uc740 Hot Buffer\ub77c\uace0 \ubd88\ub9ac\uba70 Cold Region\ub0b4 \ubaa8\ub4e0 \ubc84\ud37c\ub4e4\uc740 Cold Buffer<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub77c\uace0 \ubd88\ub9b0\ub2e4. Hot Region\uacfc Cold Region\uc0ac\uc774\uc5d0\ub294 Midpoint Marker\uac00 \uc788\uc73c\uba70 \uc774&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Midpoint \ud3ec\uc778\ud130\ub294 \uc801\ub2f9\ud55c \uc218\uc758 \ubc84\ud37c\uac00 Hot Region\uacfc Cold Region\uc5d0 \uc874\uc7ac\ud558\ub3c4\ub85d \uc774\ub3d9\ud55c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc989, Midpoint \ud3ec\uc778\ud130\ub294 \ud2b9\uc815 \ube14\ub85d\uacfc \uad00\uacc4\ub41c \uac83\uc774 \uc544\ub2c8\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\">\ub514\ud3f4\ud2b8\ub85c \uc624\ub77c\ud074\uc740 LRU\ub97c \uade0\ub4f1\ud558\uac8c \ubd84\ud560\ud55c\ub2e4. \uc989, Hot Region\uacfc Cold Region\uc740 \ubc84\ud37c\ub0b4\uc5d0<span style=\"font-size: 9pt; line-height: 1.5;\">\uc11c \uac01\uac01 50%\ub97c \ucc28\uc9c0\ud55c\ub2e4. \uc774\uac83\uc740 _db_percent_hot_default \ud30c\ub77c\uba54\ud130\uc5d0 \uc758\ud574\uc11c \uc81c\uc5b4\ub41c\ub2e4.<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774 \ud30c\ub77c\uba54\ud130\ub97c \uc99d\uac00\uc2dc\ud0a4\uba74 Hot Region\ub0b4 \ubc84\ud37c\uc758 \ubc31\ubd84\uc728\uc774 \uc99d\uac00\ub420 \uac83\uc774\uba70 \uc989 midpoint\ub97c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub118\uc5b4\uc11c\uac8c \ub41c\ub2e4.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">\uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 <span style=\"color: rgb(255, 0, 0);\">\ub514\uc2a4\ud06c\uc5d0\uc11c \ube14\ub85d\uc744 \uc77d\uc5b4\uc11c \ubc84\ud37c \uce90\uc2dc\uc5d0 \uc62c\ub824 \ub193\uc744 \ub54c LRU \uccb4\uc778\uc758 \uc911\uac04,<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\">\uc989 Hot\uacfc Cold Region\uc758 \uc0ac\uc774\uc5d0 \uc62c\ub824 \ub193\ub294\ub2e4<\/span>.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uac83\uc740<span style=\"color: rgb(255, 0, 0);\"><b> Midpoint Insertion<\/b><\/span>\uc774\ub77c\uace0 \uc54c\ub824\uc838&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc788\uc73c\uba70 \uc624\ub77c\ud074 Touch-Count \uc54c\uace0\ub9ac\uc998 \uad6c\ud604\uc758 \uae30\ubcf8\uc801\uc778 \uac1c\ub150\uc774\ub2e4. <b><span style=\"color: rgb(255, 0, 127);\">\uc2e4\uc81c\uc801\uc73c\ub85c \ubc84\ud37c\ub294 Hot&nbsp;<\/span><\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b><span style=\"color: rgb(255, 0, 127);\">Region\ub0b4\ub85c \uc704\uce58<\/span><\/b>\ub41c\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\">4.1.2. TOUCH COUNT INCREMENTATION<\/p>\n<p style=\"margin-left: 4em;\">\uac1c\ub150\uc801\uc73c\ub85c \ubc84\ud37c\uac00 Touch\ub420 \ub54c \ub9c8\ub2e4 \uc5b4\ub5a4 \uc774\uc720\uc5d0\uc11c\ub4e0 Touch Count\ub294 \uc99d\uac00\ub41c\ub2e4. \ubc84\ud37c\uc758&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">Life\uc0c1\uc5d0\ub294 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uc758 \uac15\ub825\ud55c \uad00\uc2ec\uc18d\uc5d0 \uc788\ub2e4\uac00 \ub9e4\uc6b0 \ube60\ub974\uac8c \uc774\uc758 \uad00\uc2ec\uc73c\ub85c\ubd80\ud130 \uba40\uc5b4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc9c0\ub294 \uc2dc\uae30\uac00 \uc788\ub2e4. \uc774\ub7ec\ud55c \ubb38\uc81c\uc810\uc744 \uac10\uc18c\uc2dc\ud0a4\uae30 \uc704\ud558\uc5ec \uc624\ub77c\ud074\uc740 \uc624\uc9c1 \ubc84\ud37c\uc758 Touch&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Count\uac00 \ub514\ud3f4\ud2b8\ub85c \uae30\uaecf\ud574\uc57c 3\ucd08\ub9c8\ub2e4 \ud55c\ubc88\uc529\ub9cc \uc99d\uac00\ub418\ub3c4\ub85d \ud5c8\uc6a9\ud55c\ub2e4. \uc774\uac83\uc740 \ubc84\ud37c\uc758 Touch<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Count\uac00 3\ucd08\ub0b4\uc5d0\uc11c \ud55c\ubc88\ub9cc \uc99d\uac00\ub420 \uc218 \uc788\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \ub9cc\uc57d Time&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Sequence\ub97c \uadf8\ub798\ud504\ub85c \ub098\ud0c0\ub0b8\ub2e4\uba74 Touch Count\uac00 3\ucd08\ub0b4\uc5d0\uc11c \ub450\ubc88 \uc99d\uac00\ub418\ub294 \uac83\uc744 \ubcfc \uc218&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc788\uc744 \uac83\uc774\ub2e4. \uc774 \u201cthree second period\u201d\ub294 _db_aging_touch_time \ud30c\ub77c\uba54\ud130\ub85c\uc11c \uc870\uc815 \uac00<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2a5\ud558\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Touch Count \uc99d\uac00\uc758 \ub610 \ub2e4\ub978 \uc8fc\uc694\ud55c \uce21\uba74\uc740 \ubc84\ud37c\uac00 \uc774\ub3d9\ud558\uc9c0 \uc54a\ub294 \ub2e4\ub294 \uac83\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc989, \uc774\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud3ec\uc778\ud130\uac00 \uc774\ub3d9\ud558\uc9c0 \uc54a\ub294 \uac83\uc774\ub2e4. Touch Count \uc99d\uac00\uc640 \ubc84\ud37c \ud3ec\uc778\ud130\uc758 \uc774\ub3d9\uc740 \uc11c\ub85c \ub3c5\ub9bd\uc801\uc774<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4. \ubc84\ud37c \ud3ec\uc778\ud130 \uc774\ub3d9\uc740 \uc544\ub798\uc5d0\uc11c \uc124\uba85\ud560 \uac83\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Latch\ub294 \ud2b9\uc815 \uc561\uc158\uc744 \uc218\ud589\ud558\uae30 \uc704\ud558\uc5ec \ubc18\ub4dc\uc2dc \uc18c\uc720\ud574\uc57c \ud560 Token\uacfc \uac19\uc740 \uac83\uc774\ub2e4. \uadf8\ub7ec\ub098&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uc740 Latch\uac00 \uc5c6\uc774 Buffer\uc758 Touch Count\ub97c \uc5c5\ub370\uc774\ud2b8 \ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc989, \ubc84\ud37c\ub294 Touch Count<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac00 \uc99d\uac00\ub418\ub294 \ub3d9\uc548\uc5d0 \uad00\ub9ac\ub420 \uac83\uc774\ub2e4. \uc774\ub7ec\ud55c \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd \uac00\ub2a5\ud55c \ucd5c\uc545\uc758 \uacbd\uc6b0\ub294 Touch&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Count\uac00 \uc2e4\uc81c\ub85c \uc99d\uac00\ub418\uc9c0 \uc54a\uc73c\uba70 Cache Corruption\ub3c4 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294 \uac83\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\">4.1.3. BUFFER MOVEMENT<\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>\ubc84\ud37c\uac00 \ubc84\ud37c \uce90\uc2dc\ub85c \uc62c\ub824\uc9c0\uba74 Midpoint \uc55e\uc5d0 \ub193\uc5ec\uc9c0\uba74 Hot Region\uc5d0 \uc62c<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>\ub824\uc9c0\ub294 \uac83<\/b><\/span>\uc774\ub2e4. LRU \uc54c\uace0\ub9ac\uc998\uacfc \ub2e4\ub974\uac8c \uc624\ub77c\ud074\uc758 Touch-Count \uc54c\uace0\ub9ac\uc998\uc740 \ubc84\ud37c\ub97c \uc774\ub3d9\uc2dc<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud0a4\uc9c0 \uc54a\ub294\ub370 \uc774\ub294 \ubc84\ud37c\uac00 Touch\ub418\uae30 \ub54c\ubb38\uc774\ub2e4. \uc989, \uc774 Touch Count\ub294 \uc544\ub9c8\ub3c4 \uc99d\uac00\ub294 \ub418\uc9c0<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub9cc \ubc84\ud37c\ub294 \uc774\ub3d9\ub418\uc9c0 \uc54a\uc744 \uac83\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 \ubb3c\ub9ac\uc801\uc778 \uc624\ub77c\ud074 \ube14\ub85d\uc744 \ubc84\ud37c \uce90\uc2dc\ub85c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc62c\ub824\ub193\uae30 \uc704\ud574\uc11c Free Buffer\ub97c \ucc3e<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc744 \ub54c \uc774\ub294 \uac00\uc7a5 \uba3c\uc800 Free \ubc84\ud37c\ub97c \ucc3e\uc744 \uac83\uc774\ub2e4. Free \ubc84\ud37c\ub294 \ub2e8\uc21c\ud788 \ubc84\ud37c\uc774\uba70 \uc774\uc758 \ucee8\ud150<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uce20\ub294 \ub514\uc2a4\ud06c\uc0c1\uc758 \uce74\ud53c\ubcf8\uacfc \uc77c\uce58\ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc989, \uc5ec\uae30\uc5d0\ub294 \ucc28\uc774(Difference)\uac00 \uc5c6\ub2e4. \ub9cc\uc57d \uc0c1\uc774\ud558<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4\uba74 \ud574\ub2f9 \ube14\ub85d\uc740 Dirty\ub85c \ud0dc\uadf8\ub41c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 Free \ubc84\ud37c\ub97c \ucc3e\uac70\ub098 DBWR\uac00 Dirty \ube14\ub85d\uc744 \ucc3e\uc744 \ub54c, \uadf8\ub9ac\uace0 \ub9cc\uc57d \ube14\ub85d\uc758<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Touch Count\uac00 2\uc774\uc0c1\ub420 \uacbd\uc6b0 \ube14\ub85d\uc740 LRU \uccb4\uc778\uc758 MRU end\ub85c \uc774\ub3d9\ub41c\ub2e4. Block&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Movement Threshold(\ub514\ud3f4\ud2b8 2) \uac12\uc740 _db_aging_hot_criteria \ud30c\ub77c\uba54\ud130\ub85c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc81c\uc5b4 \uac00\ub2a5\ud558<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc84\ud37c\uac00 LRU \uccb4\uc778\uc758 MRU end\ub85c \uc774\ub3d9\ub418\uba74 \uc774\uc758 Touch count\ub294 0\ub85c \uc14b\ud305\ub41c\ub2e4(\uc5ec\ub7ec \ud14c\uc2a4\ud2b8<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5d0 \uc758\ud558\uba74 \ubc84\ud37c\uac00 LRU \uccb4\uc778\uc758 MRU end\ub85c \uc774\ub3d9\ub420 \ub420 \ub54c \uc774\uc758&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">Touch Count\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">_db_aging_stay_count(default 0) &gt; = _db_aging_hot_criteria(default 2)\uac00 \uc544\ub2c8\ub77c\uba74&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">0\ub85c \ub9ac\uc14b\ub41c\ub2e4.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">_db_aging_stay_count &gt; = _db_aging_hot_criteria \ub77c\uba74 \ud604\uc7ac Touch&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Count\ub97c 2\ub85c \ub098\ub208 \uac83\uc73c\ub85c \uc14b\ud305\ub41c\ub2e4).&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774 \uc0c8\ub86d\uac8c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Touch Count\uac00 0\uc73c\ub85c \uc14b\ud305\ub41c Popular \ubc84\ud37c\ub294 \ub098\uc911\uc5d0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Touch Count\uac00 \uc99d\uac00\ub418\uac70\ub098 \ub514\uc2a4\ud06c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85c Page Out\ub420 \uac83\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\">4.1.4. HOT TO COLD MOVEMENT<\/p>\n<p style=\"margin-left: 4em;\">\ubc84\ud37c\uac00 Cold Region\uc5d0\uc11c Hot Region\uc73c\ub85c(LRU \uccb4\uc778\uc758 MRU end\ub85c) \uc774\ub3d9\ub418\uba74 Midpoint&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">Marker\ub294 1 position \uc774\ub3d9\ud560 \uac83\uc774\ub2e4. \uc774\uac83\uc774 \ubc1c\uc0dd\ud560 \ub54c \ub610\ud55c \ubcc4\ub2e4\ub978 Fault\uac00 \uc5c6\uc744 \uacbd\uc6b0 \ubc84<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud37c\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Hot Region\uc5d0\uc11c Cold Region\uc73c\ub85c\uc758 Threshold\ub97c Cross over\ud558\ub3c4\ub85d \ud560 \uac83\uc774\ub2e4. \ubc84<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud37c\uc758 Touch Count\uac00 250\uc77c\uc9c0\ub77c\ub3c4 \ub9cc\uc57d Threshold\ub97c Cross\ud558\uba74 Touch Count\ub294 1\ub85c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc14b<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud305\ub420 \uac83\uc774\ub2e4. Threshold Crossing Touch Count Reset\uac12\uc740 <span style=\"color: rgb(255, 0, 0);\"><b>_db_aging_cool_count<\/b><\/span> \ud30c\ub77c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uba54\ud130\ub85c \uc81c\uc5b4\ub41c\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 2em;\"><\/p>\n<p>5. \ud130\uce58 \uce74\uc6b4\ud2b8 \uc131\ub2a5 \ud29c\ub2dd<\/p>\n<p>Performance Tuning\uc740 \uba87 \uac1c\uc758 \uae30\ubcf8\uc801\uc778 \ub2e8\uacc4\ub4e4\ub85c \uad6c\uc131\ub41c\ub2e4. \uba3c\uc800 \uc2dc\uc2a4\ud15c\uc744 \ubaa8\ub2c8\ud130\ub9c1 \ud574<span style=\"font-size: 9pt; line-height: 1.5;\">\uc57c \ud558\uba70 \ub2e4\uc74c\uc73c\ub85c Contention\uc774\ub098 \ubb38\uc81c\uac00 \uc874\uc7ac\ud55c\ub2e4\uba74 \uc774\ub97c \ud310\ubcc4\ud574 \ub0b4\uc57c \ud560 \uac83\uc774\ub2e4. \ub2e4\uc74c\uc73c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85c \ubd84\uc11d\uc774&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub8e8\uc5b4\uc838\uc57c \ud558\uba70 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \ud574\uacb0 \ubc29\uc548\uc774 \ub9c8\ub828\ub418\uc5b4\uc57c \ud55c\ub2e4. <\/span><span style=\"font-size: 9pt; line-height: 1.5;\">&nbsp;\uc624\ub77c\ud074\uc758 \ubc84\ud37c \uce90\uc2dc \ubaa8\ub2c8\ud130\ub9c1 \ubc29\ubc95\uacfc Touch-count \uc54c\uace0\ub9ac\uc998 \uae30\ubc18\uc5d0\uc11c \uc801\uc808\ud55c \ud30c\ub77c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uba54\ud130\ub97c \ud1b5\ud558\uc5ec \uc81c\uc5b4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub97c \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\ub4e4\uc774\ub2e4.<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 2em;\">5.1. Touch-count Performance Monitoring<\/p>\n<p style=\"margin-left: 2em;\">\uc624\ub77c\ud074 \ubc84\ud37c \uce90\uc2dc\uc758 \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud558\ub294 \uac83\uc740 \uc54c\uace0\ub9ac\uc998\uc5d0 \ub3c5\ub9bd\uc801\uc774\ub2e4. \uadf8\ub7ec\ub098 \ubc84\ud37c \uce90\uc2dc\uc640&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\uad00\ub828\ub41c \ubb38\uc81c\uac00 \ud655\uc778\ub418\uc5c8\ub2e4\uba74 \ud574\uacb0\ud560 \ubc29\ubc95\uc740 \uc54c\uace0\ub9ac\uc998\uc5d0 \ub530\ub77c \ub2e4\ub974\uac8c \ub420 \uac83\uc774\ub2e4. \ubc84\ud37c \uce90\uc2dc<\/span><\/p>\n<p style=\"margin-left: 2em;\">\uc758 \ubb38\uc81c\uc810\uc774\ub098 \uc774\ub85c \uc778\ud55c <span style=\"color: rgb(255, 0, 127);\"><b><span style=\"color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);\">\uc624\ub77c\ud074 \uc11c\ubc84 \uae30\ubc18 \uc131\ub2a5 \ubb38\uc81c\uc810\uc744 \uc815\ud655\ud558\uac8c \ud310\ubcc4\ud574 \ub0bc \uc218 \uc788\ub294 \uac00<\/span><\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 127);\"><b><span style=\"color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);\">\uc7a5 \uc88b\uc740 \ubc29\ubc95\uc740 Response Time\uacfc \uc774\uc758 \ucef4\ud3ec\ub10c\ud2b8\ub4e4\uc744 \ubaa8\ub2c8\ud130\ub9c1<\/span><\/b><\/span>\ud558\ub294 \uac83\uc774\ub2e4.<\/span><b style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(9, 0, 255);\">Response Time \ubd84\uc11d\uc740 Service Time\uacfc Queue Time\uc744 \ubaa8\ub450 \uace0\ub824<\/span><\/b><span style=\"font-size: 9pt; line-height: 1.5;\">\ud574\uc57c \ud55c\ub2e4. <\/span><u style=\"font-size: 9pt; line-height: 1.5;\">Service&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">Time\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc624\ud30c\ub808\uc774\uc158(\uc608: Buffer Cache Management)\ub3d9\uc548 CPU\uac00 \uc0ac\uc6a9\ud55c \uc2dc<\/span><\/u><span style=\"font-size: 9pt; line-height: 1.5;\"><u>\uac04<\/u>\uc774\uba70&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><u>Queue Time\uc740 CPU\uac00 \ud504\ub85c\uc138\uc2f1\uc744 \uacc4\uc18d\ud558\uae30 \uc704\ud558\uc5ec \ubb34\uc5c7\uc778\uac00(\uc608:latcing)\ub97c \uae30\ub2e4\ub9b0<\/u><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><u>\uc2dc\uac04<\/u>\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Ratio Based Analysis\ub294 Service Time\uc774\ub098 Queue Time\uc744 \uace0\ub824\ud558\uc9c0 \uc54a\uc73c\uba70 \uc624<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub77c\ud074 \uc2dc\uc2a4\ud15c\uc758 \ud65c\ub3d9\uc131\uc5d0 \ud3ec\ucee4\uc2a4\ub97c \ub9de\ucd98\ub2e4. Session Wait Analysis\ub294 Queue Time\uacfc \uc774\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ucef4\ud3ec\ub10c\ud2b8\ub97c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud310\ubcc4\ud574\ub0b4\ub098 Service Time\uc740 \uace0\ub824\ub418\uc9c0 \uc54a\ub294\ub2e4. \uc774\uac83\uc740 \ub54c\ub54c\ub85c \ubb38\uc81c\ub97c \ud574\uacb0\ud568\uc5d0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc788\uc5b4 \uadf8\ub987\ub41c \ubc29\ud5a5\uc73c\ub85c \uc774\ub04c\uac8c \ud560 \uc218 \uc788\ub2e4. Response Time Analysis\ub294 Service Time\uacfc&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Queue Time\uc744 \ubaa8\ub450&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uace0\ub824\ud558\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc81c\uc801\uc778 \ubb38\uc81c\uac00 \uc5b4\ub514\uc5d0 \uc788\ub294 \uc9c0\ub97c \uc815\ud655\ud558\uac8c \ubd84\uc11d\ud574&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub0bc \uc218 \uc788\ub2e4. <span style=\"color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);\">Queue Time\uc758 \ucef4\ud3ec\ub10c\ud2b8\ub4e4\uc774 \ud310\ubcc4\ub418\uace0 \uce74\ud14c\uace0\ub9ac\ud654\ub418\uba74&nbsp;<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5; color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);\">\uc131\ub2a5\uc0c1\uc758 Bottleneck<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);\">\uc774 \uc815\ud655\ud558\uac8c \ud310\ubcc4<\/span>\ub41c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub9cc\uc57d \ubc84\ud37c \uce90\uc2dc\uac00 \uc8fc\uc694\ud55c \ubb38\uc81c \uc694\uc778\uc774\ub77c\uba74 Queue Time\uc774 Service Time\ubcf4\ub2e4 \ub192\uc744 \uac83\uc774&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uace0 \ub2e4\uc74c\uc758 \uc624\ub77c\ud074 Wait Event\uc911 \ud558\ub098\uac00 Queue Time\uc758 \ub300\ubd80\ubd84\uc744 \uc18c\ubaa8\ud560 \uac83\uc774\ub2e4.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 2em;\"><b><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc84\ud37c \uce90<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc2dc\uc640 \uad00\ub828\ub41c Wait Event\ub4e4\ub85c\ub294 LRU chain latch, free buffer wait, cache buffer chains&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">latch, buffer busy wait, db file sequential read(index based physical reads),&nbsp;<\/span><\/b><span style=\"font-size: 9pt; line-height: 1.5;\"><b>db file&nbsp;<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b>scattered read(full-table scan based physical reads)\uac00 \uc788\ub2e4<\/b>. \ubc84\ud37c \uce90\uc2dc Contention\uc774&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc1c\uacac\ub418\uace0 Touch-count \uc54c\uace0\ub9ac\uc998\uc774 \uc0ac\uc6a9\ub418\uc5c8\ub2e4\uba74 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uae30 \uc704\ud55c \uac00\ub2a5\ud55c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc77c \ub4e4\ub85c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Touch-count\uc640 \uad00\ub828\ub41c \ud30c\ub77c\uba54\ud130\ub97c \uc870\uc808\ud558\ub294 \uac83\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 2em;\"><\/p>\n<p style=\"margin-left: 2em;\">5.2. Classic Buffer Cache Performance Tuning<\/p>\n<p style=\"margin-left: 2em;\">Touch-count \uad00\ub828\ub41c \ud30c\ub77c\uba54\ud130\uc758 \uc870\uc808\uc740 \ubc84\ud37c \uce90\uc2dc \uc131\ub2a5 \uc774\uc288\ub97c \ud574\uacb0&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\ud558\ub294\ub370\uc5d0 \ud6a8\uacfc\uc801\uc774\uba70 \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud1b5\ud574 \ud310\ubcc4\ub41c Wait Event\ub4e4\uc740 \uc544\ub9c8\ub3c4 \ucd5c\uace0\uc758 \uc194\ub8e8\uc158\uc744 \uc81c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uacf5\ud560 \uac83\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc544\ub798\uc5d0 \ubc84\ud37c \uce90\uc2dc\uc640 \uad00\ub828\ub41c \uc8fc\uc694\ud55c Wait Event\uc5d0 \ub300\ud55c \uac04\ub7b5\ud55c \ub9ac\uc2a4\ud2b8\uac00 \uc788<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4. \uc774 \ub9ac\uc2a4\ud2b8\ub294 \uc774\ub4e4 wait event\uac00 \ubb34\uc5c7\uc778\uac00 \ubcf4\ub2e4 \uc5b4\ub5bb\uac8c \ud574\uacb0\ud574\uc57c \ud558\ub294 \uac00\uc5d0 \ub300\ud55c \ub0b4\uc6a9<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>LRU chain latch wait <\/b><\/span>Touch\ub41c cache block\uc758 \uc218\uc640 LRU chain lath\ub97c \uc694\uccad\ud558\ub294 \ud504\ub85c<span style=\"font-size: 9pt; line-height: 1.5;\">\uc138\uc2a4 \uc218\ub97c \uac10\uc18c\uc2dc\ud0a4\uace0 LRU latch \uc218\ub97c \uc99d\uac00\uc2dc\ud0a8\ub2e4. \ub610\ud55c Latch Hold Duration\uc744 \uc904\uc774\uace0<\/span><\/p>\n<p style=\"margin-left: 14em;\">CPU\ub97c \uc99d\uc124\ud558\uace0 \ubcf4\ub2e4 \ube60\ub978 CPU\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud55c\ub2e4.&nbsp;<\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>Free buffer wait<\/b><\/span> I\/O Subsystem Throughput capacity\ub97c \uc99d\uac00\uc2dc\ud0a4\uace0 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc774<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubcf4\ub2e4 \uc791\uc740 \ub7c9\uc758 dirty block\uc744 \ubc1c\uc0dd\uc2dc\ud0a4\ub3c4\ub85d&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc218\uc815\ud55c\ub2e4. <span style=\"color: rgb(0, 0, 0);\">DBWR\uc5d0\uac8c \ubcf4\ub2e4 \ub9ce\uc740 \ud30c\uc6cc\ub97c \ubd80\uc5ec&nbsp;<\/span><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(0, 0, 0);\">\ud558\uace0&nbsp;<\/span><\/span><\/p>\n<p style=\"margin-left: 12em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(0, 0, 0);\">\ub370\uc774\ud130 \ube14\ub85d \ubc84\ud37c \uc218\ub97c \uc99d\uac00\ud558\ub3c4\ub85d \ud55c\ub2e4<\/span><span style=\"color: rgb(0, 0, 0);\">.&nbsp;<\/span><\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>Buffer busy wait<\/b><\/span> \ub3d9\uc77c\ud55c \ubc84\ud37c\uac00 busy\ud558\uac70\ub098 busy\ud55c \ubc84\ud37c\uac00 \ub9ce\uc740\uc9c0\ub97c \ud310\ubcc4\ud558\ub3c4\ub85d \ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub9cc\uc57d \ub3d9\uc77c\ud55c \ubc84\ud37c\uac00 busy\ud558\ub2e4\uba74 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc218\uc815\ud558\uace0 \ube14\ub85d\uc758 Popularity\ub97c&nbsp;<\/span><\/p>\n<p style=\"margin-left: 12em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">\uc904\uc774\ub3c4\ub85d&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud55c\ub2e4. \ub9cc\uc57d \ub9ce\uc740 \ubc84\ud37c\ub4e4\uc774 busy\ud558\ub2e4\uba74 I\/O subsystem throughput capacity\ub97c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc99d\uac00\uc2dc\ud0a4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac70\ub098 busy buffer \uc218\ub97c \uc904\uc774\ub3c4\ub85d \ud55c\ub2e4.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>Cache buffer chains latch wait<\/b><\/span> \ubc84\ud37c \uce90\uc2dc\ub0b4\uc5d0 \ub3d9\uc77c \ube14\ub85d\uc5d0 \ub300\ud55c \ub9ce\uc740 \uce74\ud53c\ubcf8\uc774 \uc874\uc7ac<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud558\ub294 \uc9c0\ub97c \ud310\ubcc4\ud55c\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub9cc\uc77c \ub9ce\uc740 \uce74\ud53c\ubcf8\uc774 \uc874\uc7ac\ud55c\ub2e4\uba74 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc218\uc815\ud558\uac70\ub098&nbsp;<\/span><\/p>\n<p style=\"margin-left: 18em;\"><span style=\"font-size: 9pt; line-height: 1.5;\">&nbsp; &nbsp;\ube14\ub85d\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">popularity\ub97c \uac10\uc18c\uc2dc\ud0a8\ub2e4. \uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74 \ube14\ub85d \ubc84\ud37c\uc640 hash bucket \uc218\ub97c \uc99d\uac00\uc2dc\ud0a4\uace0 \ubcf4\ub2e4&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ube60\ub978 CPU\ub97c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc0ac\uc6a9\ud558\ub3c4\ub85d \ud55c\ub2e4.&nbsp;<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>Db file sequential or scattered read waits<\/b><\/span> \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\ub0b4 Physical I\/O\ub97c \uc904\uc774\ub3c4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85d \uc218\uc815\ud558\uace0 I\/O subsystem throughput capacity\ub97c \uc99d\uac00\uc2dc\ud0a8\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><\/p>\n<p style=\"margin-left: 2em;\">5.3. \ud130\uce58 \uce74\uc6b4\ud2b8 \ubcc0\uc218 \ud29c\ub2dd \ubc29\ubc95<\/p>\n<p style=\"margin-left: 2em;\">&nbsp;\ubbff\uc744 \ub9cc\ud55c \uacbd\ud5d8\uce58\uac00 \uc5c6\uc744 \uacbd\uc6b0\uc5d0\ub294&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\"><b>\uc801\uc808\ud558\uace0 \uc2e0\ube59\uc131 \uc788\ub294 \ud14c\uc2a4\ud2b8\ub97c \uc218\ud589\ub418\uc5b4\uc57c \ud55c\ub2e4.<\/b> \uc774 \uc7a5\uc5d0\uc11c\ub294 \uba3c\uc800 \uad00\ub828\ub41c Touch count&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud30c\ub77c\uba54\ud130\ub4e4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5d0 \ub300\ud574\uc11c \ub098\uc5f4\ud558\uc5ec \uac04\ub7b5\ud558\uac8c \uc124\uba85<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud558\uaca0\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 2em;\"><\/p>\n<p style=\"margin-left: 4em;\">5.3.1. Touch-Count Instance Parameters<\/p>\n<p style=\"margin-left: 4em;\">5\uac1c\uc758 Touch-count \uad00\ub828\ub41c \ud30c\ub77c\uba54\ud130\ub4e4\uc774 \uc788\uc73c\uba70 \uc774\ub4e4\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc787\uc810\uc744 \uc5bb\uc744 \uc218 \uc788\ub2e4.&nbsp;<\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_percent_hot_default<\/b><\/span> Hot Region\ub0b4 Block Buffer\uc758 Percentage (\ub514\ud3f4\ud2b8&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">50 %)<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_aging_touch_time<\/b><\/span> \ubc84\ud37c\uc758 Touch Count \uc99d\uac00 Time Window(\ub514\ud3f4\ud2b8 3\ucd08)<\/p>\n<p style=\"margin-left: 4em;\"><b><span style=\"color: rgb(255, 0, 0);\">_db_aging_hot_creiteria<\/span><\/b> \ubc84\ud37c\uac00 LRU \uccb4\uc778\uc758 MRU end\ub85c \uc774\ub3d9\ub420 Threshold (\ub514\ud3f4<span style=\"font-size: 9pt; line-height: 1.5;\">\ud2b8 2 touch count)<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_aging_stay_count<\/b><\/span> \ubc84\ud37c\uac00 LRU \uccb4\uc778\uc758 MRU end\ub85c \uc774\ub3d9\ub420 \ub54c\uc758 Touch Count&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\ub9ac\uc14b\uac12(\ub514\ud3f4\ud2b8 0 touch count)<\/span><\/p>\n<p style=\"margin-left: 4em;\"><b><span style=\"color: rgb(255, 0, 0);\">_db_aging_cool_count<\/span><\/b> \ube14\ub85d\uc774 Hot Region\uc5d0\uc11c Cold Region\uc73c\ub85c \uc774\ub3d9\ub420 \ub54c\uc758 \ub2e4\uc2dc&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\ubd80\uc5ec\ub420 Touch Count \uac12(\ub514\ud3f4\ud2b8 1 touch count)<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\">5.3.2. Research Setup<\/p>\n<p style=\"margin-left: 4em;\">\ub300\ubd80\ubd84\uc758 \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\uba54\ud130\ub85c \uc778\ud55c \uc77c\ubc18\uc801\uc778 \uc601\ud5a5\uc131\ub4e4\uc740 \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0\uc5d0 \uc608\uce21 \uac00\ub2a5\ud558\uc9c0\ub9cc&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">Touch Count \ud30c\ub77c\uba54\ud130\uc758 \ubcc0\uacbd\uc740 \uadf8\ub9ac \uc26c\uc6b4 \uc77c\uc774 \uc544\ub2c8\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc77c\ubd80 \uc798\ubabb\ub41c \uc0dd\uac01\uacfc \uac1c\uc778\uc801\uc778 \uacac<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud574\ub4e4\uc744 \uc81c\uac70\ud558\uae30 \uc704\ud558\uc5ec \uc77c\ub828\uc758 \uc815\ubc00\ud55c \ud14c\uc2a4\ud2b8\ub97c \uc218\ud589\ud558\uc600\uc73c\uba70 \uc5ec\uae30\uc5d0\uc11c \uadf8\uac83\uc5d0 \ub300\ud558\uc5ec \uac04<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub7b5\ud558\uac8c \uc124\uba85\ud558\uaca0\ub2e4.<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud14c\uc2a4\ud2b8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0 4 \uac00\uc9c0 \ud0c0\uc785\uc758 \uc2a4\ud2b8\ub808\uc2a4\ub97c \ubd80\uc5ec\ud558\uae30 \uc704\ud558\uc5ec \uc14b\ud305\ud558\uc600\ub2e4.<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">4\uac00\uc9c0 \ud0c0\uc785\uc758 \uc2a4\ud2b8\ub808\uc2a4\ub294 cache buffer chain latch contention, LRU latch contention,<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">free buffer wait contention, full table scan and index physical read wait contention<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\uc5c8\ub2e4. \uac01 \uc720\ud615\ubcc4 \uc2a4\ud2b8\ub808\uc2a4\ub97c \ubd80\uc5ec\ud558\uae30 \uc704\ud558\uc5ec \ud2b9\uc815 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\ud589\ud558\uc600\uc73c\uba70 \ub2e4\uc591\ud55c \ud30c\ub77c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uba54\ud130\ub97c \uc758\ub3c4\uc801\uc73c\ub85c \uc14b\ud305\ud560 \uc218 \uc788\uc5c8\ub2e4. \uadf8\ub7ec\ub098 LRU \uc54c\uace0\ub9ac\uc998\uc774 \ud604\uc7ac \uc798 \uc791\ub3d9\ub418\uace0 \uc788\ub294\uc9c0\ub97c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc54c\uc544\ub0bc \uc218 \uc788\ub294 LRU latch contention\uc740 \uc758\ub3c4\ud574\ub0bc \uc218\uac00 \uc5c6\uc5c8\ub2e4.<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Latch wait\ub97c \uc704\ud574\uc11c \u201clatch impact\u201d\ub77c\uace0 \ubd88\ub9ac\ub294 \uac83\uc744 \uae30\ub85d\ud558\uc600\ub2e4. Latch Impact\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">v$latch\uc5d0 \uadfc\uac04\ud55c \uac04\ub2e8\ud55c \uacc4\uc0b0\uc73c\ub85c\uc11c sleep*(sleeps\/decode(gets,0,1,gets))\uc640 \uac19\uc740 \uac83\uc774<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4. Touch-count \ud30c\uba54\ud130\uac00 latch\uc758 \ud65c\ub3d9\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 \uc9c0\uc758 \uc5ec\ubd80\ub97c \ud310\ubcc4\ud558\uae30 \uc704\ud558\uc5ec&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">latch impact\ub97c \uae30\ub85d\ud558\uc600\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Non-latching waits-free buffer waits,&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">physical read watis from a full table or index&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">scan-\uc744 \uc704\ud558\uc5ec \uc2e4\uc81c wait time\uc744 \uae30\ub85d\ud558\uc600\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac01\uac01\uc758 \uc2a4\ud2b8\ub808\uc2a4\uc640 \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\uba54\ud130 \uc218\uc815\uc5d0 \uc55e\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc2dc\uc2a4\ud15c\uc744 Recycle\ud558\uc600\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uadf8\ub9ac\uace0 \ub098\uc11c \uc2dc\uc2a4\ud15c\uc5d0 \uc2a4\ud2b8\ub808\uc2a4\ub97c \uc8fc\uae30 \uc2dc\uc791\ud558\uc600\uc73c\uba70 \uc774\ub294 60\ucd08\uc758 warm-up period\ub85c \uc9c4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud589\ub418\uc5c8\ub2e4. 1\ubd84 \uac04\uaca9\uc73c\ub85c 13\ubc88 \uc218\ud589\ud558\uace0 \ub098\uc11c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc624\ub77c\ud074\uacfc \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\uc600\ub2e4. \uc218<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc9d1\ub41c \ud1b5\uacc4\uc815\ubcf4\ub97c \ubc14\ud0d5\uc73c\ub85c \ud558\uc5ec touch-count \ud30c\ub77c\uba54\ud130\uac00 \uc2dc\uc2a4\ud15c\uc5d0 \uc8fc\ub294 \uc601\ud5a5\uc131\uc5d0 \ub300\ud558\uc5ec&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac80\uc99d\ud560 \uc218 \uc788\uc5c8\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\">5.3.3. Research and Thought Analysis<\/p>\n<p style=\"margin-left: 4em;\">\uccab\uc9f8\ub85c \uadf8\ub9ac\uace0 \ubb34\uc5c7\ubcf4\ub2e4 \uc911\uc694\ud55c \uac83\uc740 \ub9cc\uc57d Response Time \ubd84\uc11d \ub0b4\uc6a9\uc911 queue time \ubb38\uc81c<span style=\"font-size: 9pt; line-height: 1.5;\">\uc5d0\uc11c buffer cache contention\uc774 \uc8fc\uc694\ud558\uc9c0 \uc54a\ub2e4\uba74 touch count \ud30c\ub77c\uba54\ud130\uc5d0 \ub300\ud55c \uace0\ub824\ub294<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud070 \uc758\ubbf8\uac00 \uc5c6\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc740 \uacbd\uc6b0 touch count \ud30c\ub77c\uba54\ud130\ub294 \uc8fc\uc694\ud55c \uac12\uc744 \uac00\uc9c8 \uc218 \uc788\uac8c \ub41c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc218\ud589\ud588\ub358 \uac01 \ud14c\uc2a4\ud2b8\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc81c\uc2dc\ud560 \uac83\uc774\ub2e4. \ub2e4\uc74c \uc544\ub798\uc5d0\uc11c 5\uac1c\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc8fc\uc694\ud55c touch-count \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\uba54\ud130\uc758 \uc218\uc815\uc5d0 \uad00\ud55c \uacac\ud574\ub97c \ub098\uc5f4\ud558\uc600\ub2e4. \ub0b4\uac00 \ud76c\ub9dd\ud558\ub294&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc14\ub294 \uc774\uac83\uc774 \uc5ec\ub7ec\ubd84\ub4e4\uc758 \ud2b9\uc218\ud55c \uc2dc\uc2a4\ud15c \ubd84\uc11d \ud658\uacbd\uc0c1\uc5d0\uc11c \uc5b4\ub5a0\ud55c \ubc29\ud5a5\uacfc \ucd09\ub9e4\uc81c\ub85c\uc11c\uc758 \uc5ed\ud560<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc744 \ud558\uace0\uc790 \ud558\ub294 \uac83\uc774\ub2e4. \ub2e4\uc2dc \ud55c\ubc88 \uc6b0\ub9ac\uc758 \ubaa9\uc801\uc744 \uc0c1\uae30\ud558\uc790\uba74 \ubc84\ud37c\uc758 \uc774\ub3d9\uc744 \ucd5c\uc18c\ud654\ud558\uace0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><span style=\"color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);\"><b>Most Popular Block\uc774 \uce90\uc2f1\uc744 \uc720\uc9c0\ud558\ub294 \uac83<\/b><\/span>\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_percent_hot_default<\/b><\/span> \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130\uc5d0 \uc758\ud558\uba74 latch activity(cache buffer&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">chains latch and LRU latch)\uc640 free buffer wait time\uc740 \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\ub97c \uc218\uc815\ud568\uc73c\ub85c\uc368&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud06c\uac8c \uc601\ud5a5\uc744<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">&nbsp;\ubc1b\ub294 \uac83\uc73c\ub85c \ub098\ud0c0\ub0ac\ub2e4. \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130\uc5d0 \uadfc\uac04\ud558\uba74 \ucd5c\uc801\uc758 \uc14b\ud305\uac12\uc740&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Contention\uc5d0 \ub530\ub77c \ub2e4\ub978 \uac83\uc73c\ub85c \ub098\ud0c0\ub098\uace0 \uc788\ub2e4. \ub370\uc774\ud130\ub294 \ubc84\ud37c \uce90\uc2dc\uc758 75% \ud639\uc740 \uadf8 \uc774\uc0c1<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc744 Hot Region\uc73c\ub85c \uc7a1\uc558\uc744 \uacbd\uc6b0 \uc131\ub2a5\uc5d0 \ud574\ub85c\uc6b4 \uac83\uc73c\ub85c \ub098\ud0c0\ub098\uace0 \uc788\ub2e4. \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\uc758 \ubcc0<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uacbd\uc774 scattered read waits(physical FTS read waits)\uc5d0 \ud1b5\uacc4\uc801\uc73c\ub85c \uc8fc\uc694\ud55c \uc601\ud5a5\uc744 \uc8fc\uc9c0<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc54a\ub294 \uac83\uc740 \ud765\ubbf8\ub85c\uc6b4 \uc77c\uc774\ub2e4. \ub9cc\uc57d \ubcf4\ub2e4 \ub9ce\uc740 \ube14\ub85d\uc744 Hot \uc601\uc5ed\uc73c\ub85c \uc7a1\uc744 \uac83\uc744 \uace0\ub824\ud558\uace0 \uc788<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub2e4\uba74 \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\ub97c \uc99d\uac00\uc2dc\ud0a4\ub3c4\ub85d \ud558\uba70 \ubc18\ub300\ub85c Cold \uc601\uc5ed\uc73c\ub85c \ubcf4\ub2e4 \ub9ce\uc740 \ube14\ub85d\uc744 \uc62e\uae30\uace0&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc2f6\ub2e4\uba74 \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\ub97c \uac10\uc18c\uc2dc\ud0a4\ub3c4\ub85d \ud55c\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_aging_touch_time<\/b><\/span> \ube14\ub85d\uc758 \uc774\ub3d9\uc774\ub098 Popular \ube14\ub85d\uc758 \ud65c\ubc1c\ud55c \ud65c\ub3d9\uc774 \uae09\uaca9\ud558\ub2e4\uba74&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\ud574\ub2f9 \ud30c\ub77c\uba54\ud130\ub97c \uc99d\uac00\uc2dc\ud0b4\uc73c\ub85c\uc368 Movement Threshold\uc5d0 \ub3c4\ub2ec\ud558\ub294 \uac83\uc744 \uac10\uc18c\uc2dc\ud0ac \uc218 \uc788\uc73c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uba70 \ub530\ub77c\uc11c \ubc84\ud37c\uc758 \uc774\ub3d9\uc744 \uac10\uc18c\uc2dc\ud0ac \uc218 \uc788\ub2e4. \uc2ec\uac01\ud55c cache buffer lru chains latch\ub098 LRU&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">latch contention\uc740 \ube14\ub85d\uc758 \uc774\ub3d9\uc774 \uacfc\ub2e4\ud568\uc744 \ub098\ud0c0\ub0b4\ub294 \uac83\uc73c\ub85c \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\ub97c \uc99d\uac00\uc2dc\ud0b4\uc73c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85c\uc368 \uac11\uc791\uc2a4\ub7f0 \uc131\ub2a5 \uc800\ud558\uc640 \ubc84\ud37c\uc758 \uc774\ub3d9\uc744 \uac10\uc18c\uc2dc\ud0ac \uc218 \uc788\ub2e4. \uadf8\ub7ec\ub098 \ubc18\ub4dc\uc2dc \uc8fc\uc758\ub97c \uc694\ud574\uc57c&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud55c\ub2e4. \ud574\ub2f9 \ud30c\ub77c\uba54\ud130 \uac12\uc744 \ub108\ubb34 \ud06c\uac8c \uc7a1\uc73c\uba74 Popular Block\uc758 Devaluing \ud604\uc0c1\uc774 \ub098\ud0c0\ub09c\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><b><span style=\"color: rgb(255, 0, 0);\">_db_aging_hot_creiteria<\/span><\/b> \ube14\ub85d\uc758 \uc774\ub3d9 \ud604\uc0c1\uc744 \ub2a6\ucd94\uace0 \uc2f6\ub2e4\uba74 \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\uc758 \uac12\uc744&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\uc99d\uac00\uc2dc\ud0a4\ub3c4\ub85d \ud55c\ub2e4. \ube14\ub85d\uc758 \uc774\ub3d9 \ud604\uc0c1\uc744 \ub2a6\ucd94\uc5b4\uc57c \ud544\uc694\uc131\uc774 \uc788\ub2e4\ub294 \uac83\uc740 cache buffer&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">chains latch\ub098 LRU latch contention\uc774 \uc2ec\uac01\ud558\uac8c \ubc1c\uacac\ub418\uace0 \uc788\ub2e4\ub294 \uac83\uc774\ub2e4. \ubc84\ud37c\uac00 \uc774\ub3d9\ub418<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub294 \uac83(to the MRU end of the list)\uc744 \uc5b4\ub835\uac8c \ub9cc\ub4e4\uace0 \uc2f6\ub2e4\uba74 \ud574\ub2f9 \ud30c\ub77c\uba54\ud130 \uac12\uc744 \uc99d\uac00\uc2dc\ud0a4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub3c4\ub85d \ud55c\ub2e4. \uac12\uc744 \uc99d\uac00\uc2dc\ud0ac \uacbd\uc6b0 \uc9c4\uc815\ud55c Popular Block\ub4e4\ub9cc\uc774 \uce90\uc2dc\ub0b4\uc5d0 \uc720\uc9c0\ub420 \uc218 \uc788\ub3c4\ub85d&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud560 \uc218 \uc788\uc744 \uac83\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_aging_stay_count <\/b><\/span>Popular Block\uc774 \ub9e4\uc6b0 \ube48\ubc88\ud558\uac8c \uce90\uc2dc\uc5d0\uc11c \ubc00\ub824\ub0a0 \uacbd\uc6b0&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">(buffer cache hit ratio\uac00 \ub0ae\uc744 \uac83\uc784) \ud574\ub2f9 \ud30c\ub77c\uba54\ud130\ub97c \uc99d\uac00\uc2dc\ud0b4\uc73c\ub85c\uc368 Polular Block\uc774 \uce90\uc2dc&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub0b4\uc5d0 \ubcf4\ub2e4\uc624\ub798 \uba38\ubb34\ub97c \uc218 \uc788\ub3c4\ub85d \ud560 \uac83\uc774\ub2e4. \uadf8\ub7ec\ub098 \ud574\ub2f9 \ud30c\ub77c\uba54\ud130 \uac12\uc744 \uc9c0\ub098\uce58\uac8c \uc99d\uac00&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc2dc\ud0ac \uacbd\uc6b0 nearly-Popular Block\ub4e4\uc774 \ucd08\uae30\uc5d0 \uc2e4\uc81c\ub85c\ub294 \ub9ce\uc774 \uc5b5\uc138\uc2a4\uac00 \ub418\uc9c0 \uc54a\uc558\uc74c\uc5d0\ub3c4 \ub192<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc740 Touch-count\ub97c \uc5bb\uac8c\ub418\ub294 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud560 \uc218\ub3c4 \uc788\ub2e4. \uc989, \ubcf8\uc9c8\uc801\uc73c\ub85c High Touch-count&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc758 \uc758\ubbf8\uc640 \uac12\uc744 \uac10\uc18c\uc2dc\ud0a4\uac8c \ud558\ub294 \uac83\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"color: rgb(255, 0, 0);\"><b>_db_aging_cool_count<\/b><\/span> \ud574\ub2f9 \ud30c\ub77c\uba54\ud130 \uac12\uc744 \uc99d\uac00\uc2dc\ud0b4\uc73c\ub85c\uc368 \ube14\ub85d\ub4e4\uc774 \uce90\uc2dc\ub0b4\uc5d0 \uba38\ubb34<span style=\"font-size: 9pt; line-height: 1.5;\">\ub974\ub294 \uac83\uc744 \ubcf4\ub2e4 \uc27d\uac8c \ud560 \uc218 \uc788\uc73c\uba70 Cooling Affect\uac00 \ubcf4\ub2e4 \ucc9c\ucc9c\ud788 \uadf8\ub9ac\uace0 \uae09\uaca9\ud558\uc9c0 \uc54a\uac8c \ub098<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud0c0\ub098\uc9c0 \uc54a\ub3c4\ub85d \ud558\uc5ec \uc900\ub2e4. \ub9cc\uc57d Popular Block\uc774 \uce90\uc2dc\uc5d0\uc11c \ube68\ub9ac \ubc00\ub824\ub09c\ub2e4\uba74(buffer cache&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">hit ratio\uac00 \ub0ae\uc744 \uac83\uc784) \ud574\ub2f9 \ud30c\ub77c\uba54\ud130 \uac12\uc744 \uc99d\uac00\uc2dc\ud0b4\uc73c\ub85c\uc368 \uc774 \ube14\ub85d\ub4e4\uc774 \uce90\uc2dc\ub0b4\uc5d0 \ubcf4\ub2e4 \uc624<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub798 \uba38\ubb34\ub97c \uc218 \uc788\ub3c4\ub85d \ud558\uc5ec \uc904 \uac83\uc774\ub2e4. \uadf8\ub7ec\ub098 \ub108\ubb34 \ub192\uac8c \uc7a1\uc73c\uba70 Unpopular Block\ub4e4\ub3c4 \uce90<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc2dc\uc5d0 \uba38\ubb34\ub974\uac8c \ud558\uc5ec cache buffer chains latch\ub098 LRU latch contention\uc774 \uacfc\ud558\uac8c \ubc1c\uc0dd\ub420&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uac83\uc774\ub2e4.<\/span><\/p>\n<p><\/p>\n<p><\/p>\n<p style=\"text-align: center; clear: none; float: none;\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.2379E8505638111C1E30A7.jpg?resize=640%2C735\" class=\"aligncenter\" width=\"640\" height=\"735\" filename=\"touch_count_test_result.jpg\" filemime=\"image\/jpeg\" data-recalc-dims=\"1\" \/><\/p>\n<p><\/p>\n<p><\/p>\n<p style=\"margin-left: 4em;\">\uc704 \ub3c4\ud45c\ub294 \ud14c\uc2a4\ud2b8 \uacb0\uacfc\uc774\ub2e4. \ub370\uc774\ud130\ub4e4\uc740 \ubcf4\ub2e4 \uc815\ud655\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc5bb\uae30 \uc704\ud558\uc5ec \ub9e4\ucd08\ub2f9 13&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\ubc88 \uc218\ud589\ud558\uc600\ub2e4. \uacb0\uacfc\uc5d0 \ub530\ub974\uba74 <b>_db_percent_hot_default <\/b>\ud30c\ub77c\uba54\ud130\uac12\uc758 \ubcc0\uacbd\uc740 latch\uc640&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">free buffer wait\uc758 \ud65c\ub3d9\uc5d0 \uc0c1\ub2f9\ud55c \uc601\ud5a5\uc744 \uc8fc\ub294 \uac83\uc73c\ub85c \ub098\ud0c0\ub098\uace0 \uc788\ub2e4(90% confidence&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">level). \uadf8\ub7ec\ub098 <b>scattered read wait \ud65c\ub3d9\uc5d0\ub294 \ud070 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \ubabb\ud558\ub294 \uac83\uc73c\ub85c \ub098\ud0c0\ub098\uace0 \uc788<\/b><\/span><span style=\"font-size: 9pt; line-height: 1.5;\"><b>\ub2e4.<\/b> \u201clatch impact\u201d \uac12\uc740 Latch contention \ud65c\ub3d9\uc5d0 \ub300\ud55c \ub2e8\uc21c\ud55c \uacc4\uc0b0\uc774\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 4em;\"><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p>6. Concluding Thoughts<\/p>\n<p>\uc704 \ud14c\uc2a4\ud2b8 \uacb0\uacfc\uc5d0 \uadfc\uac04\ud558\uc5ec \uc138\uac00\uc9c0 \uc8fc\uc694\ud55c \ud3ec\uc778\ud2b8\ub4e4\uc744 \ub3c4\ucd9c\ud574 \ubcf4\uc558\ub2e4.<\/p>\n<p><span style=\"color: rgb(255, 0, 0);\"><b><span style=\"font-size: 11pt;\">1. \uc624\ub77c\ud074\uc740 \ubcc0\ud654\uc5d0 \uc21c\uc751\ud558\uae30 \uc704\ud558\uc5ec \uc774\ub4e4\uc758 \ub0b4\ubd80 \uc54c\uace0\ub9ac\uc998\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \ubcc0\uacbd\ud558\uc600\ub2e4.<\/span><\/b><\/span><\/p>\n<p><b><span style=\"color: rgb(255, 0, 0); font-size: 11pt;\">2. Touch-count \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\uba54\ud130\uc758 \uc870\uc808\uc740 Buffer Cache\uc758 \ud65c\ub3d9\uac00 \uc131\ub2a5 \ub4f1\uc5d0 \uc8fc\uc694\ud55c \uc601<\/span><span style=\"font-size: 11pt; line-height: 1.5; color: rgb(255, 0, 0);\">\ud5a5\uc744 \uc904 \uc218 \uc788\ub2e4.<\/span><\/b><\/p>\n<p><span style=\"color: rgb(255, 0, 0);\"><b><span style=\"font-size: 11pt;\">3. \ubcf4\ub2e4 \uc815\ubc00\ud558\uace0 \ud3ec\uad04\uc801\uc778 \uc5f0\uad6c\uac00 \uc218\ud589\ub420 \ud544\uc694\uc131\uc774 \uc788\ub2e4.<\/span><\/b><\/span><\/p>\n<p><\/p>\n<p>Oracle\uc758 Buffer Cache Management \uc54c\uace0\ub9ac\uc998 \uad00\ub828 \uc790\ub8cc.<\/p>\n<p>8i \uc774\uc804\uae4c\uc9c0 Oracle\uc758 Buffer Cache Management \uc54c\uace0\ub9ac\uc998\uc740 LRU\uc5d0&nbsp;<span style=\"font-size: 9pt; line-height: 1.5;\">\uadfc\uac04\ud558\uc600\uc73c\ub098 \uc2dc\uc2a4\ud15c\uc758 \ud2b8\ub79c\uc7ad\uc158\uacfc \ub370\uc774\ud130\ub7c9\uc774 \ud604\uaca9\ud558\uac8c \uc99d\uac00\ud558\ub294 \ud604\uc0c1&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc18d\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">Buffer Cache\uc758 \ud06c\uae30\ub3c4<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">1G \uc774\uc0c1\ub418\ub294 \uac83\uc774 \uc77c\ubc18&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud654\ub418\uc5b4 \uac00\uace0 \uc788\ub2e4. \uc774\ub7ec\ud55c \ud658\uacbd\uc18d\uc5d0\uc11c \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc73c<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ub85c \uad00\ub9ac\ud558\uae30 \uc704\ud55c Buffer Cache\uc758&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc54c\uace0\ub9ac\uc998\uc0c1\uc758 \ubcc0\ud654\uac00 \ud544\uc694\ub85c \ud558\uac8c \ub418<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc5c8\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">8i\ubd80\ud130 \uad6c\ud604\ub41c Touch-count \uc54c\uace0\ub9ac\uc998\uc740 Buffer Cache \uc0ac\uc774\uc988\uac00 \uc99d\uac00<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ud558\uba74\uc11c \ubc1c\uc0dd\ud558\ub294 \uc131\ub2a5\uc0c1\uc758 \ubb38\uc81c\ub4f1\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud558\uc5ec \uc0c8\ub86d\uac8c \uc81c\uc2dc\ub41c \uac83&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\uc774\ub2e4.&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubcf8 \ubb38\uc11c\ub294 \uc774 Touch-Count \uc54c\uace0\ub9ac\uc998\uc758 \ud788\uc2a4\ud1a0\ub9ac, \uc124\uba85 \ubc0f \uad6c\ud604&nbsp;<\/span><span style=\"font-size: 9pt; line-height: 1.5;\">\ubc29\ubc95, \ud29c\ub2dd \ud3ec\uc778\ud2b8\ub4f1\uc5d0 \ub300\ud558\uc5ec \uc124\uba85\ud558\uace0 \uc788\ub2e4.<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\">\ucd9c\ucc98:Touch_Count_Algorithm&nbsp;<\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n<p><span style=\"font-size: 9pt; line-height: 1.5;\"><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \ud130\uce58 \uce74\uc6b4\ud2b8 \uc18c\uac1c \uc624\ub77c\ud074\uc740 \ubcfc\ub968\uc758 \uc99d\uac00, \uc131\ub2a5\uc0c1\uc758 \uc694\uad6c \ubc0f \ucd5c\uadfc \uc2dc\uc2a4\ud15c\ub4e4\uc758 \ubcf5\uc7a1\uc131 \ub4f1\uc758 \uc774\uc720\ub85c Touch-&nbsp;Count \uc5d0 \uadfc\uac04\ud55c Data Buffer Management Algorithm\uc744 \uc81c\uc2dc\ud558\uc600\ub2e4. \ub370\uc774\ud130 \ube14\ub85d \ubc84\ud37c\ub4e4\uc740 Modified LRU \uc54c\uace0\ub9ac\uc998\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub354 \uc774\uc0c1 \uad00\ub9ac\ub418\uc9c0 \uc54a\ub294\ub2e4. Touch-Count \uc54c\uace0\ub9ac\uc998\uc740 \uc624\ub77c\ud074 8i\ubd80\ud130 \uc18c\uac1c\ub418\uc5c8\ub294\ub370 Latch Contention\uc744 \uc904\uc774\uace0 \ubc84\ud37c \uc131\ub2a5\uc758 \ucd5c\uc801\ud654\ub97c \uc704\ud55c&nbsp;\uae30\ud68c\ub97c \uc99d\uac00\uc2dc\ud0a4\uae30 \uc704\ud574\uc11c\uc774\ub2e4.&nbsp; 2. \ud130\uce58 \uce74\uc6b4\ud2b8 \ub098\uc628 \uc774\uc720 \uc624\ub77c\ud074 \ub370\uc774\ud130 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":505,"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":[71,262,263,264,265],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.2379E8505638111C1E30A7.jpg?fit=851%2C977","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/504"}],"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=504"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/504\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/505"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=504"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}