{"id":421,"date":"2015-09-02T08:28:06","date_gmt":"2015-09-02T08:28:06","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=421"},"modified":"2015-09-02T08:28:06","modified_gmt":"2015-09-02T08:28:06","slug":"statspack%eb%a5%bc-%ed%86%b5%ed%95%9c-%ea%b3%a0%ea%b8%89-%ec%8b%9c%ec%8a%a4%ed%85%9c-%ed%8a%9c%eb%8b%9d","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=421","title":{"rendered":"Statspack\ub97c \ud1b5\ud55c \uace0\uae09 \uc2dc\uc2a4\ud15c \ud29c\ub2dd"},"content":{"rendered":"\n\n\n
\n\n\n\n
\n
Statspack\ub97c \ud1b5\ud55c \uace0\uae09 \uc2dc\uc2a4\ud15c \ud29c\ub2dd<\/span><\/font><\/strong><\/span><\/div>\n
By Rich Niemiec<\/span><\/font><\/em><\/span><\/div>\n
 <\/span><\/div>\n
\ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\ub9ac\uc988 \uc911 \ub450 \ubc88\uc9f8 \ud3b8<\/span><\/font><\/strong><\/i><\/span><\/div>\n
\uc774\uc804 \uce7c\ub7fc\uc5d0\uc11c \uc5b8\uae09\ud588\ub358 \uac83\ucc98\ub7fc, \uc2dc\uc2a4\ud15c \uc131\ub2a5 \ubb38\uc81c\ub97c \ubaa8\ub2c8\ud130\ud558\uace0 \ucc3e\uae30 \uc704\ud574 Oracle9<\/span>i<\/span><\/i> <\/span>\uc720\ud2f8\ub9ac\ud2f0\ub97c \ub450 \uac1c\ub9cc \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4\uba74 \uadf8\uac83\uc740 \ubc18\ub4dc\uc2dc Enterprise Manager\uc640 Statspack\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7f0\ub370, Oracle9<\/span>i<\/span><\/i>\uc5d0\uc11c\ub294 (Oracle8<\/span>i<\/span><\/i> <\/span>Release 8.1.6\uc5d0\uc11c\ucc98\ub7fc) \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ud558\uae30 \uc704\ud574\uc11c STATSPACK\uc744 \uc0ac\uc6a9\ud560 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 STATSPACK\ub294 Oracle\uc758 \uc774\uc804 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9 \uac00\ub2a5\ud558\uc600\ub358 UTLBSTAT\/UTLESTAT \uc2a4\ud06c\ub9bd\ud2b8\ub4e4\uc744 \ub300\uccb4\ud55c \uac83\uc778\ub370, \uadf8 \uc2a4\ud06c\ub9bd\ud2b8\ub4e4\uc744 \ub9ce\uc774 \ubcf4\uc644\ud558\uc5ec \ud6e8\uc52c \ub6f0\uc5b4\ub09c \uc131\ub2a5\uc744 \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
\uc774\uc804\uc5d0, \uc6b0\ub9ac\ub294 \ub300\uae30 \uc774\ubca4\ud2b8\ub4e4\uc744 \ubaa8\ub2c8\ud130\ud558\uace0 \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c \uc5b4\ub5bb\uac8c Statspack \ub9ac\ud3ec\ud2b8\ub97c \uc0ac\uc6a9\ud558\ub294 \uac00\uc5d0 \ub300\ud558\uc5ec \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 \ub798\uce58 \ub300\uae30\ub97c \uc870\uc815\ud558\ub294 \ubb38\uc81c\ub4e4\uacfc \ubb38\uc11c\ud654\ub418\uc9c0 \uc54a\uc740 \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\ub4e4(\ubc11\uc904\ub85c \uc120\ud589\ub41c \ub9e4\uac1c \ubcc0\uc218\ub4e4)\uc744 \ub2e4\ub8f0 \uac83\uc785\ub2c8\ub2e4. \ud55c\ud3b8, \uc774 \ub9e4\uac1c \ubcc0\uc218\ub4e4\uc744 \ubcc0\uacbd\ud558\uae30 \uc804\uc5d0\ub294 Oracle Support\ub97c \ud1b5\ud574 \uac80\uc99d\uc744 \ubc1b\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
<\/font><\/strong><\/span> <\/span><\/div>\n
\ub798\uce58\uc758 \uae30\ubcf8\ub4e4<\/span><\/font><\/strong><\/span><\/div>\n
\ub798\uce58\ub294 \uba54\ubaa8\ub9ac \ub0b4\uc758 \uacf5\uc720 \uba54\ubaa8\ub9ac \uad6c\uc870 (system global area, SGA) \ubcf4\ud638\ub97c \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 \uc0c1\ud638 \ubc30\uc81c \ubc29\ubc95\uc73c\ub85c\uc11c, \ud504\ub85c\uc138\uc2a4\uc5d0 \uc758\ud574\uc11c \ub9e4\uc6b0 \ube68\ub9ac \ud65c\uc131\ud654\ub418\uc5c8\ub2e4\uac00 \ud574\uc81c\ub418\ub294 \uba54\ubaa8\ub9ac \uc0c1\uc758 \uc7a0\uae08\uacfc \ube44\uc2b7\ud55c\ub370, \uacf5\uc720 \uba54\ubaa8\ub9ac \uad6c\uc870\uc5d0 \ub300\ud55c \ub3d9\uc2dc \uc811\uadfc\uc744 \ub9c9\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9\ub418\uc5b4 \uc9d1\ub2c8\ub2e4. \ub9cc\uc57d \ub798\uce58\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4\uba74, \ub798\uce58-\ud504\ub9ac \uc2e4\ud328\uac00 \uae30\ub85d\ub429\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub300\ubd80\ubd84\uc758 \ub798\uce58 \ubb38\uc81c\ub4e4\uc740 \ubc14\uc778\ub4dc \ubcc0\uc218(\ub77c\uc774\ube0c\ub7ec\ub9ac-\uce90\uc2dc \ub798\uce58), \ub9ac\ub450-\uc0dd\uc131 \ubb38\uc81c (\ub9ac\ub450-\ud560\ub2f9 \ub798\uce58), \ubc84\ud37c-\uce90\uc2dc \ucda9\ub3cc \ubb38\uc81c(\uce90\uc2dc-\ubc84\ud37c LRU (least recently used) \uccb4\uc778), \ubc84\ud37c \uce90\uc2dc \ub0b4\uc758 \ud56b \ube14\ub85d (\uce90\uc2dc-\ubc84\ud37c \uccb4\uc778) \ub4f1\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uac83\uacfc \uad00\ub828 \uc788\uc2b5\ub2c8\ub2e4. (\uc77c\ubd80 \ub798\uce58 \ub300\uae30\ub4e4\uc740 \uc81c\ud488 \ubc84\uadf8 \ub54c\ubb38\uc5d0 \ubc1c\uc0dd\ud558\ubbc0\ub85c, Oracle Support\uc758 MetaLink \uc0ac\uc774\ud2b8\ub97c \ud655\uc778\ud574 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4) \ub9cc\uc57d \ub798\uce58 \uc2e4\ud328 \ube44\uc728\uc774 0.5 % \uc774\uc0c1\uc774\ub77c\uba74 \ubb38\uc81c\ub97c \uc870\uc0ac\ud574\uc57c\ub9cc \ud560 \uac83\uc785\ub2c8\ub2e4. (\ub798\uce58 \uc2e4\ud328 \ube44\uc728\uc744 \uad6c\ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798\uc5d0 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4.)<\/span><\/font><\/span><\/div>\n
\ub798\uce58\ub294 \ub450 \uac00\uc9c0 \uc885\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4: willing-to-wait \ub798\uce58\uc640 not-willing-to-wait \ub798\uce58 \u2014 \uccab\ubc88\uc9f8\ub294 \ub798\uce58\uac00 \uc0ac\uc6a9 \uac00\ub2a5\ud574 \uc9c0\ub294 \uac83\uc744 \uae30\ub2e4\ub9ac\uace0, \ub450 \ubc88\uc9f8\ub294 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ub798\uce58\uc640 \uac19\uc740 willing-to-wait \ub798\uce58\ub294 \ub798\uce58\ub97c \uc5bb\uc73c\ub824\uace0 \ud558\ub294\ub370, \ub9cc\uc77c \uc5c6\ub2e4\uba74 \uae30\ub2e4\ub9ac\uba74\uc11c \ub798\uce58\ub97c \ub2e4\uc2dc \uc694\uccad\ud558\uac8c \ub429\ub2c8\ub2e4. \uadf8 \ub798\uce58\ub294 _SPIN_COUNT\ub77c\ub294 \ubb38\uc11c\ud654\ub418\uc9c0 \uc54a\uc740 \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\uc5d0 \ub530\ub77c \uacc4\uc18d \uae30\ub2e4\ub9ac\uac8c \ub429\ub2c8\ub2e4. \ub9cc\uc57d, _SPIN_COUNT\uc5d0 \ub530\ub77c \uae30\ub2e4\ub9b0 \ud6c4\uc5d0\ub3c4 \ub798\uce58\ub97c \uc5bb\uc9c0 \ubabb \ud588\ub2e4\uba74, 1\/100\ucd08 \ub3d9\uc548 \ud734\uc2dd\ud55c \ud6c4\uc5d0 \ub2e4\uc2dc \uae68\uc5b4\ub098\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub098\uc11c, \uadf8 \ub798\uce58\ub294 _SPIN_COUNT\uc5d0 \ub530\ub77c \uae30\ub2e4\ub9ac\uace0, \uc774\ubc88\uc5d0\ub294 2\/100\ucd08 \ub3d9\uc548 \ud734\uc2dd\ud558\ub294 \uac83\uacfc \uac19\uc774, \ub2e4\uc2dc \uc2dc\uc791\ud558\uae30 \uc804\uc5d0 \ub450 \ubc88 \uc774 \uacfc\uc815\uc744 \uc2e4\ud589\ud558\uac8c \ub429\ub2c8\ub2e4. \uc774 \uacfc\uc815 \ud6c4\uc5d0\ub294 \ub798\uce58\ub97c \uc5bb\uc744 \ub54c\uae4c\uc9c0\ub294 \uacc4\uc18d \ud734\uc2dd \uc2dc\uac04\uc774 \ub450 \ubc30\uac00 \ub420 \uac83\uc774\uace0, \ub798\uce58\uac00 \ud734\uc2dd\uc744 \ucde8\ud560 \ub54c\ub9c8\ub2e4 \ub798\uce58 \ud734\uc2dd \ub300\uae30\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
\uc77c\ubd80 \ub798\uce58\ub4e4\uc740 \uae30\ub2e4\ub9ac\ub824 \ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub9ac\ub450-\ubcf5\uc0ac \ub798\uce58\uc758 \uacbd\uc6b0\uc640 \uac19\uc774 \uc774\ub7ec\ud55c \uc720\ud615\uc758 \ub798\uce58\ub294 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uace0, \uc624\ud788\ub824 \uc989\uac01\uc801\uc73c\ub85c \ub798\uce58\ub97c \ub2e4\uc2dc \uc5bb\uc73c\ub824 \uc2dc\ub3c4\ud569\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
<\/font><\/strong><\/span> <\/span><\/div>\n
\ub300\uae30-\ub798\uce58 \uc815\ubcf4 \ubcf4\uae30<\/span><\/font><\/strong><\/span><\/div>\n
V$LATCH \ubdf0\uc758 immediate_gets\uc640 immediate_misses \uc5f4\ub4e4\uacfc Statspack \ub9ac\ud3ec\ud2b8\uc758 \ub798\uce58 \uc139\uc158\uc5d0\uc11c willing-to-wait \uc640 not-willing-to-wait \ub798\uce58 \ubaa8\ub450\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ubcfc \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
V$LATCH \ubdf0\ub97c \uc9c8\uc758\ud558\uac70\ub098 Statspack \ub9ac\ud3ec\ud2b8\uc758 \ub798\uce58-\uc791\uc5c5 \uc139\uc158\uc744 \ubcf4\uac8c \ub418\uba74 \uc5bc\ub9c8\ub098 \ub9ce\uc740 \ud504\ub85c\uc138\uc2a4\ub4e4\uc774 \ub300\uae30\ud574\uc57c\ub9cc \ud558\uace0 (\ub798\uce58 \uc2e4\ud328), \ub610\ub294 \ud734\uc2dd\ud574\uc57c\ub9cc \ud558\ub294\uc9c0\ub97c (\ub798\uce58 \ud734\uc2dd) \uc54c \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0, V$LATCHHOLDER, V$LATCHNAME, V$LATCH_CHILDREN \ubaa8\ub450\ub294 \ub798\uce58 \ubb38\uc81c\ub4e4\uc744 \uc870\uc0ac\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
Table 1<\/span><\/font><\/span><\/a>\uc740 \ub798\uce58 \uc774\ub984, \ub798\uce58 \uc2e4\ud328 (Pct Get Miss \uc5f4), \ub798\uce58 \ud734\uc2dd (Avg Slps\/Miss \uc5f4) \ub4f1\uc744 \uae30\uc220\ud558\ub294 Statspack \ub9ac\ud3ec\ud2b8\uc758 \ub798\uce58-\uc791\uc5c5 \uc139\uc158\uc758 \uc77c\ubd80 \ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0, \uc774 \ud2b9\uc815 \ub9ac\ud3ec\ud2b8\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ubb38\uc81c\ub3c4 \ubcf4\uc5ec \uc8fc\ub294 \uc5ed\ud560\ub3c4 \ud568\uaed8 \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
Statspack \ub9ac\ud3ec\ud2b8\uc758 \ub300\uae30 \uc774\ubca4\ud2b8 \uc139\uc158\uc744 \uac80\uc0ac\ud560 \ub54c \ub798\uce58\uc758 \uc801\uc911\ub960\uc740 99%\uc5d0 \uc811\uadfc\ud574\uc57c \ud558\uba70, \uc2e4\ud328\ub294 1%\ub97c \ub118\uc5b4\uc11c\ub294 \uc548\ub429\ub2c8\ub2e4. \uadf8\ub7ec\uba74,<\/span> <\/span><\/font>Table 1<\/span><\/font><\/span><\/a>\uc5d0\uc11c\uc640 \uac19\uc774 \ub9ac\ud3ec\ud2b8\uc758 \uc774 \uc139\uc158\uc5d0 \uc788\ub294 \ud589\ub4e4\uc744 \uac80\uc0ac\ud574 \ubcf4\ub3c4\ub85d \ud569\uc2dc\ub2e4.<\/span><\/font><\/span><\/div>\n
<\/strong><\/font> <\/span><\/div>\n
\uc0ac\uc6a9\uac00\ub2a5\ud55c \ub798\uce58:<\/span><\/strong><\/span> <\/span>\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub798\uce58\uac00 \ub300\uae30 \uc774\ubca4\ud2b8 \uc139\uc158\uc5d0\uc11c \ubb38\uc81c\uac00 \ub41c\ub2e4\uba74, \ub9ac\ud3ec\ud2b8\uc758 \ub798\uce58 \uc139\uc158\uc5d0\ub3c4 \uc870\uc0ac\ud574\uc57c \ub420 \ubb38\uc81c\ub4e4\uc774 \uc788\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc740 \ud734\uc2dd \ub798\uce58 (\ub798\uce58\ub97c \uc5bb\uc9c0 \ubabb \ud588\uae30 \ub54c\ubb38\uc5d0 \ub2e4\uc74c \uc2dc\ub3c4\uae4c\uc9c0 \ud734\uc2dd\ud558\uace0 \uc788\ub294) \ub610\ub294 \uc2a4\ud540 \ub798\uce58 (\uae30\ub2e4\ub9ac\uba74\uc11c \uc2a4\ud540 \uce74\uc6b4\ud2b8\uc5d0 \ub530\ub77c \uc7ac\uc2dc\ub3c4\ub97c \ud558\ub294) \uc640 \uac19\uc774 \uc5b4\ub5a0\ud55c \ub798\uce58\uac00 \ubb38\uc81c\uac00 \ub418\ub294\uc9c0\ub97c \ucc3e\ub294\ub370 \ub3c4\uc6c0\uc744 \uc90d\ub2c8\ub2e4.<\/span><\/span><\/font><\/div>\n
<\/strong><\/font> <\/span><\/div>\n
\ud589 \uce90\uc2dc \uac1d\uccb4:<\/span><\/strong><\/span> <\/span>\ud589 \uce90\uc2dc \uac1d\uccb4 \ub798\uce58 \uacbd\ud569\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud0c0 \ub515\uc154\ub108\ub9ac\uc5d0 \uacbd\ud569\uc774 \uc788\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \ub610\ub294 \uacf5\uc6a9 \ub3d9\uc758\uc5b4\ub4e4\uc5d0 \uc758\uc874\ud558\uace0 \uc788\ub294 SQL \ubb38\uc744 \uacfc\ub3c4\ud558\uac8c \uad6c\ubb38 \ubd84\uc11d\ud55c \uacb0\uacfc\uc77c \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \uacf5\uc720 \ud480\uc744 \uc99d\uac00\ud558\uba74, \uc774 \ub798\uce58 \ubb38\uc81c\ub294 \ub300\uac1c \ud574\uacb0\uc774 \ub429\ub2c8\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ub798\uce58 \ubb38\uc81c\uc758 \uacbd\uc6b0\uc5d0\ub294 \ubb38\uc81c \ubc1c\uc0dd \uc804\uc5d0 \uacf5\uc720 \ud480\uc744 \uc99d\uac00\uc2dc\ud0a4\uc2ed\uc2dc\uc624.<\/span><\/span><\/font><\/div>\n
<\/strong><\/font> <\/span><\/div>\n
\uce90\uc2dc \ubc84\ud37c \uccb4\uc778:<\/span><\/strong><\/span> <\/span>\uce90\uc2dc-\ubc84\ud37c \uccb4\uc778\uc740 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uce90\uc2dc \ubc84\ud37c\ub97c \uc704\ud574 SGA \ubc84\ud37c \uce90\uc2dc\ub97c \uc2a4\uce94\ud560 \ub54c \ud544\uc694\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0, \ubc84\ud37c \uce90\uc2dc\uc5d0 \uc704\uce58\ud558\ub294 \ud56b \ube14\ub85d\ub4e4\uc740 (\uc885\uc885 \uc561\uc138\uc2a4 \ub418\uc5b4\uc9c0\ub294) \uce90\uc2dc-\ubc84\ud37c \uccb4\uc778 \ub798\uce58 \ubb38\uc81c\ub4e4\uc744 \ubc1c\uc0dd\uc2dc\ud0a4\ub294\ub370, \uc774\uac83\ub4e4\uc740 \uc11c\ud234\uac8c \uc870\uc815\ub41c SQL \ubb38\uc758 \ud604\uc0c1\uc77c \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ud56b \ub808\ucf54\ub4dc\ub294 \ub3d9\uc77c\ud55c \uccb4\uc778\uc5d0 \u201c\ud574\uc2dc\ub41c\u201d \ube14\ub85d \ubfd0\ub9cc\uc774 \uc544\ub2c8\ub77c \uadf8 \ube14\ub85d \uc548\uc5d0 \uc788\ub294 \ub2e4\ub978 \ub808\ucf54\ub4dc\ub4e4\uc5d0\uac8c\ub3c4 \ubb38\uc81c\ub97c \ubc1c\uc0dd\uc2dc\ud0ac \uc218 \uc788\ub294 \ud56b \ube14\ub85d\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \uadf8\ub7f0\ub370, \ud56b \ube14\ub85d\uc744 \ucc3e\uae30 \uc704\ud574\uc11c\ub294 \uc8fc\uc18c\ub97c \uc704\ud574 V$LATCH_CHILDREN\uc744 \uc9c8\uc758\ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c, \uc774 \ub798\uce58\uc5d0 \uc758\ud574\uc11c \ubcf4\ud638 \ubc1b\uace0 \uc788\ub294 \ube14\ub85d\ub4e4\uc744 \uc2dd\ubcc4\ud558\uae30 \uc704\ud558\uc5ec \uadf8\uac83\uacfc V$BH\ub97c \uc870\uc778\ud569\ub2c8\ub2e4. (\uadf8\ub807\uac8c \ud558\ub294 \uac83\uc740 \ud56b \ube14\ub85d\uc5d0 \uc758\ud574 \uc601\ud5a5\uc744 \ubc1b\ub294 \ubaa8\ub4e0 \ube14\ub85d\ub4e4\uc744 \ubcf4\uc5ec\uc8fc\uac8c \ub429\ub2c8\ub2e4) \ud55c\ud3b8, file#\uc5d0 \uae30\ubc18\ud55c DBA_EXTENTS\uc640 V$BH\uc5d0\uc11c \ucc3e\uc744 \uc218 \uc788\ub294 dbablk\uc744 \uc9c8\uc758\ud574\uc11c \uac1d\uccb4\ub97c \uc2dd\ubcc4\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d, \uadf8 \ud56b \ube14\ub85d\uc774 \uc778\ub371\uc2a4\uc5d0 \uc788\ub2e4\uba74 \uc5ed\ubc29\ud5a5 \ud0a4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \uc21c\ucc28 \ub808\ucf54\ub4dc\ub4e4\uc744 \ub2e4\ub978 \ube14\ub85d\ub4e4\ub85c \uc774\ub3d9\uc2dc\ucf1c\uc11c \uadf8\uac83\ub4e4\uc774 \uccb4\uc778\ub0b4\uc758 \ud56b \ube14\ub85d\uc5d0 \uc758\ud574\uc11c \uc7a0\uae30\uc9c0 \uc54a\uac8c \ud574\uc90d\ub2c8\ub2e4.<\/span><\/span><\/font><\/div>\n
\ub9cc\uc57d, \ud56b \ube14\ub85d\uc774 \uc778\ub371\uc2a4 \ub8e8\ud2b8 \ube14\ub85d\uc774\ub77c\uba74, \uc5ed\ubc29\ud5a5 \ud0a4 \uc778\ub371\uc2a4\ub294 \ubcc4\ub85c \ub3c4\uc6c0\uc774 \ub418\uc9c0 \uc54a\uc744 \uac83\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 _DB_BLOCK_HASH_BUCKETS\ub97c \ubc84\ud37c \uac1c\uc218 (DB_CACHE_SIZE\/DB_BLOCK_SIZE)\uc758 \ub450 \ubc30\ubcf4\ub2e4 \ub354 \ud070 \uc18c\uc218\ub85c \uc124\uc815\ud558\uba74 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Oracle9<\/span>i<\/span><\/i> <\/span>\uc774\uc804\uc5d0\ub294, \uc774 \ub9e4\uac1c \ubcc0\uc218\uc758 \uae30\ubcf8\uac12\uc774 \uc798 \ubabb \uc124\uc815\ub418\uc5b4 \ub798\uce58\uc5d0 \ub9ce\uc740 \uacbd\ud569\uc774 \ubc1c\uc0dd\ud588\uc5c8\uc2b5\ub2c8\ub2e4; Oracle9<\/span>i<\/span><\/i>\uc5d0\uc11c\ub294 \uae30\ubcf8\uac12\uc774 \uc815\ud655\ud558\uac8c \uc18c\uc218\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
<\/strong><\/font> <\/span><\/div>\n
\uce90\uc2dc \ubc84\ud37c LRU \uccb4\uc778:<\/span><\/strong><\/span> <\/span>\uce90\uc2dc \ubc84\ud37c LRU \uccb4\uc778 \ub798\uce58\ub294 \ubc84\ud37c \uce90\uc2dc\uc5d0 \uc788\ub294 \ube14\ub85d\ub4e4\uc758 \ubaa8\ub4e0 \uac83\uc744 \ud3ec\ud568\ud558\uace0 \uc788\ub294 LRU \uccb4\uc778\uc744 \uc2a4\uce94\ud560 \ub54c \uc0ac\uc6a9\uc774 \ub429\ub2c8\ub2e4. \uc791\uc740 \ubc84\ud37c \uce90\uc2dc, \uacfc\ub3c4\ud55c \ubc84\ud37c \uce90\uc2dc \ucc98\ub9ac \ub2a5\ub825, \ub9ce\uc740 \uce90\uc2dc \uae30\ubc18\uc758 \uc815\ub82c, \uadf8\ub9ac\uace0 DBWR\uc758 \uc791\uc5c5 \ub85c\ub4dc \uc720\uc9c0 \uc2e4\ud328 \ub4f1\uc740 \ubaa8\ub450 \uc774\ub7ec\ud55c \ubb38\uc81c\ub4e4\uc744 \ubc1c\uc0dd\uc2dc\ud0a4\ub294 \uc6d0\uc778\uc774 \ub429\ub2c8\ub2e4. \uadf8\ub7ec\ubbc0\ub85c, \uacfc\ub3c4\ud55c \ub17c\ub9ac\uc801 \uc77d\uae30 \ubb38\uc81c\ub97c \ubc1c\uc0dd\uc2dc\ud0ac \uc218 \uc788\ub294 \uc9c8\uc758\ub4e4\uc740 \uc218\uc815\ud574\uc57c\ub9cc \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0, \uacbd\ud569\uc744 \uc904\uc77c \uc218 \uc788\ub294 \ub2e4\uc911\uc758 LRU \ub798\uce58\ub4e4\uc744 \uac16\uae30 \uc704\ud574\uc11c\ub294 \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\uc778 _DB_BLOCK_LRU_LATCHES (Oracle9i\uc5d0\uc11c\ub294 \uc228\uaca8\uc9c4)\ub97c \uc99d\uac00\uc2dc\ud0ac \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c, \ube44-SMP (\ub300\uce6d \ub2e4\uc911\ucc98\ub9ac) \uba38\uc2e0\ub4e4\uc740 \uc624\ub85c\uc9c0 \ub2e8\uc77c\uc758 LRU \ub798\uce58\ub9cc\uc744 \ud544\uc694\ub85c \ud569\ub2c8\ub2e4. Oracle\uc740 \uc790\ub3d9\uc801\uc73c\ub85c \uc774\uac83\uc744 SMP \uba38\uc2e0\uc5d0 \uc788\ub294 CPU \uac1c\uc218\uc758 \ubc18\uc73c\ub85c \uc124\uc815\ud558\uac8c \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ubbc0\ub85c, \uac01\uac01\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uae30\ub85d\uc790\ub97c \uc704\ud574\uc11c\ub294 \ucd5c\uc18c\ud55c \ud558\ub098\uc758 LRU \ub798\uce58\ub97c \uac00\uc838\uc57c\ub9cc \ud569\ub2c8\ub2e4;\ub9cc\uc57d \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uae30\ub85d\uc790\ub97c \uc99d\uac00\ud55c\ub2e4\uba74 \uc774 \uc22b\uc790\ub3c4 \uc99d\uac00\uc2dc\ucf1c\uc57c \ud558\ub294 \uac83\uc744 \uc78a\uc9c0 \ub9c8\uc2ed\uc2dc\uc624.<\/span><\/span><\/font><\/div>\n
<\/strong><\/font> <\/span><\/div>\n
\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc\uc640 \uacf5\uc720 \ud480:<\/span><\/strong><\/span> <\/span>\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ub798\uce58\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc\uc5d0 \uc788\ub294 \uac1d\uccb4\ub4e4\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub97c \uc5f0\uc18d\ud654 \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0, \uc774 \ub798\uce58\ub294 SQL \ud504\ub85c\uc2dc\uc800, PL\/SQL \ud504\ub85c\uc2dc\uc800, \ud328\ud0a4\uc9c0, \ud568\uc218, \ud2b8\ub9ac\uac70 \ub4f1\uc774 \uc2e4\ud589\ub420 \ub54c\ub9c8\ub2e4, \ub610\ub294 \uad6c\ubb38 \ubd84\uc11d \uc791\uc5c5 \ub3d9\uc548 \uc0ac\uc6a9\ub418\uc5b4 \uc9d1\ub2c8\ub2e4.<\/span><\/span><\/font><\/div>\n
Oracle8<\/span>i<\/span><\/i>\uc5d0\uc11c\ub294 \ub2e8\uc77c\uc758 \uacf5\uc720 \ud480 \ub798\uce58\uac00 \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc\uc5d0\uc11c\uc758 \uba54\ubaa8\ub9ac \ud560\ub2f9\uc744 \ubcf4\ud638\ud558\ub294 \uc5ed\ud560\uc744 \ud558\uc600\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098, Oracle9<\/span>i<\/span><\/i>\uc5d0\ub294 \ub798\uce58\uc758 \uacbd\ud569\uc744 \uc904\uc5ec \uc904 \uc218 \uc788\ub294 \uc77c\uacf1 \uac1c\uc758 \ud558\uc704 \ub798\uce58\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/font><\/span><\/p>\n\n\n\n
\ub2e4\uc74c \ub2e8\uacc4<\/span><\/font><\/strong><\/span><\/center><\/p>\n
READ MORE more about Statspack<\/span>
<\/font><\/font><\/strong>amazon.com\/oracle<\/span><\/font><\/span><\/a>
Read more on Statspack in Rich Niemiec’s<\/span> <\/span><\/span>Rich Niemiec\uc758 \u201cOracle9i Performance Tuning Tips and Techniques\u201d \uc5d0\uc11c Statspack\uc5d0 \ub300\ud55c \ub354 \ub9ce\uc740 \uc815\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4(Amazon.com\uc5d0\uc11c \uad6c\uc785 \uac00\ub2a5)<\/span><\/em><\/span><\/font><\/font><\/div>\n
MetaLink\uc5d0\uc11c \uc9c0\uc6d0\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span> <\/span><\/span>
<\/font><\/font><\/strong>oracle.com\/kr\/support\/metalink<\/span><\/font><\/span><\/a><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\uacf5\uc720 \ud480, \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ud540, \ub610\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ub798\uce58 \ub4f1\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \uacbd\ud569\uc740 \uacf5\uc720 \ud480\uc774 \ub108\ubb34 \uc791\uac70\ub098 \uba85\ub839\ubb38\ub4e4\uc774 \uc7ac\uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc744 \ub54c \uc8fc\ub85c \ubc1c\uc0dd\ub429\ub2c8\ub2e4. \uba85\ub839\ubb38\uc740 \ubc14\uc778\ub4dc \ubcc0\uc218\uac00 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uace0, \uc77c\ubc18\uc801\uc774\ub098 \uc815\ud655\uce58 \uc54a\uc740 SQL\ubb38\ub4e4\uc774 \uacf5\uc720 \ud480\uc744 \ucc44\uc6b8 \ub54c\uc5d0\ub294 \uac70\uc758 \uc7ac\uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ubbc0\ub85c, \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74\uc11c \ub9ce\uc740 \uba85\ub839\ubb38\uc73c\ub85c \uacf5\uc720 \ud480\uc744 \ucc44\uc6b4 \uc0ac\uc6a9\uc790\uac00 \ubc14\uc778\ub4dc \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ub610 \ub2e4\ub978 \ub9ce\uc740 \uba85\ub839\ubb38\ub4e4\ub85c \ud655\uc7a5\ub41c \uacf5\uc720 \ud480\uc744 \ucc44\uc6b8 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \ub2e8\uc9c0 \uacf5\uc720 \ud480\uc758 \ud06c\uae30\ub97c \uc99d\uac00\uc2dc\ud0a4\ub294 \uac83\uc740 \ub798\uce58 \ubb38\uc81c\ub97c \uc545\ud654\uc2dc\ud0ac \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0\ub370, CURSOR_SHARING= FORCE (Oracle9i \uc5d0\uc11c\ub294 CURSOR_SHARING=SIMILAR) \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\ub97c \uc124\uc815\ud558\uba74, \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218\ub3c4 \uc788\uace0, \ub610\ud55c \ubc14\uc778\ub4dc \ubcc0\uc218\uac00 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc744 \ub54c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\uc810\ub4e4\ub3c4 \uc904\uc77c \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098, \uacf5\uc720 \ud480\uacfc \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ub798\uce58 \ubb38\uc81c\ub294 \ucc98\ub9ac\ud574\uc57c \ud560 SQL \ubb38\uc5d0 \ube44\ud558\uc5ec \uce90\uc2dc\uac00 \ub108\ubb34 \uc801\uac8c \uc124\uc815\ub418\uc5b4, \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc\uac00 \uacf5\ubc31\uc744 \ud544\uc694\ub85c \ud560 \ub54c \ubc1c\uc0dd\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud55c\ud3b8, SQL \ub610\ub294 PL\/SQL \ubb38\uc744 \ub85c\ub4dc\ud558\uae30 \uc704\ud574 \uacf5\ubc31\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc74c\uacfc \ub3d9\uc2dc\uc5d0, \ub798\uce58\ub294 \ubc30\ud0c0\uc801\uc73c\ub85c \uc18c\uc720\ub418\uc5b4 \uc9c0\uace0, \ub2e4\ub978 \uc0ac\uc6a9\uc790\ub4e4\uc740 \uae30\ub2e4\ub824\uc57c\ub9cc \ud569\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, DBMS_SHARED_POOL.KEEP \ud504\ub85c\uc2dc\uc800\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uba74, \uacf5\uc720 \ud480\uc744 \uc99d\uac00\uc2dc\ud0a4\uac70\ub098, \ub2e4\ub7c9\uc758 SQL \ubb38\uacfc PL\/SQL \ubb38\uc744 \uba54\ubaa8\ub9ac\uc5d0 \uace0\uc815\uc2dc\ud0b4\uc73c\ub85c\uc368 \uacbd\ud569\uc744 \uc904\uc77c \uc218\uac00 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
<\/strong><\/font> <\/span><\/div>\n
\ub9ac\ub450 \ud560\ub2f9:<\/span><\/strong><\/span> <\/span>\uacf5\ubc31\uc744 \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c\uc5d0 \ud560\ub2f9\ud558\ub294 \ub9ac\ub450 \ud560\ub2f9 \ub798\uce58\ub97c \ud1b5\ud574 \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c\uc758 \ub85c\ub4dc\ub97c \uc904\uc77c \uc218 \uc788\ub294 NOLOGGING \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \uacbd\ud569\uc744 \uc904\uc77c \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0, \ubd88\ud544\uc694\ud55c \ucee4\ubc0b\uc744 \ud558\uc9c0 \uc54a\ub3c4\ub85d \ud558\uc2ed\uc2dc\uc624. \ub9ac\ub450 \ubcf5\uc0ac: \ub9ac\ub450 \ubcf5\uc0ac \ub798\uce58\uc758 \uac1c\uc218\ub294 2*CPU_ COUNT\uc758 \uae30\ubcf8\uac12\uc744 \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4\ub9cc, _LOG _SIMULTANEOUS_COPIES \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \uc124\uc815\ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0, \uc774 \ub9e4\uac1c \ubcc0\uc218\ub97c \uc99d\uac00\uc2dc\ud0a4\ub294 \uac83\uc740 PGA\uc758 \ub9ac\ub450 \ub808\ucf54\ub4dc\ub4e4\uc744 \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c\ub85c \ubcf5\uc0ac\ud560 \ub54c \uc0ac\uc6a9\ub418\ub294 \ub9ac\ub450 \ubcf5\uc0ac \ub798\uce58\uc758 \uacbd\ud569\uc744 \uc904\uc77c \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/font><\/div>\n
\uc77c\ubd80 \ub798\uce58 \ubb38\uc81c\ub4e4\uc740 \uacfc\uac70\uc758 \uc81c\ud488 \ubc84\uadf8\uc640 \uad00\ub828\uc774 \uc788\uae30 \ub54c\ubb38\uc5d0 \ub798\uce58\uc640 \uad00\ub828\ub41c \ubb38\uc81c\ub4e4\uc758 \uacbd\uc6b0\uc5d0\ub294 MetaLink\ub97c \ud56d\uc0c1 \ud655\uc778\ud574 \ubcf4\uc544\uc57c \ud558\uace0, \uadf8\ub9ac\uace0 99% \uc774\ud558\uc758 \uc801\uc911\ub960\uc744 \uac16\ub294 \ub798\uce58\ub4e4\uc740 \uc870\uc0ac\ud574 \ubcf4\uc544\uc57c\ub9cc \ud569\ub2c8\ub2e4.<\/span><\/font><\/span><\/div>\n
Rich Niemiec<\/span><\/b>\ub294 TUSC (<\/span><\/font><\/em>www.tusc.com<\/span><\/em><\/font><\/span><\/a>)\uc758 CEO\uc774\uba74\uc11c International Oracle Users Group (<\/span><\/font><\/em>www.ioug.org<\/span><\/em><\/font><\/span><\/a>)\uc758 president\uc785\ub2c8\ub2e4.<\/span><\/font><\/em><\/span><\/div>\n
\n
<\/div>\n
<\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n
Table 1. \ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ubb38\uc81c\ub97c \ubcf4\uc5ec \uc8fc\ub294 Statspack \ub9ac\ud3ec\ud2b8<\/span><\/font><\/strong><\/a><\/span><\/center><\/td>\n<\/tr>\n
\ub798\uce58<\/span><\/font><\/strong><\/span><\/td>\n\uc785\uc218 \uc694\uccad<\/span><\/font><\/strong><\/span><\/td>\nPct(%) \uc785\uc218 \uc2e4\ud328<\/span><\/font><\/strong><\/span><\/td>\n\ud3c9\uade0 \ud734\uc2dd\/\uc2e4\ud328<\/span><\/font><\/strong><\/span><\/td>\n\ub300\uae30 \uc2dc\uac04<\/span><\/font><\/strong><\/span><\/td>\n\ub300\uae30\uc5c6\uc74c \uc694\uccad<\/span><\/font><\/strong><\/span><\/td>\nPct(%) \ub300\uae30\uc5c6\uc74c \uc2e4\ud328<\/span><\/font><\/strong><\/span><\/td>\n<\/tr>\n
KCL freelist \ub798\uce58<\/span><\/font><\/span><\/td>\n4,924<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n<\/tr>\n
\uce90\uc2dc \ubc84\ud37c \ud578\ub4e4<\/span><\/font><\/span><\/td>\n968,992<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n<\/tr>\n
\ucc44\uc2dc \ubc84\ud37c \uccb4\uc778<\/span><\/font><\/span><\/td>\n761,708,539<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n0.4<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n21,519,841<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n<\/tr>\n
\uce90\uc2dc \ubc84\ud37c LRU \uccb4\uc778<\/span><\/font><\/span><\/td>\n8,111,269<\/span><\/font><\/span><\/td>\n0.1<\/span><\/font><\/span><\/td>\n0.8<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n19,834,466<\/span><\/font><\/span><\/td>\n0.1<\/span><\/font><\/span><\/td>\n<\/tr>\n
\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc<\/span><\/font><\/span><\/td>\n67,602,665<\/span><\/font><\/span><\/td>\n2.2<\/span><\/font><\/span><\/td>\n2.0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n213,590<\/span><\/font><\/span><\/td>\n0.8<\/span><\/font><\/span><\/td>\n<\/tr>\n
\ub9ac\ub450 \ud560\ub2f9<\/span><\/font><\/span><\/td>\n12,446,986<\/span><\/font><\/span><\/td>\n0.2<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n<\/tr>\n
\ub9ac\ub450 \ubcf5\uc0ac<\/span><\/font><\/span><\/td>\n320<\/span><\/font><\/span><\/td>\n0.0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n10,335,430<\/span><\/font><\/span><\/td>\n0.1<\/span><\/font><\/span><\/td>\n<\/tr>\n
user lock<\/span><\/font><\/span><\/td>\n1,973<\/span><\/font><\/span><\/td>\n0.3<\/span><\/font><\/span><\/td>\n1.2<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n0<\/span><\/font><\/span><\/td>\n <\/span><\/font><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n
<\/div>\n
<\/div>\n\n\n\n\n\n\n\n\n\n\n\n
\uc77c\ubc18 \ub798\uce58 \ubb38\uc81c<\/span><\/font><\/strong><\/span><\/center><\/td>\n<\/tr>\n
\ub798\ud53c \ubb38\uc81c<\/span><\/font><\/strong><\/span><\/td>\n\uc7a0\uc7ac\uc801 \uc218\uc815<\/span><\/font><\/strong><\/span><\/td>\n<\/tr>\n
\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc<\/span><\/font><\/span><\/td>\n\ubc14\uc778\ub4dc \ubcc0\uc218 \uc0ac\uc6a9;SHARED_ POOL_SIZE \uc870\uc815<\/span><\/font><\/span><\/td>\n<\/tr>\n
\uacf5\uc720 \ud480<\/span><\/font><\/span><\/td>\n\ubc14\uc778\ub4dc \ubcc0\uc218 \uc0ac\uc6a9; SHARED_ POOL_SIZE \uc870\uc815<\/span><\/font><\/span><\/td>\n<\/tr>\n
\ub9ac\ub450 \ud560\ub2f9<\/span><\/font><\/span><\/td>\n\ub9ac\ub450 \uc0dd\uc131 \ucd5c\uc18c\ud654\uc640 \ubd88\ud544\uc694\ud55c \ucee4\ubc0b \uc548 \ud568<\/span><\/font><\/span><\/td>\n<\/tr>\n
\ub9ac\ub450 \ubcf5\uc0ac<\/span><\/font><\/span><\/td>\n_LOG_SIMULTANEOUS_ \uc99d\uac00<\/span><\/font><\/span><\/td>\n<\/tr>\n
\ud589 \uce90\uc2dc \uac1d\uccb4<\/span><\/font><\/span><\/td>\n\uacf5\uc720 \ud480 \uc99d\uac00<\/span><\/font><\/span><\/td>\n<\/tr>\n
\uce90\uc2dc-\ubc84\ud37c \uccb4\uc778<\/span><\/font><\/span><\/td>\n_DB_BLOCK_HASH_ BUCKETS \uc870\uc815 \ud544\uc694<\/span><\/font><\/span><\/td>\n<\/tr>\n
\uce90\uc2dc-\ubc84\ud37c<\/span><\/font><\/span><\/td>\n_DB_BLOCK_LRU_LRU_LATCHES \uc0ac\uc6a9 \ub610\ub294 \ub2e4\uc911\uc758 \ubc84\ud37c \ud480<\/span><\/font><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
 <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Statspack\ub97c \ud1b5\ud55c \uace0\uae09 \uc2dc\uc2a4\ud15c \ud29c\ub2dd By Rich Niemiec   \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\ub9ac\uc988 \uc911 \ub450 \ubc88\uc9f8 \ud3b8 \uc774\uc804 \uce7c\ub7fc\uc5d0\uc11c \uc5b8\uae09\ud588\ub358 \uac83\ucc98\ub7fc, \uc2dc\uc2a4\ud15c \uc131\ub2a5 \ubb38\uc81c\ub97c \ubaa8\ub2c8\ud130\ud558\uace0 \ucc3e\uae30 \uc704\ud574 Oracle9i \uc720\ud2f8\ub9ac\ud2f0\ub97c \ub450 \uac1c\ub9cc \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4\uba74 \uadf8\uac83\uc740 \ubc18\ub4dc\uc2dc Enterprise Manager\uc640 Statspack\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7f0\ub370, Oracle9i\uc5d0\uc11c\ub294 (Oracle8i Release 8.1.6\uc5d0\uc11c\ucc98\ub7fc) \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ud558\uae30 \uc704\ud574\uc11c STATSPACK\uc744 \uc0ac\uc6a9\ud560 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 STATSPACK\ub294 Oracle\uc758 \uc774\uc804 \ubc84\uc804\uc5d0\uc11c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[11],"tags":[172,173,174,118],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/421"}],"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=421"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}