{"id":422,"date":"2015-09-02T08:29:57","date_gmt":"2015-09-02T08:29:57","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=422"},"modified":"2015-09-02T08:29:57","modified_gmt":"2015-09-02T08:29:57","slug":"statspack%ec%9d%84-%ed%86%b5%ed%95%9c-%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=422","title":{"rendered":"Statspack\uc744 \ud1b5\ud55c \uc2dc\uc2a4\ud15c \ud29c\ub2dd"},"content":{"rendered":"
Statspack\uc744 \ud1b5\ud55c \uc2dc\uc2a4\ud15c \ud29c\ub2dd<\/font><\/strong><\/span><\/div>\n
\uc800\uc790 Rich Niemiec<\/em><\/span><\/div>\n
 <\/div>\n
Statspack \ubcf4\uace0\uc11c\uc5d0 \ub300\uae30 \uc774\ubca4\ud2b8\uac00 \ubb34\uc5c7\uc744 \uc758\ubbf8\ud558\uba70, \uc774\ub7ec\ud55c \uc774\ubca4\ud2b8\ub97c \ud29c\ub2dd\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/strong><\/i><\/span><\/div>\n
Oracle \uc720\ud2f8\ub9ac\ud2f0\ub97c \ub2e8 \ub450 \uac1c\ub9cc \uc0ac\uc6a9\ud558\uc5ec Oracle9i<\/i> Database \uc2dc\uc2a4\ud15c\uc758 \uc131\ub2a5 \ubb38\uc81c\ub97c \ud655\uc778 \ubc0f \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\ub2e4\uba74 \uc774\ub7ec\ud55c \ud234\uc740 Oracle Enterprise Manager(\ud604\uc7ac Release 4.0\uc5d0\uc11c \uc81c\uacf5\ub418\uace0 \uc788\uc74c)\uc640 Statspack\uc774 \ub420 \uac83\uc785\ub2c8\ub2e4. Oracle8i<\/i> Release 8.1.6\uc5d0\uc11c \uc774\uc804 \ubc84\uc804\uc758 Oracle Database\uc758 \uc131\ub2a5 \ubaa8\ub2c8\ud130\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 UTLBSTAT\/UTLESTAT \uc2a4\ud06c\ub9bd\ud2b8\uac00 Statspack \uc720\ud2f8\ub9ac\ud2f0\ub85c \ub300\uccb4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. Statspack\uc740 \uc774\ub7ec\ud55c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc704\ud55c \uc5ec\ub7ec \ud5a5\uc0c1\ub41c \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ubcf8 \uce7c\ub7fc\uc5d0\uc11c\ub294 \ub300\uae30 \uc774\ubca4\ud2b8\uc640 \uad00\ub828\ub41c \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub300\uae30 \uc774\ubca4\ud2b8\uac00 \ubc1c\uc0dd\ud558\uba74 \ub9ac\uc18c\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac70\ub098, \uc791\uc5c5\uc774 \uc644\ub8cc\ub418\ub294 \ub4f1\uc758 \ud2b9\uc815 \uc2dc\uc810\uc774 \ub420 \ub54c\uae4c\uc9c0 \uc2dc\uc2a4\ud15c\uc740 \ub300\uae30 \uc0c1\ud0dc\uac00 \ub429\ub2c8\ub2e4.<\/span><\/div>\n
<\/font><\/strong><\/span> <\/div>\n
\uc0c1\uc704 5\uac1c \ub300\uae30 \uc774\ubca4\ud2b8<\/font><\/strong><\/span><\/div>\n
\uc2dc\uc2a4\ud15c\uc758 \ubcd1\ubaa9 \ud604\uc0c1\uc744 \uc81c\uac70\ud558\ub824\ub294 \uacbd\uc6b0\uc5d0 \uac00\uc7a5 \uba3c\uc800 \uc0b4\ud3b4\ubcf4\uc544\uc57c \ud560 \ubd80\ubd84\uc774 Statspack \ubcf4\uace0\uc11c\uc758 \uc0c1\uc704 5\uac1c \ub300\uae30 \uc774\ubca4\ud2b8(Top 5 Wait Events ) \ubd80\ubd84\uc785\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc758 \uc774 \ubd80\ubd84\uc5d0\ub294 \uc0c1\uc704 5\uac1c \ub300\uae30 \uc774\ubca4\ud2b8, \uc804\uccb4 \ub300\uae30 \uc774\ubca4\ud2b8 \ubaa9\ub85d \ubc0f \ubc31\uadf8\ub77c\uc6b4\ub4dc \ub300\uae30 \uc774\ubca4\ud2b8\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c\uc758 TIMED_STATISTICS \ucd08\uae30\ud654 \ub9e4\uac1c \ubcc0\uc218\uac00 true\ub85c \uc124\uc815\ub418\uba74 \ub300\uae30 \uc2dc\uac04\uc744 \uae30\uc900\uc73c\ub85c \uc774\ubca4\ud2b8\uc758 \uc21c\uc11c\uac00 \uc9c0\uc815\ub418\uba70, \uc77c\ubd80 \uc774\ubca4\ud2b8\uc5d0\uc11c \ub300\uae30\uac00 \ud45c\uc2dc\ub418\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc774 \uc124\uc815\uc774 \ub354 \uc120\ud638\ub418\ub294 \ud3b8\uc785\ub2c8\ub2e4. TIMED_STATISTICS\uac00 false\ub85c \uc124\uc815\ub418\uba74 \ub300\uae30 \uac1c\uc218\ub97c \uae30\uc900\uc73c\ub85c \uc774\ubca4\ud2b8\uc758 \uc21c\uc11c\uac00 \uc9c0\uc815\ub429\ub2c8\ub2e4.<\/div>\n
\ubaa9\ub85d 1<\/font><\/span><\/a>\uc740 \ub798\uce58(latch free) \ub300\uae30 \ubfd0\ub9cc \uc544\ub2c8\ub77c \ub2e8\uc77c \ube14\ub85d \uc77d\uae30(db \ud30c\uc77c \uc21c\ucc28 \uc77d\uae30)\uc640 \uad00\ub828\ub41c \ub2e4\uc218\uc758 \ub300\uae30\ub97c \ubcf4\uc5ec \uc90d\ub2c8\ub2e4. \uc774 \ubaa9\ub85d\uc5d0\uc11c\ub294 \uc77c\ubd80 \ub370\uc774\ud0c0 \ud30c\uc77c \ubc0f \ub85c\uadf8 \ud30c\uc77c \uc4f0\uae30 \uc791\uc5c5\uc5d0 \ub9ce\uc740 \ub300\uae30\uac00 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\uc11c \uc8fc\uc694 \ubb38\uc81c\uc810\uc774 \ub418\ub294 \ubd80\ubd84\uc744 \uc2dd\ubcc4\ud558\ub824\uba74 Statspack\uc758 \ub2e4\ub978 \ubd80\ubd84\uc5d0\uc11c \uc138\ubd80 \ubcf4\uace0\uc11c\ub97c \uc870\uc0ac\ud558\uc5ec \ubaa9\ub85d\uc758 \ubc94\uc704\ub97c \uc881\ud600\uc57c \ud569\ub2c8\ub2e4.<\/div>\n
<\/font><\/strong><\/span> <\/div>\n
\ub300\uae30 \uc774\ubca4\ud2b8 \ud574\uacb0<\/font><\/strong><\/span><\/div>\n
\ub2e4\uc74c 10\uac00\uc9c0 \ud56d\ubaa9\uc740 \ub300\uae30 \uc774\ubca4\ud2b8\ub97c \uc77c\uc73c\ud0a4\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\uc785\ub2c8\ub2e4. \uac01 \ud56d\ubaa9\uc5d0\ub294 \uc6d0\uc778\uc5d0 \ub300\ud55c \uc124\uba85\uacfc \uc774\uc640 \uad00\ub828\ub41c \ud574\uacb0 \ubc29\ubc95\uc774 \ud568\uaed8 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/div>\n
<\/strong><\/span> <\/div>\n
1. DB \ud30c\uc77c \ubd84\uc0b0 \uc77d\uae30(DB File Scattered Read). <\/strong><\/span>\uc774\uac83\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uacfc \uad00\ub828\ub41c \ub300\uae30\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uba54\ubaa8\ub9ac\ub85c \ub4e4\uc5b4\uac04 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc740 \uc778\uc811\ud55c \ubc84\ud37c\uc5d0 \ud3ec\ud568\ub418\ub294 \ub300\uc2e0, \ubc84\ud37c \uce90\uc2dc \uc804\uccb4\uc5d0\uc11c \ubd84\uc0b0\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ub300\uae30 \uac1c\uc218\uac00 \ub9ce\ub2e4\ub294 \uac83\uc740 \ud14c\uc774\ube14\uc5d0 \uc778\ub371\uc2a4\uac00 \uc5c6\uac70\ub098 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc558\uc744 \uc218 \uc788\uc74c\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc0c1\ud669\uc5d0 \ub530\ub77c \uc778\ub371\uc2a4 \uc2a4\uce94\ubcf4\ub2e4 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc774 \ub354 \ud6a8\uc728\uc801\uc77c \uc218 \uc788\uc9c0\ub9cc, \uc774\ub7ec\ud55c \ub300\uae30\uac00 \ud45c\uc2dc\ub418\uba74 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc774 \ud544\uc694\ud55c\uc9c0 \uac80\uc0ac\ud574\uc57c \ud569\ub2c8\ub2e4. \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc774 LRU(Least Recently Used) \ubaa9\ub85d\uc758 \ub05d \ubd80\ubd84\uc5d0 \uc704\uce58\ud558\ubbc0\ub85c \uc791\uc740 \ud14c\uc774\ube14\uc744 \uce90\uc2dc\ud558\uc5ec \uc774\ub7ec\ud55c \ud14c\uc774\ube14\uc774 \ubc18\ubcf5\uc801\uc73c\ub85c \uc77d\ud788\ub294 \uac83\uc744 \ubc29\uc9c0\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/div>\n
<\/strong><\/span> <\/div>\n
2. DB \ud30c\uc77c \uc21c\ucc28 \uc77d\uae30(DB File Sequential Read). <\/strong><\/span>\uc774 \uc774\ubca4\ud2b8\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ub2e8\uc77c \ube14\ub85d \uc77d\uae30(\uc608: \uc778\ub371\uc2a4 \uc77d\uae30)\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ub300\uae30 \uac1c\uc218\uac00 \ub9ce\ub2e4\ub294 \uac83\uc740 \ud14c\uc774\ube14\uc758 \uc798\ubabb\ub41c \uc870\uc778 \uc21c\uc11c\ub098 \uc120\ud0dd\uc801\uc774\uc9c0 \uc54a\uc740 \uc778\ub371\uc2a4\ud654\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158\uc774 \ub9ce\uc740 \uc801\uc808\ud788 \uc870\uc815\ub41c \uc2dc\uc2a4\ud15c\uc758 \uacbd\uc6b0 \ub300\uae30 \uac1c\uc218\uac00 \ub9ce\uc740 \uac83\uc774 \uc815\uc0c1\uc774\uc9c0\ub9cc, \uc0c1\ud669\uc5d0 \ub530\ub77c \uc774\uac83\uc740 \ubb38\uc81c\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\ub7ec\ud55c \ub300\uae30 \ud1b5\uacc4\ub97c Statspack \ubcf4\uace0\uc11c\uc758 \ub2e4\ub978 \uc54c\ub824\uc9c4 \ubb38\uc81c\uc810(\uc608: \ubd88\ucda9\ubd84\ud55c SQL)\uacfc \uc0c1\ud638 \uad00\ub828\uc2dc\ucf1c \uc870\uc0ac\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c \uc778\ub371\uc2a4 \uc2a4\uce94\uc774 \ud544\uc694\ud55c\uc9c0 \uc5ec\ubd80\uc640 \uc5ec\ub7ec \ud14c\uc774\ube14 \uc870\uc778\uc758 \uc870\uc778 \uc21c\uc11c\ub97c \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub300\uae30\uac00 \ud45c\uc2dc\ub418\ub294 \ube48\ub3c4\ub294 DB_CACHE_SIZE\uc5d0 \uc758\ud574 \uacb0\uc815\ub418\uae30\ub3c4 \ud569\ub2c8\ub2e4. \ubb38\uc81c\uc758 \ud574\uc2dc \uc601\uc5ed \uc870\uc778\uc740 PGA \uba54\ubaa8\ub9ac\uc5d0 \ub098\ud0c0\ub098\uc57c \ud558\uc9c0\ub9cc \uc774\ub7ec\ud55c \uc870\uc778\uc740 \uc21c\ucc28 \uc77d\uae30\uc5d0 \ub300\ud55c \ub9ce\uc740 \uc218\uc758 \ub300\uae30\ub97c \ubc1c\uc0dd\uc2dc\ud0ac \uc218 \uc788\ub294 \uba54\ubaa8\ub9ac \ud638\uadf8\uac00 \ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc774\ub7ec\ud55c \uc870\uc778\uc740 \uc9c1\uc811 \uacbd\ub85c \uc77d\uae30\/\uc4f0\uae30 \ub300\uae30\ub85c \ud45c\uc2dc\ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/div>\n
<\/b><\/font> <\/div>\n
3. \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ubc84\ud37c(Free Buffer)<\/b>. \uc774\uac83\uc740 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubc84\ud37c\uac00 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \uc2dc\uc2a4\ud15c\uc774 \uba54\ubaa8\ub9ac\uc5d0\uc11c \ubc84\ud37c\ub97c \ub300\uae30\ud558\uace0 \uc788\ub294 \uc911\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774 \ubc94\uc8fc\uc758 \ubc84\ud37c \ub300\uae30\ub294 \ubaa8\ub4e0 SQL\uc774 \uc870\uc815\ub420 \uacbd\uc6b0 DB_BUFFER_CACHE\ub97c \ub298\ub824\uc57c \ud55c\ub2e4\ub294 \uac83\uc744 \ub098\ud0c0\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc774 \ub300\uae30\ub294 \uc120\ud0dd\uc801\uc774\uc9c0 \uc54a\uc740 SQL\ub85c \uc778\ud574 \ub370\uc774\ud0c0\uac00 \uc778\ub371\uc2a4 \ube14\ub85d\uc73c\ub85c \ubc84\ud37c \uce90\uc2dc\ub97c \ucc44\uc6b4\ub2e4\ub294 \uac83\uc744 \ub098\ud0c0\ub0bc \uc218 \uc788\ub294\ub370, \uc774 \uacbd\uc6b0 \uc2dc\uc2a4\ud15c \ucc98\ub9ac\ub97c \uae30\ub2e4\ub9ac\uace0 \uc788\ub294 \uc774\ub7ec\ud55c \ud2b9\uc815 \uba85\ub839\ubb38\uc744 \uc704\ud55c \ubc84\ud37c\ub97c \uc804\ud600 \ub0a8\uaca8\ub450\uc9c0 \uc54a\uac8c \ub429\ub2c8\ub2e4. \uc774\uac83\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uc0c1\ub2f9\ud55c \uc591\uc758 DML(insert\/update\/delete)\uc774 \uc218\ud589 \uc911\uc774\uace0 DBWR(Database Writer)\uc774 \uc4f0\uae30 \uc18d\ub3c4\uac00 \ucda9\ubd84\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \ubc84\ud37c \uce90\uc2dc\uac00 \uc5ec\ub7ec \ubc84\uc804\uc758 \ub3d9\uc77c\ud55c \ubc84\ud37c\ub85c \uac00\ub4dd\ucc28\uac8c \ub418\uace0, \uacb0\uacfc\uc801\uc73c\ub85c \ud6a8\uc728\uc131\uc774 \ud06c\uac8c \ub5a8\uc5b4\uc9c4\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ubc29\ubc95\uc73c\ub85c \ub354 \ub9ce\uc740 DBWR \ud504\ub85c\uc138\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc99d\ubd84 \uccb4\ud06c\ud3ec\uc778\ud2b8\ub97c \uac00\uc18d\ud654\ud558\uac70\ub098 \uc2e4\uc81c \ub514\uc2a4\ud06c \uc218\ub97c \ub298\ub9ac\ub294 \uac83\uc744 \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/font><\/div>\n
<\/b><\/font> <\/div>\n
4. \ubc84\ud37c \uc0ac\uc6a9 \uc911(Buffer Busy). <\/b>\uc774\uac83\uc740 \ubc84\ud37c\ub97c \uacf5\uc720\ud560 \uc218 \uc5c6\ub294 \ubc29\uc2dd\uc73c\ub85c \uc0ac\uc6a9 \uc911\uc778 \ubc84\ud37c \ub610\ub294 \ubc84\ud37c \uce90\uc2dc\ub85c \uc77d\uc5b4\ub4e4\uc774\uace0 \uc788\ub294 \ubc84\ud37c\uc5d0 \ub300\ud55c \ub300\uae30\uc785\ub2c8\ub2e4. \ubc84\ud37c \uc0ac\uc6a9 \uc911 \ub300\uae30\ub294 1%\ub97c \ucd08\uacfc\ud574\uc11c\ub294 \uc548 \ub429\ub2c8\ub2e4. \ubc84\ud37c \ub300\uae30 \ud1b5\uacc4 \uc139\uc158(\ub610\ub294 V$WAITSTAT)\uc744 \uac80\uc0ac\ud558\uc5ec \uc138\uadf8\uba3c\ud2b8 \ud5e4\ub354\uc5d0 \ub300\uae30\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778\ud55c \ub2e4\uc74c, \ub9cc\uc57d \uadf8\ub7f4 \uacbd\uc6b0\uc5d0\ub294 \uc0ac\uc6a9 \uac00\ub2a5 \ubaa9\ub85d \uadf8\ub8f9\uc744 \ub298\ub9ac\uac70\ub098 pctused\uc640 pctfree \uac04\uc758 \uac04\uaca9\uc744 \ub298\ub9bd\ub2c8\ub2e4. \ub300\uae30\uac00 \uc2e4\ud589 \ucde8\uc18c \ubaa9\ub85d\uc5d0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub864\ubc31 \uc138\uadf8\uba3c\ud2b8\ub97c \ucd94\uac00\ud558\uc5ec \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uace0, \ub300\uae30\uac00 \uc2e4\ud589 \ucde8\uc18c \ube14\ub85d\uc5d0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 \uc774 \uc77c\uad00\uc131 \uc77d\uae30\ub97c \uc81c\uacf5\ud558\ub294 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud0c0 \ubc00\ub3c4\ub97c \uc904\uc774\uac70\ub098 DB_CACHE_SIZE\ub97c \ub298\ub824\uc57c \ud569\ub2c8\ub2e4. <\/p>\n

\ub300\uae30\uac00 \ub370\uc774\ud0c0 \ube14\ub85d\uc5d0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub370\uc774\ud0c0\ub97c \ub2e4\ub978 \ube14\ub85d\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \uc774\ub7ec\ud55c \ud56b \ube14\ub85d\uc744 \ubc29\uc9c0\ud558\uac70\ub098, \ud14c\uc774\ube14\uc758 \uc0ac\uc6a9 \uac00\ub2a5 \ubaa9\ub85d\uc744 \ub298\ub9ac\uac70\ub098, LMT(Locally Managed Tablespace)\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub300\uae30\uac00 \uc778\ub371\uc2a4 \ube14\ub85d\uc5d0 \uc788\uc73c\uba74 \uc778\ub371\uc2a4\ub97c \ub2e4\uc2dc \uc791\uc131\ud558\uac70\ub098, \uc778\ub371\uc2a4\ub97c \ubd84\ud560\ud558\uac70\ub098, \uc5ed\ubc29\ud5a5 \ud0a4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub354 \uc791\uc740 \ube14\ub85d \ud06c\uae30\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud0c0 \ube14\ub85d\uacfc \uad00\ub828\ub41c \ubc84\ud37c \uc0ac\uc6a9 \uc911 \ub300\uae30\ub97c \ubc29\uc9c0\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 \ub2e8\uc77c \ube14\ub85d \ub0b4\uc758 \ub808\ucf54\ub4dc \uc218\uac00 \uc904\uc5b4\ub4e4\uae30 \ub54c\ubb38\uc5d0 “\ud56b” \ube14\ub85d\uc774 \ub9cc\ub4e4\uc5b4\uc9c0\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. DML(insert\/update\/ delete)\uc774 \ubc1c\uc0dd\ud558\uba74 Oracle Database\ub294 \ube14\ub85d \uc0c1\ud0dc\uc5d0 “\uad00\uacc4 \uc788\ub294” \ubaa8\ub4e0 \uc0ac\uc6a9\uc790(Interested Transaction List, ITL)\ub97c \ud3ec\ud568\ud55c \uc815\ubcf4\ub97c \ube14\ub85d\uc5d0 \uae30\ub85d\ud569\ub2c8\ub2e4. <\/p>\n

\uc774 \uc601\uc5ed\uc758 \ub300\uae30\ub97c \uc904\uc774\ub824\uba74 \uc5ec\ub7ec ITL \uc2ac\ub86f\uc744 \ud5c8\uc6a9\ud558\uae30 \uc704\ud574 \ube14\ub85d\uc5d0 \uacf5\uac04\uc744 \ub9cc\ub4dc\ub294 initrans\ub97c \ub298\ub9bd\ub2c8\ub2e4. \ub610\ud55c \uc774 \ube14\ub85d\uc774 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc5d0\uc11c pctfree\ub97c \ub298\ub9b4 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uc9c0\uc815\ub41c initrans\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc791\uc131\ud55c \uc2ac\ub86f\uc774 \ucda9\ubd84\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0, ITL \uc815\ubcf4\uac00 maxtrans\uc5d0 \uc758\ud574 \uc9c0\uc815\ub41c \ucd5c\ub300 \uc218\uae4c\uc9c0 \uae30\ub85d\ub429\ub2c8\ub2e4.<\/font><\/div>\n

\n\n\n\n
\ub2e4\uc74c \ub2e8\uacc4<\/strong><\/span><\/center><\/p>\n
Statspack\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74<\/span>
<\/strong>OTN\uc5d0\uc11c “Statspack\uc744 \ud1b5\ud55c \uc131\ub2a5 \uc870\uc815”\uc744 \ucc38\uc870\ud558\uc2ed\uc2dc\uc624.<\/span>
<\/font>otn.oracle.com\/deploy\/performance\/pdf\/
statspack_tuning_otn_new.pdf<\/font><\/span><\/a><\/p>\n

Rich Niemiec\uc758 “Oracle Performance Tuning Tips and Techniques”<\/i>\uc744 Amazon.com\uc5d0\uc11c \uad6c\uc785\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span>
<\/font>amazon.com\/oracle<\/font><\/span><\/a><\/div>\n

\uc9c0\uc6d0\uc744 \ubc1b\uc73c\ub824\uba74 MetaLink\ub97c \ubc29\ubb38\ud558\uc2ed\uc2dc\uc624<\/span>
<\/font><\/strong>oracle.com\/support\/metalink\/index.html<\/font><\/span><\/a><\/div>\n
Oracle9i<\/i> \uc5d0 \ub300\ud55c \uad50\uc721\uc744 \ubc1b\uc73c\ub824\uba74 \ub2e4\uc74c \uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud558\uc2ed\uc2dc\uc624.<\/span>
<\/font><\/strong>otn.oracle.com\/oramag\/oracle\/searchou.html<\/font><\/span><\/a><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
<\/div>\n
<\/b><\/span> <\/div>\n
5. \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub798\uce58(Latch Free).<\/b> \ub798\uce58\ub294 \uc2dc\uc2a4\ud15c \uae00\ub85c\ubc8c \uc601\uc5ed(SGA)\uc5d0\uc11c \uacf5\uc720 \uba54\ubaa8\ub9ac \uad6c\uc870\ub97c \ubcf4\ud638\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ud558\uc704 \uc218\uc900 \ub300\uae30\uc5f4 \uba54\ucee4\ub2c8\uc998\uc774\uba70, \uc2e4\uc81c\ub85c\ub294 \uc0c1\ud638 \ubc30\uc81c \uba54\ucee4\ub2c8\uc998\uc774\ub77c\uace0 \ubd80\ub985\ub2c8\ub2e4. <\/p>\n

\ub9e4\uc6b0 \uc2e0\uc18d\ud558\uac8c \ud68d\ub4dd \ubc0f \ud574\uc81c\ub418\ub294 \uba54\ubaa8\ub9ac\uc758 \uc7a0\uae08\uacfc \uc720\uc0ac\ud55c \uae30\ub2a5\uc744 \uac00\uc9c4 \ub798\uce58\ub294 \uacf5\uc720 \uba54\ubaa8\ub9ac \uad6c\uc870\uc5d0 \ub300\ud55c \ub3d9\uc2dc \uc561\uc138\uc2a4\ub97c \ucc28\ub2e8\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ub798\uce58\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc73c\uba74 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub798\uce58 \uc2e4\ud328\uac00 \uae30\ub85d\ub429\ub2c8\ub2e4.<\/p>\n

\ub300\ubd80\ubd84\uc758 \ub798\uce58 \ubb38\uc81c\ub294 \ubc14\uc778\ub4dc \ubcc0\uc218(\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc \ub798\uce58), \ub9ac\ub450(redo) \uc0dd\uc131 \ubb38\uc81c (\ub9ac\ub450 \ud560\ub2f9 \ub798\uce58), \ubc84\ud37c \uce90\uc2dc \uacbd\ud569 \ubb38\uc81c(\uce90\uc2dc \ubc84\ud37c LRU \uccb4\uc778) \ubc0f \ubc84\ud37c \uce90\uc2dc\uc758 \ud56b \ube14\ub85d(\uce90\uc2dc \ubc84\ud37c \uccb4\uc778) \uc0ac\uc6a9\uc774 \uc2e4\ud328\ud558\ub294 \uac83\uacfc \uad00\ub828\ub429\ub2c8\ub2e4. <\/p>\n

\ub610\ud55c \ubc84\uadf8\uc640 \uad00\ub828\ub41c \ub798\uce58 \ub300\uae30\uac00 \uc874\uc7ac\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc774\ub7ec\ud55c \ub300\uae30\uac00 \uc758\uc2ec\uc2a4\ub7ec\uc6b4 \uacbd\uc6b0\uc5d0\ub294 MetaLink\uc5d0\uc11c \ubc84\uadf8 \ubcf4\uace0\uc11c\ub97c \uac80\uc0ac\ud569\ub2c8\ub2e4(oracle.com\/support<\/a>). \ub798\uce58 \uc2e4\ud328 \ube44\uc728\uc774 0.5%\ub97c \ucd08\uacfc\ud558\uba74 \ubb38\uc81c\uc810\uc744 \uc870\uc0ac\ud574\uc57c \ud569\ub2c8\ub2e4. \ub798\uce58 \ub300\uae30\ub294 \ubcc4\ub3c4\uc758 \ud56d\ubaa9\uc73c\ub85c \uc790\uc138\ud788 \ub2e4\ub8f0 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub2e4\uc74c\uc5d0 \uac8c\uc2dc\ub420 Oracle Magazine \uce7c\ub7fc\uc5d0\uc11c \uc774\uc5d0 \ub300\ud574 \uc790\uc138\ud558\uac8c \uc124\uba85\ud560 \uac83\uc785\ub2c8\ub2e4.<\/span><\/div>\n

<\/b><\/span> <\/div>\n
6. \ub300\uae30\uc5f4\uc5d0 \ub123\uae30(Enqueue).<\/b> \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub294 \uacf5\uc720 \ub9ac\uc18c\uc2a4\ub97c \ubcf4\ud638\ud558\ub294 \uc7a0\uae08\uc785\ub2c8\ub2e4. \uc7a0\uae08\uc740 \uacf5\uc720 \ub9ac\uc18c\uc2a4(\ub808\ucf54\ub4dc\uc758 \ub370\uc774\ud0c0)\ub97c \ubcf4\ud638\ud558\uc5ec \ub450 \uba85\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc77c\ud55c \ub370\uc774\ud0c0\ub97c \ub3d9\uc2dc\uc5d0 \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uac83\uc744 \ubc29\uc9c0\ud569\ub2c8\ub2e4. \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub294 \uc120\uc785 \uc120\ucd9c\ubc95(FIFO)\uc744 \uc0ac\uc6a9\ud558\ub294 \ub300\uae30\uc5f4 \uba54\ucee4\ub2c8\uc998\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4(Oracle\uc758 \ub798\uce58 \uba54\ucee4\ub2c8\uc998\uc740 FIFO\uac00 \uc544\ub2d8).<\/p>\n

\uc77c\ubc18\uc801\uc73c\ub85c \ub300\uae30\uc5f4\uc5d0 \ub123\uae30 \ub300\uae30\ub294 ST, HW, TX4 \ubc0f TM \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub97c \uac00\ub9ac\ud0b5\ub2c8\ub2e4. ST \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub294 \ub515\uc154\ub108\ub9ac \uad00\ub9ac \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ud560\ub2f9\uc774\ub098 \uacf5\uac04 \uad00\ub9ac\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ubb38\uc81c\uac00 \uc788\ub294 \ub515\uc154\ub108\ub9ac \uad00\ub9ac \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574\uc11c\ub294 LMT\ub97c \uc0ac\uc6a9\ud558\uac70\ub098, \ud655\uc7a5 \uc601\uc5ed\uc744 \ubbf8\ub9ac \ud560\ub2f9\ud558\uac70\ub098, \ucd5c\uc18c\ud55c \ub2e4\uc74c \ud655\uc7a5 \ubc94\uc704\ub97c \ub354 \ud06c\uac8c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4. HW \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub294 \uace0\uc218\uc704 \uc138\uadf8\uba3c\ud2b8\uc640 \ud568\uaed8 \uc0ac\uc6a9\ub418\uae30 \ub54c\ubb38\uc5d0 \ud655\uc7a5 \ubc94\uc704\ub97c \uc218\ub3d9\uc73c\ub85c \ud560\ub2f9\ud560 \uacbd\uc6b0 \uc774 \ub300\uae30\ub97c \uc6b0\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. TX4\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \ub300\uae30\uc5f4\uc5d0 \ub123\uae30 \ub300\uae30\uc785\ub2c8\ub2e4. TX4 \ub300\uae30\uc5f4\uc5d0 \ub123\uae30 \ub300\uae30\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc138 \uac00\uc9c0 \ubb38\uc81c\uc810 \uc911 \ud558\ub098\ub85c \uc778\ud574 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uccab \ubc88\uc9f8 \ubb38\uc81c\ub294 \uace0\uc720\ud55c \uc778\ub371\uc2a4\uc5d0 \uc874\uc7ac\ud558\ub294 \uc911\ubcf5\ub41c \uac12\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud558\ub294\ub370, \uc774 \uacbd\uc6b0\uc5d0\ub294 \ucee4\ubc0b\/\ub864\ubc31\uc744 \uc2e4\ud589\ud558\uc5ec \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub97c \ud574\uc81c\ud574\uc57c \ud569\ub2c8\ub2e4. <\/p>\n

\ub450 \ubc88\uc9f8 \ubb38\uc81c\ub294 \ub3d9\uc77c\ud55c \ube44\ud2b8\ub9f5 \uc778\ub371\uc2a4 \ubd80\ubd84\uc744 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc5c5\ub370\uc774\ud2b8\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \ub2e8\uc77c \ube44\ud2b8\ub9f5 \ubd80\ubd84\uc774 \uc5ec\ub7ec ROWID\ub97c \ud3ec\ud568\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc77c\ud55c \ubd80\ubd84\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\ub824\uace0 \ud560 \uacbd\uc6b0\uc5d0\ub294 \ucee4\ubc0b\/\ub864\ubc31\uc744 \uc2e4\ud589\ud558\uc5ec \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub97c \ud574\uc81c\ud574\uc57c \ud569\ub2c8\ub2e4. \uac00\uc7a5 \ud754\ud788 \ubcfc \uc218 \uc788\ub294 \uc138\ubc88\uc9f8 \ubb38\uc81c\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc77c\ud55c \ube14\ub85d\uc744 \uc5c5\ub370\uc774\ud2b8\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 \uc0ac\uc6a9 \uac00\ub2a5\ud55c ITL \uc2ac\ub86f\uc774 \uc5c6\uc744 \uacbd\uc6b0 \ube14\ub85d \uc218\uc900 \uc7a0\uae08\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub294 \uac04\ub2e8\ud558\uac8c \ubc29\uc9c0\ud560 \uc218 \uc788\ub294\ub370, initrans \ubc0f\/\ub610\ub294 maxtrans\ub97c \ub298\ub824 \uc5ec\ub7ec ITL \uc2ac\ub86f\uc744 \ud5c8\uc6a9\ud558\uac70\ub098 \ud14c\uc774\ube14\uc5d0\uc11c pctfree\ub97c \ub298\ub9ac\uba74 \ub429\ub2c8\ub2e4. <\/p>\n

\ub9c8\uc9c0\ub9c9\uc73c\ub85c TM \ub300\uae30\uc5f4\uc5d0 \ub123\uae30\ub294 \uc601\ud5a5 \ubc1b\uc740 \uac1d\uccb4\uc5d0 \ub300\ud55c DDL\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 DML \ub3c4\uc911\uc5d0 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc678\ub798 \ud0a4\uac00 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ubc1c\uc0dd\ud558\ub294 \uc774 \uc7a0\uae08 \ubb38\uc81c\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud574 \uc678\ub798 \ud0a4\ub97c \uc778\ub371\uc2a4\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/div>\n

<\/b><\/span> <\/div>\n
7 \ub85c\uadf8 \ubc84\ud37c \uacf5\uac04(Log Buffer Space).<\/b> \uc774 \ub300\uae30\ub294 LGWR\uc774 \ub9ac\ub450 \ub85c\uadf8\uc5d0 \uc4f8 \uc218 \uc788\ub294 \uac83\ubcf4\ub2e4 \ube60\ub974\uac8c \uc0ac\uc6a9\uc790\uac00 \ub85c\uadf8 \ubc84\ud37c\ub97c \uc4f0\uace0 \uc788\uac70\ub098 \ub85c\uadf8 \uc2a4\uc704\uce58\uac00 \ub108\ubb34 \ub290\ub9b0 \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub824\uba74 \ub85c\uadf8 \ud30c\uc77c\uc758 \ud06c\uae30\ub97c \ub298\ub9ac\uac70\ub098, \ub85c\uadf8 \ubc84\ud37c\uc758 \ud06c\uae30\ub97c \ub298\ub9ac\uac70\ub098, \ub354 \ube68\ub9ac \uc4f8 \uc218 \uc788\ub294 \ub514\uc2a4\ud06c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ub610\ud55c \uace0\uc18d\uc758 \uace0\uccb4 \uc0c1\ud0dc \ub514\uc2a4\ud06c\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uace0\ub824\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

8. \ub85c\uadf8 \ud30c\uc77c \uc2a4\uc704\uce58(Log File Switch). <\/b>\ubaa8\ub4e0 \ucee4\ubc0b \uc694\uccad\uc740 “\ub85c\uadf8 \ud30c\uc77c \uc2a4\uc704\uce58(\ud544\uc694\ud55c \uc544\uce74\uc774\ube0c)” \ub610\ub294 “\ub85c\uadf8 \ud30c\uc77c \uc2a4\uc704\uce58(\ubd88\uc644\uc804\ud55c \uccb4\ud06c\ud3ec\uc778\ud2b8)”\ub97c \uae30\ub2e4\ub9bd\ub2c8\ub2e4. \uc544\uce74\uc774\ube0c \ub514\uc2a4\ud06c\uac00 \uac00\ub4dd\ucc3c\uac70\ub098 \uc18d\ub3c4\uac00 \ub290\ub9ac\uc9c0 \uc54a\uc740\uc9c0 \ud655\uc778\ud574\uc57c \ud558\uba70, DBWR\uc740 I\/O\ub85c \uc778\ud574 \ub108\ubb34 \ub290\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uacbd\uc6b0\uc5d0 \ub530\ub77c\uc11c\ub294 \ub354 \ud06c\uac70\ub098 \ub9ce\uc740 \ub9ac\ub450 \ub85c\uadf8\ub97c \ucd94\uac00\ud574\uc57c \ud560 \uc218 \uc788\uace0, DBWR\uc774 \ubb38\uc81c\uc778 \uacbd\uc6b0\uc5d0\ub294 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uae30\ub85d\uc790\ub97c \ucd94\uac00\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/span> <\/p>\n<\/div>\n

9. \ub85c\uadf8 \ud30c\uc77c \ub3d9\uae30\ud654(Log File Sync).<\/b> \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud0c0\ub97c \ucee4\ubc0b\ud558\uac70\ub098 \ub864\ubc31\ud558\uba74 LGWR\uc740 \uc138\uc158\uc758 \ub9ac\ub450\ub97c \ub85c\uadf8 \ubc84\ud37c\uc5d0\uc11c \ub9ac\ub450 \ub85c\uadf8\ub85c \ube44\uc6c1\ub2c8\ub2e4. \ub85c\uadf8 \ud30c\uc77c \ub3d9\uae30\ud654 \ud504\ub85c\uc138\uc2a4\ub294 \uc774 \uc791\uc5c5\uc774 \uc131\uacf5\uc801\uc73c\ub85c \ub05d\ub0a0 \ub54c\uae4c\uc9c0 \uae30\ub2e4\ub824\uc57c \ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ub300\uae30 \uc774\ubca4\ud2b8\ub97c \uc904\uc774\ub824\uba74 \ub354 \ub9ce\uc740 \ub808\ucf54\ub4dc\uc758 \ucee4\ubc0b\uc744 \uc2dc\ub3c4\ud569\ub2c8\ub2e4(\uc608\ub97c \ub4e4\uc5b4, \ud55c \ubc88\uc5d0 \ud558\ub098\uc529 \ucee4\ubc0b\ud558\ub294 \ub300\uc2e0 50\uac1c\ub97c \uc77c\uad04\uc801\uc73c\ub85c \ucee4\ubc0b). LGWR\uc5d0\uc11c \uc544\uce74\uc774\ube0c \ud6a8\uacfc\ub97c \uc904\uc774\ub824\uba74 \ub9ac\ub450 \ub85c\ub4dc\ub97c \ub354 \ube60\ub978 \ub514\uc2a4\ud06c\uc5d0 \uc800\uc7a5\ud558\uac70\ub098 \ub2e4\ub978 \ubb3c\ub9ac\uc801 \ub514\uc2a4\ud06c\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4. RAID 5\ub294 \uc18d\ub3c4\uac00 \ub9e4\uc6b0 \ub290\ub9ac\uae30 \ub54c\ubb38\uc5d0 \uc4f0\uae30 \uc791\uc5c5\uc774 \ub9ce\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud574\uc11c\ub294 \uc548 \ub429\ub2c8\ub2e4. \ub300\uc2e0, \uc815\ubcf4\ub97c \uace0\uc18d\uc73c\ub85c \uc4f8 \uc218 \uc788\ub294 \ud30c\uc77c \uc2dc\uc2a4\ud15c \uc9c1\uc811 I\/O \ub610\ub294 \uc6d0\uc2dc \uc7a5\uce58\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uace0\ub824\ud569\ub2c8\ub2e4.
<\/p>\n

10. \ud734\uc9c0 \uc774\ubca4\ud2b8(Idle Event).<\/b> \ucd9c\ub825 \uc774\ud6c4\uc5d0 \ub098\uc5f4\ub418\ub294 \uc5ec\ub7ec \ud734\uc9c0 \ub300\uae30 \uc774\ubca4\ud2b8\uac00 \uc874\uc7ac\ud558\ub294\ub370, \uc774\ub7ec\ud55c \uc774\ubca4\ud2b8\ub97c \ubb34\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \ud734\uc9c0 \uc774\ubca4\ud2b8\ub294 \uac01 \ubd80\ubd84\uc758 \ub9e8 \uc544\ub798\uc5d0 \ub098\uc5f4\ub418\uba70, \uc774 \uc774\ubca4\ud2b8\uc5d0\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0 \ub300\ud55c \ub610\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\ub85c\ubd80\ud130\uc758 SQL*Net \uba54\uc2dc\uc9c0\ub098 \ub2e4\ub978 \ubc31\uadf8\ub77c\uc6b4\ub4dc \uad00\ub828 \ud0c0\uc774\ubc0d \ub4f1\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ud734\uc9c0 \uc774\ubca4\ud2b8\ub294 stats$idle_event \ud14c\uc774\ube14\uc5d0 \ub098\uc5f4\ub429\ub2c8\ub2e4.<\/span><\/div>\n

<\/font><\/strong><\/span> <\/div>\n
\uc9c0\uc18d\uc801\uc778 \uc870\uc815<\/font><\/strong><\/span><\/div>\n
\ub2e4\uc74c\uc5d0 \uac8c\uc2dc\ub420 Oracle Magazine\uc5d0\uc11c\ub294 \ub610 \ub2e4\ub978 \uc0c1\uc704 \ub300\uae30 \uc774\ubca4\ud2b8\uc778 \ub798\uce58\uc5d0 \ub300\ud574 \uc124\uba85\ud560 \uacc4\ud68d\uc785\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \ubcf4\uac8c \ub418\ub294 \ub798\uce58 \ub300\uae30\uc640 \uc774\ub7ec\ud55c \ub300\uae30\ub97c \uc870\uc815\ud558\uc5ec \ucd5c\uc0c1\uc758 \uc131\ub2a5\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ub420 \uac83\uc785\ub2c8\ub2e4.<\/span><\/div>\n
Rich Niemiec<\/b>\uc740 TUSC(<\/em>www.tusc.com<\/em><\/font><\/a>)\uc758 CEO\uc774\uc790 International Oracle Users Group(<\/em>www.ioug.org<\/em><\/a>)\uc758 \ud68c\uc7a5\uc785\ub2c8\ub2e4. \ubcf8 \uce7c\ub7fc\uc758 \ud3b8\uc9d1\uc740 Steve Adams\uac00 \uc218\uace0\ud574\uc8fc\uc168\uc2b5\ub2c8\ub2e4.<\/em><\/span><\/div>\n

<\/span><\/p>\n

<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\ub300\uae30 \uc774\ubca4\ud2b8 \ud035 \ub808\ud37c\ub7f0\uc2a4 \uac00\uc774\ub4dc<\/strong><\/span><\/center><\/td>\n<\/tr>\n
\ub300\uae30 \ubb38\uc81c<\/font><\/strong><\/span><\/td>\n\ud574\uacb0 \ubc29\ubc95<\/font><\/strong><\/span><\/td>\n<\/tr>\n
DB \ud30c\uc77c \ubd84\uc0b0 \uc77d\uae30<\/font><\/span><\/td>\n\uc5ec\ub7ec \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc744 \ub098\ud0c0\ub0c4: \ucf54\ub4dc\ub97c \uc870\uc815\ud558\uace0 \uc791\uc740 \ud14c\uc774\ube14\uc744 \uce90\uc2f1\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
DB \ud30c\uc77c \uc21c\ucc28 \uc77d\uae30<\/font><\/span><\/td>\n\uc5ec\ub7ec \uc778\ub371\uc2a4 \uc77d\uae30\ub97c \ub098\ud0c0\ub0c4: \ucf54\ub4dc(\ud2b9\ud788 \uc870\uc778)\ub97c \uc870\uc815\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ubc84\ud37c(Free Buffer)<\/font><\/span><\/td>\nDB_CACHE_SIZE\ub97c \ub298\ub9ac\uace0, \uccb4\ud06c\ud3ec\uc778\ud2b8\ub97c \uc904\uc774\uace0, \ucf54\ub4dc\ub97c \uc870\uc815\ud569\ub2c8\ub2e4..<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9 \uc911\uc778 \ubc84\ud37c<\/font><\/span><\/td>\n\uc138\uadf8\uba3c\ud2b8 \ud5e4\ub354: \uc0ac\uc6a9 \uac00\ub2a5 \ubaa9\ub85d \ub610\ub294 \uc0ac\uc6a9 \uac00\ub2a5 \ubaa9\ub85d \uadf8\ub8f9\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9 \uc911\uc778 \ubc84\ud37c<\/font><\/span><\/td>\n\ub370\uc774\ud0c0 \ube14\ub85d: initrans \ubc0f\/\ub610\ub294 maxtrans\ub97c \ub298\ub9bd\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9 \uc911\uc778 \ubc84\ud37c<\/font><\/span><\/td>\n\ub370\uc774\ud0c0 \ube14\ub85d: “\ud56b” \ub370\uc774\ud0c0\ub97c \ubd84\ub9ac\ud558\uace0 \uc5ed\ubc29\ud5a5 \ud0a4 \uc778\ub371\uc2a4 \ubc0f\/\ub610\ub294 \ub354 \uc791\uc740 \ube14\ub85d\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9 \uc911\uc778 \ubc84\ud37c<\/font><\/span><\/td>\n\uc2e4\ud589 \ucde8\uc18c \ud5e4\ub354: \ub864\ubc31 \uc138\uadf8\uba3c\ud2b8 \ub610\ub294 \uc601\uc5ed\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9 \uc911\uc778 \ubc84\ud37c<\/font><\/span><\/td>\n\uc2e4\ud589 \ucde8\uc18c \ube14\ub85d: \ub354 \uc790\uc8fc \ucee4\ubc0b\uc744 \uc2e4\ud589\ud558\uace0 \ub354 \ud070 \ub864\ubc31 \uc138\uadf8\uba3c\ud2b8 \ub610\ub294 \uc601\uc5ed\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ub798\uce58<\/font><\/span><\/td>\n\ub798\uce58 \uc138\ubd80 \uc0ac\ud56d\uc744 \uc870\uc0ac\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub300\uae30\uc5f4\uc5d0 \ub123\uae30-ST<\/font><\/span><\/td>\nLMT\ub97c \uc0ac\uc6a9\ud558\uac70\ub098 \ud070 \ud655\uc7a5 \uc601\uc5ed\uc744 \ubbf8\ub9ac \ud560\ub2f9\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub300\uae30\uc5f4\uc5d0 \ub123\uae30-HW<\/font><\/span><\/td>\n\ucd5c\uace0 \uc218\uc704\ubcf4\ub2e4 \ub192\uac8c \ud655\uc7a5 \uc601\uc5ed\uc744 \ubbf8\ub9ac \ud560\ub2f9\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub300\uae30\uc5f4\uc5d0 \ub123\uae30-TX4<\/font><\/span><\/td>\n\ud14c\uc774\ube14\uc774\ub098 \uc778\ub371\uc2a4\uc5d0\uc11c initrans \ubc0f\/\ub610\ub294 maxtrans\ub97c \ub298\ub9bd\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub300\uae30\uc5f4\uc5d0 \ub123\uae30-TX4<\/font><\/span><\/td>\n\uc678\ub798 \ud0a4\ub97c \uc778\ub371\uc2f1\ud558\uace0 \ud14c\uc774\ube14\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc7a0\uae08\uc744 \uac80\uc0ac\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub85c\uadf8 \ubc84\ud37c \uacf5\uac04<\/font><\/span><\/td>\n\ub85c\uadf8 \ubc84\ud37c\ub97c \ub298\ub9ac\uace0 \ub354 \ube60\ub978 \ub514\uc2a4\ud06c\ub97c \ub9ac\ub450 \ub85c\uadf8\uc5d0 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub85c\uadf8 \ud30c\uc77c \uc2a4\uc704\uce58<\/font><\/span><\/td>\n\uc544\uce74\uc774\ube0c \ub300\uc0c1\uc774 \uac00\ub4dd \ucc3c\uac70\ub098 \ub290\ub9ac\uc9c0 \uc54a\uc740\uc9c0 \ud655\uc778\ud558\uace0 \ub354 \ud06c\uac70\ub098 \ub9ce\uc740 \ub9ac\ub450 \ub85c\uadf8\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n
\ub85c\uadf8 \ud30c\uc77c \ub3d9\uae30\ud654<\/font><\/span><\/td>\n\ud55c \ubc88\uc5d0 \ub354 \ub9ce\uc740 \ub808\ucf54\ub4dc\ub97c \ucee4\ubc0b\ud558\uace0 \ub354 \ube60\ub978 \ub9ac\ub450 \ub85c\uadf8 \ub514\uc2a4\ud06c\ub098 \uc6d0\uc2dc \uc7a5\uce58\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4<\/font><\/span><\/td>\n<\/tr>\n
\ud734\uc9c0 \uc774\ubca4\ud2b8<\/font><\/span><\/td>\n\uc774\ubca4\ud2b8\ub97c \ubb34\uc2dc\ud569\ub2c8\ub2e4.<\/font><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\uc77c\ubc18 \ud734\uc9c0 \uc774\ubca4\ud2b8<\/strong><\/span><\/center><\/td>\n<\/tr>\n
\uc774\ubca4\ud2b8<\/font><\/strong><\/span><\/td>\n\ud734\uc9c0 \uc774\ubca4\ud2b8 \uc720\ud615<\/font><\/strong><\/span><\/td>\n<\/tr>\n
Dispatcher timer<\/font><\/span><\/td>\n\uacf5\uc720 \uc11c\ubc84<\/font><\/span><\/td>\n<\/tr>\n
Lock manager wait for remote message<\/font><\/span><\/td>\nOracle9i<\/i> Real Application Clusters<\/font><\/span><\/td>\n<\/tr>\n
Pipe get<\/font><\/span><\/td>\n\uc0ac\uc6a9\uc790 \ud504\ub85c\uc138\uc2a4<\/font><\/span><\/td>\n<\/tr>\n
pmon timer<\/font><\/span><\/td>\n\ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4<\/font><\/span><\/td>\n<\/tr>\n
PX Idle wait<\/font><\/span><\/td>\n\ubcd1\ub82c \uc9c8\uc758<\/font><\/span><\/td>\n<\/tr>\n
PX Deq Credit: need buffer<\/font><\/span><\/td>\n\ubcd1\ub82c \uc9c8\uc758<\/font><\/span><\/td>\n<\/tr>\n
PX Deq Credit: send blkd<\/font><\/span><\/td>\n\ubcd1\ub82c \uc9c8\uc758<\/font><\/span><\/td>\n<\/tr>\n
rdbms ipc message<\/font><\/span><\/td>\n\ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4<\/font><\/span><\/td>\n<\/tr>\n
smon timer<\/font><\/span><\/td>\n\ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4<\/font><\/span><\/td>\n<\/tr>\n
SQL*Net message from client<\/font><\/span><\/td>\n\uc0ac\uc6a9\uc790 \ud504\ub85c\uc138\uc2a4<\/font><\/span><\/td>\n<\/tr>\n
virtual Circuit status<\/font><\/span><\/td>\n\uacf5\uc720 \uc11c\ubc84<\/font><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n<\/div>\n

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

Statspack\uc744 \ud1b5\ud55c \uc2dc\uc2a4\ud15c \ud29c\ub2dd \uc800\uc790 Rich Niemiec   Statspack \ubcf4\uace0\uc11c\uc5d0 \ub300\uae30 \uc774\ubca4\ud2b8\uac00 \ubb34\uc5c7\uc744 \uc758\ubbf8\ud558\uba70, \uc774\ub7ec\ud55c \uc774\ubca4\ud2b8\ub97c \ud29c\ub2dd\ud558\ub294 \ubc29\ubc95\uc744 \ud655\uc778\ud558\uc2ed\uc2dc\uc624. Oracle \uc720\ud2f8\ub9ac\ud2f0\ub97c \ub2e8 \ub450 \uac1c\ub9cc \uc0ac\uc6a9\ud558\uc5ec Oracle9i Database \uc2dc\uc2a4\ud15c\uc758 \uc131\ub2a5 \ubb38\uc81c\ub97c \ud655\uc778 \ubc0f \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\ub2e4\uba74 \uc774\ub7ec\ud55c \ud234\uc740 Oracle Enterprise Manager(\ud604\uc7ac Release 4.0\uc5d0\uc11c \uc81c\uacf5\ub418\uace0 \uc788\uc74c)\uc640 Statspack\uc774 \ub420 \uac83\uc785\ub2c8\ub2e4. Oracle8i Release 8.1.6\uc5d0\uc11c \uc774\uc804 \ubc84\uc804\uc758 Oracle Database\uc758 \uc131\ub2a5 \ubaa8\ub2c8\ud130\uc5d0 \uc0ac\uc6a9\ud560 […]<\/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":[173,175,176],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/422"}],"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=422"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/422\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}