\uba3c\uc800, \uc704\uc5d0 \ubd84\uc774 \ub9d0\uc500\ud574\uc8fc\uc2e0 ERD..\uc544\uc8fc \uc911\uc694\ud558\uc8e0.
\n\ub9d0\uc500\ucc98\ub7fc \uc544\ubb34\ub9ac SQL\ubb38\uc7a5 \ud558\ub098 \ud29c\ub2dd\ud55c\ub2e4\uace0 \ud574\ub3c4 \uad6c\uc870\uc801\uc778 \ubaa8\uc21c\uc744 \uc5b4\uca54 \uc218 \uc5c6\ub294\uac70\uc8e0.
\n\uc560\ucd08\uc5d0 \ub514\uc790\uc778\uc744 \uc798 \ud558\uba74 \uc544\uc8fc \uc720\uc6a9\ud558\uaca0\uc8e0.
\n\ud558\uc9c0\ub9cc \uc2e4\uc81c \ud604\uc7a5\uc5d0\uc120 \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
\n\ud29c\ub2dd\uc744 \ub514\uc790\uc778 \ud560 \ub2f9\uc2dc\ubd80\ud130 \ub2f9\uc5f0\ud788 \uc2e0\uacbd\uc744 \uc368\uc57c\ud558\uc9c0\ub9cc, \ub300\uccb4\ub85c 99%\uc774\uc0c1\uc740
\n\uc77c\ub2e8 \uadf8\ub0e5 \uac1c\ubc1c\ud558\uace0, \uc6b4\uc6a9\ud558\ub2e4\uac00 \ubb38\uc81c(\uc18d\ub3c4\ub77c\ub4e0\uc9c0)\uac00 \uc0dd\uae30\uba74 \uadf8 \ub54c\uc11c\uc57c \ud29c\ub2dd\uc774\ub780 \ub9d0\uc774 \ub098\uc624\uae30 \ub9c8\ub828\uc774\uc8e0. \uc774\ub54c\ub294 ERD..\uc989 \uc544\ud0a4\ud14d\uccd0\ub97c \uace0\uce58\uc790\ub294 \ub9d0 \ud558\uae30 \uc27d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
\n\uba40\uca61\ud788(??) \ub3cc\uc544\uac00\uace0 \uc788\ub294 \ud504\ub85c\uadf8\ub7a8\uc744 \ub2e4 \ub72f\uc5b4\uace0\uce58\uc794\uac70\ub294 \uc27d\uc9c0\uac00 \uc54a\uc8e0.
\n\uc989, \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ucc28\uc6d0\uc758 \ud29c\ub2dd\uc740
\n\uccab\uc9f8, SQL \ubb38\uc7a5 \ud29c\ub2dd\uc744 \uc798\ud574\uc57c\ud569\ub2c8\ub2e4.
\n\ub458\uc9f8, \ucc98\uc74c\ubd80\ud130 \ub514\uc790\uc778\uc744 \uc798 \ud574\uc57c\ud569\ub2c8\ub2e4.
\n\uadf8\ub807\uc9c0\ub9cc \ub450\ubc88\uc9f8\uc758 \uacbd\uc6b0\ub294 \uc55e\uc11c \ub9d0\uc500\ub4dc\ub9b0\uac83\ucc98\ub7fc \uc27d\uc9c0\uac00 \uc54a\uc2b5\ub2c8\ub2e4. <\/p>\n
\ud29c\ub2dd\uc740 \ud06c\uac8c \ub450 \uac00\uc9c0\ub85c \ub098\ub269\ub2c8\ub2e4.
\n\uc2dc\uc2a4\ud15c \ud29c\ub2dd\uacfc SQL\ubb38\uc7a5 \ud29c\ub2dd\uc774\uc8e0.
\n\uba3c\uc800 SQL\ud29c\ub2dd\uc740 \ub9d0 \uadf8\ub798\ub3c4 SQL\ubb38\uc744 \uc801\uc808\ud788 \ubc14\uafd4\uc8fc\ub294\uac81\ub2c8\ub2e4.
\n\uc2e4\uc81c\ub85c \uc800 \uac19\uc740 \uacbd\uc6b0\ub3c4(\ucc38\uace0\ub85c \uc804 \uac1c\ubc1c\uc790\ub294 \uc544\ub2c8\uace0 DBA\uc785\ub2c8\ub2e4), \uc5b4\ub5a4 \ud504\ub85c\uadf8\ub7a8\uc774 \uc5c4\uccad\ub098\uac8c \uc624\ub7ab\ub3d9\uc548 \ub3cc\uc544\uac00\ub294 \uacbd\uc6b0\uac00 \uc788\uc5b4\uc11c, \ubb38\uc81c\uac00 \ub418\ub294 SQL\ubb38\uc7a5\uc744 \ucc3e\uc544\uc11c(tracing) \uc870\uac74\uc808\uc5d0 \uc870\uac74\uc744 \ud558\ub098 \ub354 \uc92c\ub354\ub2c8, 1\uc2dc\uac04\uc774\uc0c1 \ub3cc\uc544\uc57c \uacb0\uacfc\uac00 \ub098\uc628\ub354\uac83\uc774 \ub2e8 1\ubd84\ub9cc\uc5d0 \ub098\uc628\uc801\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
\nSQL\ud29c\ub2dd\uc744 \uc798 \ud558\uae30 \uc704\ud574\uc120 \uc77c\ub2e8 \uac1c\ubc1c \uacbd\ud5d8\uc774 \ub9ce\uc740\uac8c \uc720\ub9ac\ud569\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0 \uadf8\uc5d0 \ubc1b\uce68\uc774 \ub420 \ub9ce\ub098 \uc774\ub860\ub4e4(\uc804\uacf5\uc774\uc2dc\uc8e0?)\uc744 \uacf5\ubd80 \uc798 \ud574\ub458 \ud544\uc694 \ub2f9\uc5f0\ud788 \uc788\uc2b5\ub2c8\ub2e4.
\n\ub610\ud55c \uc624\ub77c\ud074\uc5d0\uc11c \uc77c\ubc18\uc801\uc73c\ub85c \ub9d0\ud558\ub294 \ud29c\ub2dd \uc815\ucc45(?)\uc5d0 \ub530\ub77c\uc11c \ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc608\ub97c \ub4e4\uba74, \uc544\uc6b0\ud130 \uc870\uc778\uc2dc\uc5d0\ub294 \uc591\ucabd \ud14c\uc774\ube14 \ubaa8\ub450\uc5d0 +\uae30\ud638\ub97c \uc0ac\uc6a9\ud558\uace0, \uc720\ub2c8\uc628\uc744 \ud560 \uacbd\uc6b0\uac00 \uc0dd\uae34\ub2e4\uba74 \ubc18\ub4dc\uc2dc union all\uc744 \uc368\uc57c \ud55c\ub2e4…\uc774\ub7f0 \ub0b4\uc6a9\ub4e4\uc774\uc8e0.
\n\uadf8\ub9ac\uace0 literal variable\ub9d0\uace0 binding variable\uc744 \uc368\ub77c..
\n(select * from emp where empno=:a \uc774\ub7f0\uac70\uc8e0)->\uc774\uac74 \uc81c \ub2f5\ubcc0\uc744 \ucc38\uace0\ud558\uc138\uc694..
\n360813 Database\uc5d0\uc11c \ud55c\ubc88 \uc870\ud68c\ub41c \uacb0\uacfc\ub97c \ub2e4\uc2dc \uc870\ud68c\ud558\uba74 -> \uc694\uac8c \uc9c8\ubb38\uc785\ub2c8\ub2e4.<\/p>\n
\uc774\ub7f0\uac70\ub294 \uc624\ub77c\ud074 \ucc45\uc744 \ubb34\uc870\uac74 \ub9ce\uc774 \ubcf4\ub294 \uc218\ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4.
\n\ub610\ud55c, \ud639 \uc624\ub77c\ud074\uc744 \uacf5\uc2dd\uc801\uc73c\ub85c \uad6c\uc785\ud574\uc11c \uc0ac\uc6a9\ud558\uc2dc\ub294 \uace0\uac1d\uc774\ub77c\uba74, \uace0\uac1d\ubc88\ud638\ub85c \uba54\ud0c0\ub9c1\ud06c(http:\/\/metalink.oracle.com)\uac19\uc740 \uacf3\uc5d0\uc11c \uc5c4\uccad\ub09c \uc790\ub8cc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc8fc\ub85c \ud2b8\ub7ec\ube14\uc288\ud305\uc5d0 \uad00\ub828\ub418\uc5b4\uc11c \uc5c4\uccad\ub098\uac8c \ub3c4\uc6c0\uc744 \uc5bb\uc744 \uc218 \uc788\ub294 \uacf3\uc774\uc8e0.
\n\ubb3c\ub860 \uc5ec\ud0c0 \uacf5\uc2dd \ubb38\uc11c\ub4e4\ub3c4 \ub514\uac8c \ub9ce\uc2b5\ub2c8\ub2e4. \uc624\ub77c\ud074\uc758 \uad00\ud55c \ubaa8\ub4e0 \ubb38\uc81c\ub294 \uc5ec\uae30\uc11c \ud574\uacb0\ud55c\ub2e4\uace0 \ubcf4\uc154\ub3c4 \uc5b4\uca5c \ubb34\ubc29\ud560 \uc815\ub3c4\uc8e0.
\n\uc598\uae30\uac00 \uc606\uc73c\ub85c \uc880 \uc14c\uc2b5\ub2c8\ub2e4. –;;<\/p>\n
\uc2dc\uc2a4\ud15c \ud29c\ub2dd\uc740 \ub2e4\uc2dc 2\uac00\uc9c0 \uc815\ub3c4\ub85c \ub098\ub260 \uc218 \uc788\uaca0\uc2b5\ub2c8\ub2e4. \ubb3c\ub860 \uc81c \uc0dd\uac01\uc785\ub2c8\ub2e4.
\n\uccab\ubc88\uc9f8\ub294 \uc624\ub77c\ud074 RDBS\uc5d0 \ub300\ud55c \ud29c\ub2dd\uc774\uace0 \ub450\ubc88\uc9f8\ub294 \ub9d0 \uadf8\ub798\ub3c4 \uc804\uccb4 \uc2dc\uc2a4\ud15c(OS \ub4f1)\uc5d0 \ub300\ud55c \ud29c\ub2dd\uc774\ub77c\uace0 \ud560 \uc218 \uc788\uaca0\uc8e0.
\n\ub2d8\uaed8\uc11c \uc608\ub85c \ub4dc\uc2e0 \ubcd1\ub82c\uc2dc\uc2a4\ud15c..\uc774\ub7f0\uac74 \uc0ac\uc2e4 DB\ud29c\ub2dd\uc774\ub791\uc740 \ud070 \uad00\uacc4\uac00 \uc5c6\uc744\uac83 \uac19\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc \uc624\ub77c\ud074\uc5d0\uc11c \ub9d0\ud558\ub294 parallel query\ub77c\ub4e0\uc9c0 standby db\ub77c\ub358\uc9c0 \ud558\ub294 \uc5b4\ub5a4 \ubc29\ubc95\ub860\uc801\uc778 \ubd80\ubd84\uc774\ub77c\uba74 \uc598\uae34 \uc880 \ud2c0\ub824\uc9c0\uaca0\uc8e0.
\n\ubb3c\ub860 OS\ucc28\uc6d0\uc5d0\uc11c\uc758 I\/O\ucc98\ub9ac\ub77c\ub358\uc9c0 \ud558\ub294 \ubd80\ubd84\uc5d0\uc11c DB\uc790\uccb4\uc758 \uc18d\ub3c4\uc5d0 \ub3c4\uc6c0\uc744 \uc904 \uc218 \uc788\ub2e4\uace0 \uc0dd\uac01\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc608\ub97c \ub4e4\uc5b4, \uc2dc\uc2a4\ud15c\uc5d0 Disk controller\uac00 2\uac1c\uac00 \uc788\uace0, \uac01\uac01\uc758 \ucee8\ud2b8\ub864\ub7ec\uc5d0 internal 1, external 1\uac1c\uc529 \ubd99\uc5b4\uc788\ub2e4..\uc774\ub7f4 \uacbd\uc6b0, \ucee8\ud2f0\ub864\ub7ec(\ub514\uc2a4\ud06c)\uc758 \ud6a8\uacfc\uc801\uc778 \uc0ac\uc6a9\uc744 \uc704\ud574\uc11c \ud55c\ucabd\uc5d0\ub294 DB \uc5d4\uc9c4 \uc989 \uc624\ub77c\ud074 \uc790\uccb4\ub97c \ub450\uace0, \ud55c\ucabd\uc5d0 \ub370\uc774\ud0c0 \ud30c\uc77c\uc744 \uc704\uce58 \uc2dc\ud0a8\ub2e4..\ubb50 \uc774\ub7f0\uac70\ub3c4 \ub420 \uc218 \uc788\uaca0\ub124\uc694.
\n\uc5b4\uca0c\ub4e0 \uc804\uccb4 \uc2dc\uc2a4\ud15c\uc5d0 \ub300\ud55c \uc774\ud574…\uc774\uac83\ub3c4 \uc911\uc694\ud55c \ubd80\ubd84\uc774\uc9c0\ub9cc, \uc774\uac74 \ub098\uc911 \ubb38\uc81c\uc8e0.
\n\ub2e4\ub9cc \uc778\uc2a4\ud1a8\uc2dc\ubd80\ud130 OS\uc5d0 \ub300\ud55c patch\ub77c\ub358\uc9c0, \uc544\ub2d8 kernel parameter\ub97c \uc870\uc815\ud574 \uc904 \ud544\uc694\uac00 \uc788\uc744 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n
\uc911\uc694\ud558\uac74 \uc544\ubb34\ub798\ub3c4 \uc624\ub77c\ud074 RDBMS\uc5d0 \ub300\ud55c \ud29c\ub2dd\uc774\uc8e0.
\n\uc774\uac74 \uc790\ub8cc\ub97c \uc5f4\uc2ec\ud788 \ub4a4\uc801\uac70\ub9ac\uace0 \ud14c\uc2a4\ud2b8 \ud558\ub294…\uacf5\ubd80\ub97c \ud574\uc57c\ud569\ub2c8\ub2e4.
\n\uc77c\ub2e8 \uc81c \uc0dd\uac01\uc5d0..\ub2d8\uaed8\uc11c \uc624\ub77c\ud074 \uc815\uc2dd \uace0\uac1d\uc774\ub77c\uba74 \uc624\ub77c\ud074 \uc601\uc5c5\uc0ac\uc6d0\uc5d0\uac8c \ucc45\uc744 \ub2ec\ub77c\uace0 \ud558\uc138\uc694. \uc624\ub77c\ud074\uc744 \uc0ac\uba74 \ub2e4 \uc918\uc57c \ud558\ub294\uac81\ub2c8\ub2e4.
\n\uadf8\ub7fc \ud55c 30\uad8c\ucbe4 \ub418\ub294 \ucc45\uc744 \uac16\ub2e4 \uc90d\ub2c8\ub2e4. \ub2e4 \uc601\ubb38\uc778\ub370\uc694.
\n\uadf8\uac70 \ub2e4 \ubcf4\uace0 \uc81c\ub300\ub85c \uc774\ud574\ud558\uba74 \uc815\ub9d0 \ud6cc\ub96d\ud55c \ud29c\ub108\uac00 \ub418\uc2e4\uac83 \uac19\uc2b5\ub2c8\ub2e4..^^
\n\uac70\uae30\uc5d0\ub294 \ub2d8\uaed8\uc11c \uad81\uae08\ud574\ud558\uc2dc\ub294..(\uad81\uae08\ud574\ud558\uc2dc\ub294\uc9c0 \ubaa8\ub974\uaca0\uc9c0\ub9cc..)
\n\uc608\ub97c \ub4e4\uc5b4 \uc5b4\ub514\uc11c \ubb50\uac00 waiting\uc774 \uac78\ub838\ub098..\uc774\ub7f0\uac70 \ubcfc \ub54c..
\nv$sysstat\uc5d0 \ub098\uc624\ub294 \uac01 \ub0b4\uc6a9\ub4e4\uc774 \ubb34\uc5c7\uc744 \uc758\ubbf8\ud558\ub294\uc9c0 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\ub610\ud55c \uba54\ud0c0\ub9c1\ud06c\uc640 \uc5f0\uacc4\ud558\uba74 \uadf8 \uac12\ub4e4\uc744 \uc5b4\ub5bb\uac8c \uc870\uc815\ud574\uc918\uc57c \ud558\ub294\uc9c0\ub3c4 \uc54c \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4.<\/p>\n
\ub9cc\uc57d \uc774\ub7f0 \uc0ac\uc815\uc774 \uc548\ub41c\ub2e4\uba74(\uc624\ub77c\ud074 \uacf5\uc2dd \uace0\uac1d\uc774 \uc544\ub2c8\ub77c\uba74)…
\n\uc2dc\uc911\uc5d0 \ub098\uc640\uc788\ub294 \ucc45\ub4e4\uc744 \ubd10\uc57c\uaca0\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub7f0\ub370 \uc2dc\uc911\uc5d0 \ub098\uc640\uc788\ub294 \ucc45..(\uc0ac\uc2e4 \uc804 \ud55c\uad8c\ub3c4 \uc548 \ubd24\uc2b5\ub2c8\ub2e4..–;;;)
\n\uc774\ud654\uc2dd\uc528\uc758 \ub300\uc6a9\ub7c9..\uc774 \ucc45 \uac70\uc758 \ubc14\uc774\ube14\ucc98\ub7fc \uc874\uacbd(??)\ubc1b\uc2b5\ub2c8\ub2e4..\ub9cc
\n\uc774 \ucc45\uc740 \uc5bc\ud54f \ubd24\ub294\ub370..\uc77c\ub2e8 \uc4f0\uc5ec\uc9c4\uc9c0\uac00 \ub108\ubb34 \uc624\ub798\ub410\uc2b5\ub2c8\ub2e4.
\n\uc544\uc2dc\uaca0\uc9c0\ub9cc \uc9c0\uae08 9i\ub97c \ub118\uc5b4\uc11c 10G\uac00 \ub098\uc654\uc2b5\ub2c8\ub2e4.
\n\uc774\ud654\uc2dd\uc528\uc758 \ucc45\uc740(\uc774\ud654\uc2dd\uc528\ub294 \ud604\uc7ac\ub294 \uc5d4\ucf54\uc5b4\ub77c\ub294 \ud68c\uc0ac\ub97c \ub9cc\ub4dc\uc168\ub354\uad70\uc694..\uac70\uae34 \uc2e4\uae30 \uc2dc\ud5d8\ub3c4 \ubcf8\ub300\uc694..\u314e\u314e\u314e) 7\ubc84\uc804\ub300\uc5d0\uc11c \ub9ce\uc774 \ubb38\uc81c(?)\uac00 \ub418\uc5c8\ub358 RBO(Role Based Optimizer)\uc5d0 \uad00\ud55c \ub0b4\uc6a9\uc774 \ub9ce\ub358\uac78\ub85c \uc5bc\ud54f \ubd24\uc2b5\ub2c8\ub2e4…
\n\uadf8\ub7ec\ub098 \uc774 \ucc45\uc740(\ubd84\uba85\ud788 \ub9d0\uc500\ub4dc\ub9ac\ub294\ub370 \uc804 \uc774 \ucc45 \uadf8\ub0e5 \uc5bc\ud54f \ud558\uba74 \ucb49 \ub118\uae30\uba74\uc11c \ubcf8\uac70 \ubfd0\uc774\ub2c8 \uac4d \ucc38\uace0\ud558\uc2dc\uae38) \ub098\ub984\ub300\ub85c \uc5b4\ub5a4 \uc6d0\ub9ac, \uc624\ub77c\ud074\uc758 \uba54\uce74\ub2c8\uc998\uc5d0 \ub300\ud55c \uc774\ud574\ub97c \ubc14\ud0d5\uc73c\ub85c \uc124\uba85\uc744 \ud558\ub294 \ub4ef\ud55c \ub290\ub08c\uc744 \ubc1b\uc558\uc2b5\ub2c8\ub2e4. \uadf8\ub7fc\uc73c\ub85c \uc624\ub77c\ud074\uc5d0 \ub300\ud55c \uc804\uccb4\uc801\uc778 \uba54\uce74\ub2c8\uc998 \uc774\ud574\uc5d0\ub294 \uaf64 \uc88b\uc744\uac70\ub780 \uc0dd\uac01\ub3c4 \ub4ed\ub2c8\ub2e4.<\/p>\n
\uc5d0..\uc774\uc81c \uc9c8\ubb38\uc5d0 \ub2f5\ud569\ub2c8\ub2e4..^^;;<\/p>\n
1. \ub2d8\uc774 \uc9c0\uae08 \uc5b4\ub5a4 \uc77c\uc744 \ud558\uace0 \uacc4\uc2e0\uc9c0..\ud559\uc0dd\uc778\uc9c0 \uc798 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4\ub9cc..
\n\uc77c\ub2e8\uc740 \uac1c\ubc1c\uc744 \ud574\ubcf4\uc2dc\ub294\uac8c \uc88b\uaca0\uc2b5\ub2c8\ub2e4. \uadf8\uac83\ub3c4 \ube61~\uc138\uac8c\uc694..\u314e\u314e\u314e
\n\uc6d0\ub798 DBA\ub77c\ub294\uac8c \uac1c\ubc1c\uc744 \uc69c\uc2ec\ud788 \ud558\ub2e4\uac00 DB\ub97c \ub354 \uacf5\ubd80\ud574\uc11c DBA\uac00 \ub418\ub294\uac8c \uc77c\ubc18\uc801\uc778 \ucf54\uc2a4\ub77c\uace0\ub4e4 \ud569\ub2c8\ub2e4. \uadf8 \ub9cc\ud07c \uac1c\ubc1c base\uac00 \ud544\uc694\ud558\ub2e8 \uc598\uae30\uc8e0.
\n2. \uc774\ud654\uc2dd\uc528 \ucc45..\ubcf4\uc2ed\uc2dc\uc694. \ubd10\uc11c \ud574\ub420\uac70 \uc5c6\uc2b5\ub2c8\ub2e4.
\n3. admin..\uc774\uac70 \uc911\uc694\ud569\ub2c8\ub2e4. \ub098\uc911\uc5d0 \ud29c\ub108(\uc0ac\uc2e4 \uc774\ub7f0 \uc9c1\uc5c5\uc740 \uc544\uc9c1 \uc6b0\ub9ac\ub098\ub77c\uc5d4 \uc5c6\ub2e4\uace0 \ubd05\ub2c8\ub2e4\ub9cc)\uac00 \ub418\uae30 \uc704\ud574\uc120 \uc544\uc8fc\uc544\uc8fc \uc911\uc694\ud558\ub2e4\uace0 \ubd05\ub2c8\ub2e4.
\n\uc774\uac70\ub97c \uc798 \ud558\uae30 \uc704\ud574\uc120 \uacf5\ubd80 \ub9ce\uc774 \ud574\uc57c\ud569\ub2c8\ub2e4.
\n\uac00\ub2a5\ud558\ub2e4\uba74 \uc624\ub77c\ud074\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uacf5\uc2dd \uc11c\uc801\ub4e4\uc744 \ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. \uc5b4\ub514\uc11c\ub4e0 \ub9cc\ub4e0 \ud68c\uc0ac\uc5d0\uc11c \ub098\uc628 \ub9e4\ub274\uc5bc(??)\uc774 \uc824 \uc88b\uae30 \ub9c8\ub828\uc785\ub2c8\ub2e4.
\n\ucc38\uace0\ub85c \uc624\ub77c\ud074\uc758 \uc790\ub8cc\ub4e4\uc740 90%\uc774\uc0c1\uc774 \uc601\uc5b4\uc785\ub2c8\ub2e4. \uc548\ub41c \uc598\uae30\uc9c0\ub9cc \ud55c\uae00\ub85c \ub41c\uac83\ub4e4\uc740 \ubcc4\ub85c \uc4f8\ubaa8(??)\ub3c4 \uc5c6\uace0, \uadf8\ub098\ub9c8 \uac70\uc758 \uc601\uc5b4\ub97c \ubc88\uc5ed\ud55c \uc218\uc900\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub2c8 \uc601\uc5b4\uacf5\ubd80\ub3c4 \uc880 \ud558\uc154\uc57c..–;;;;
\n4.\uc5b4\uca5c \uc824 \uc911\uc694\ud55c\uac78 \uc218 \uc788\ub294\ub370\uc694..\uc9c1\uc811 \ud574\ubd10\uc57c \ud569\ub2c8\ub2e4.
\n\uc624\ub77c\ud074 initSID.ora\uc758 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \ud558\ub098 \uace0\uccd0\uc11c \ubb34\uc5c7\uc774 \ubc14\ub00c\ub294\uc9c0 \uc2dc\uc2a4\ud15c \ubdf0\ub4e4 \ub2e4 \ub4a4\uc838\uc11c\ub77c\ub3c4 \ucc3e\uc544\uc57c \ud569\ub2c8\ub2e4. \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uad00\ub9ac(admin)\ud558\ub2e4\ubcf4\uba74 \uc815\ub9d0 \uc608\uc0c1\uce58 \ubabb\ud55c \uacbd\uc6b0\ub3c4 \ub9ce\uc774 \uc0dd\uae41\ub2c8\ub2e4. \uadf8\ub7ec\ub2c8 \uadf8 \uc804\uc5d0 \uc9c1\uc811 \ub2e4 \ud574\ubd10\uc57c \ud569\ub2c8\ub2e4. \ubc31\uc5c5&\ub9ac\ucee4\ubc84\ub9ac.. \uc774\ub7f0\uac70 \uc2dc\ub098\ub9ac\uc624\ub97c \uad6c\ud558\ub358\uc9c0 \uc2a4\uc2a4\ub85c \ub9cc\ub4e4\ub358\uc9c0..\ud574\uc11c \ub2e4 \ud574\ubd10\uc57c \ud569\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0 \ub610 \uc911\uc694\ud55c\uac74..\uc774\ub807\uac8c \ud558\uba74\uc11c \ub178\ud2b8\ub97c \uc791\uc131\ud558\ub294\uac81\ub2c8\ub2e4. \ud55c \ubc88 \ud574\ubd24\ub2e4\uace0 \uadf8\uac8c \uba38\ub9ac\uc5d0 \ub0a8\uaca0\uc2b5\ub2c8\uae4c? \uadf8 \ub2f9\uc2dc\uc758 \uc0c1\ud669\uc774\ub791 \uc790\uc2e0\uc774 \ucde8\ud55c \uc870\uce58\ub97c \uc21c\uc11c\ub300\ub85c \uac00\ub2a5\ud558\uba74 \uaf3c\uaf3c\ud788 \uc368 \ub450\ub294\uac70 \ub3c4\uc6c0 \ub9ce\uc774 \ub429\ub2c8\ub2e4. \ub098\uc911\uc5d0 \ub3c4\uc6c0 \ubc1b\uae30 \uc704\ud574\uc11c\uac00 \uc544\ub2c8\uace0 \uc774\uac83\ub3c4 \uacf5\ubd80\uc785\ub2c8\ub2e4.
\n5.\uc624\ub77c\ud074\uc774 \uc81c\uacf5\ud558\ub294 \uc81c\ud488\uc774 \ucc38\uc73c\ub85c \ub2e4\uc591\ud569\ub2c8\ub2e4. DB\ub9cc \ub5a8\ub801 \uc788\ub294\uac70 \uc544\ub2d9\ub2c8\ub2e4. \uc5c4\uccad\ub098\uac8c \ub9ce\uc2b5\ub2c8\ub2e4..–;; \ub4dc\ub9ac\uace0 \uc2f6\uc740 \uc598\uae34 \ubb50\ub0d0\uba74…\uc774\ub4e4\uc774 \uc81c\uacf5\ud558\ub294 \uc815\ubcf4\ub4e4\uc744 \ub193\uce58\uc9c0 \uc54a\uae30 \uc704\ud574\uc11c otn\uac19\uc740\ub370 \uc790\uc8fc \ub4e4\ub77d\uac70\ub9ac\uace0..\uc624\ub77c\ud074 \ub9e4\uac70\uc9c4(1\ub144\uc5d0 4\ubc88 \ub098\uc624\ub098??)\uac19\uc740\uac70 \uacf5\uc9dc\ub2c8\uae50 \uad6c\ub3c5\ud558\uc2dc\uace0..\uc624\ub77c\ud074\uacfc \uad00\ub828\ub41c \ub9ce\uc740 \uc0ac\uc774\ud2b8\ub4e4(database.sarang.net \ubb50 \uc774\ub7f0\uac83\ub4e4)\ud2c8\ud2c8\ud788 \uc8fc\uc2dc\ud558\uc2dc\ub294 \ub4f1\uc758 \ub178\ub825\uc744 \ubcd1\ud589\ud574\uc57c\ud569\ub2c8\ub2e4.<\/p>\n
\ucc98\uc74c\uc5d4 \uc9c0\uc2dd\uc774 \ub2e8\ud3b8\uc801\uc77c \uc218 \ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4.
\n\uadf8\uac78 \uc544..\ub09c \uc815\ub9d0 \uc774\ub7f0\uac8c \uc544\ub2c8\uace0 \uc804\uccb4\uc801\uc778 \uac78..\ud06c\uac8c \ubcf4\ub294 \uadf8\ub7f0\uac78 \ud558\uace0 \uc2f6\uc740\ub370..\uacf5\ubd80\uac00..\uc774\uac8c \uc544\ub2cc\ub370..
\n\uc544\ub2cc\uac8c \uc544\ub2c8\ub77c..\ub9de\uc2b5\ub2c8\ub2e4. \ub2e8\ud3b8\uc774 \ubaa8\uc5ec\uc11c \uc7a5\ud3b8(??) \ub429\ub2c8\ub2e4.
\n\ubb50\ub4e0\uc9c0 \uc678\uc6b0\uace0 \uc775\ud600\ub450\uc138\uc694. \ub098\uc911\uc5d0 \ud37c\uc990\ucc98\ub7fc \ub531\ub531 \ub9de\ucdb0\uc838 \uac11\ub2c8\ub2e4.<\/p>\n
\ubb50 \uc0dd\uac01\ub098\ub294\ub300\ub85c \uc368 \ubd24\ub294\ub370..\uc77c\ubd80\ub7ec \ub2f5\ubcc0\uae30\uac04\uc744 \uae38\uac8c \ub450\uc168\ub2e4\ub2c8..\uc800\ub3c4 \uc0dd\uac01\ub098\uba74 \uc640\uc11c \ub2e4\uc2dc \ucd94\uac00\ud558\uc8e0..<\/p>\n
\uacf5\ubd80 \uc5f4\uc2ec\ud788 \ud558\uc138\uc694..^^
\n\ub0b4\uc6a9\ucd9c\ucc98 : \ubcf8\uc778\uc774~ <\/p>\n
\ub2f5\ubcc0\ub4e4
\nTunning \ubc29\ubc95\uc740 \uc5ec\ub7ec\uac00\uc9c0 \uc785\ub2c8\ub2e4. <\/p>\n
kcg1932 (2003-12-18 08:37 \uc791\uc131) \uc774\uc758\uc81c\uae30
\nTunning \ubc29\ubc95\uc740
\nSystem \uc801\uc73c\ub85c \uc811\uadfc\ud558\ub294 \ubc29\ubc95\uacfc
\nApplication\uc73c\ub85c \uc811\uadfc\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
System \uc801\uc778 \uc811\uadfc\uc740 \uc81c\uac00 \uc798\ubab0\ub77c\uc11c \uc0dd\ub7b5\uc744 \ud558\uace0
\nApplication\uc73c\ub85c \uc811\uadfc\ud558\ub294 \ubc29\ubc95\uc744 \uc81c\uac00 \ud558\ub294\ud55c..
\nApplicaion\uc73c\ub85c \uc811\uadfc\uc744 \ud558\uae30 \uc704\ud558\uc5ec \ubcf4\ud1b5\uc740
\n\uc635\ud2f0\ub9c8\uc774\uc800\ub2c8 index\ub2c8 \ub9d0\uc744 \ub9ce\uc774 \ud569\ub2c8\ub2e4.
\n\uc774 Factor\uc5ed\uc2dc \uc911\uc694\ud569\ub2c8\ub2e4.
\n\uadf8\ub7ec\ub098 Applicaion\uc744 Tunning\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub370\uc774\ud0c0\ub97c \uc815\ud655\ud788 \uc54c\uace0 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n\ub370\uc774\ud0c0\ub97c \uc815\ud655\ud788 \uc548\ub2e4\ub294 \uac83\uc740 \uc5c5\ubb34\ub97c \uc54c\uace0 \uc788\ub2e4\ub294 \uac83\uc774\uace0
\n\uc774\ub294 ERD\ub97c \uc815\ud655\ud788 \uc774\ud574\ud558\uace0 \uc788\ub2e4\ub294 \ub9d0\uc785\ub2c8\ub2e4.<\/p>\n
\uc77c\ubc18\uc801\uc73c\ub85c Tunning\uc744 \ud560\ub54c index\ub098 Optimizer \uae30\ud0c0 \uc11c\ubc84 \ud658\uacbd\uc744 \uc911\uc2dc\ud558\ub294
\n\uacbd\ud5a5\uc774 \uc788\uc2b5\ub2c8\ub2e4..<\/p>\n
\uadf8\ub7ec\ub098 \uc808\ub300\uc801\uc73c\ub85c \uac04\uacfc\ud574\uc11c\ub294 \uc548\ub418\ub294 \uac83\uc774 ERD \uc785\ub2c8\ub2e4.
\n(RDBMS\uc5d0\uc11c ERD \uc5c6\uc774 Application\uc744 \uc791\uc131\ud558\ub294 \uac83\uc774\ub098
\n\uc774 Application\uc744 \uc774\ud574\ud558\ub294 \uac83\uc740 \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4.)<\/p>\n
\uc989 \uc815\ud655\ud788 ERD\ub97c \uc774\ud574\ud558\uace0 \ub098\uba74 \ub370\uc774\ud0c0\uac00 \uc5b4\ub5bb\uac8c \uad6c\uc131\uc774 \ub418\uc5b4 \uc788\uace0
\n\ub370\uc774\ud0c0\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \ucd5c\uc801\uc758 \uc815\ucc45\uc774 \uacb0\uc815\uc774 \ub429\ub2c8\ub2e4
\n\uc774\ub54c Index \ubc0f Optimizer\ub97c \ubd84\uc11d\uc744 \ud574\uc57c \ud560 \uac83\uc73c\ub85c \uc0dd\uac01\uc774 \ub429\ub2c8\ub2e4.<\/p>\n
\ub2d8\uaed8\uc11c \uc81c\uc2dc\ud558\ub294 \ubc29\ubc95\uc740 \ubb3c\ub860 \uc911\uc694\ud569\ub2c8\ub2e4.
\nAdmin\uc744 \uc774\ud574\ud55c\ub2e4\ub294 \uac83\uc740 DBMS\uad6c\uc870\ub97c \uc774\ud574\ud558\ub294 \uac83\uc774\ubbc0\ub85c Optimizer \uc815\ucc45\uc5d0 \uc911\uc694\ud558\uace0
\n\uacf5\ud559\uacf5\ubd80 \uc774\ub294 \uc9d1\ud569\uc5d0 \ub300\ud55c \uac1c\ub150\uc73c\ub85c \uc815\ud655\ud55c SQL\ubb38\uc7a5\uc744 \uad6c\ud604\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub418\uba70
\n\uc54c\uace0\ub9ac\uc998 \uc5ed\uc2dc Optimizer\uc744 \uc774\ud574\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uaca0\uc9c0\uc694..<\/p>\n
\uadf8\ub7ec\ub098 \uc5ed\uc2dc \uc624\ub77c\ud074 \uc5ed\uc2dc RDB \uc0ac\uc0c1\uc744 \uac00\uc9c4 \uc81c\ud488\uc774\uae30 \ub54c\ubb38\uc5d0
\nERD \ub97c \uc815\ud655\ud788 \uc774\ud574 \ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uc608\ub97c\ub4e4\uc5b4 \uc77c\ubc18\uc801\uc73c\ub85c SQL\ubb38\uc7a5\uc744 Tunning\ud558\uae30 \uc704\ud574\uc11c\ub294
\n\ud574\ub2f9 SQL \ubb38\uc7a5\ub9cc\uc744 \uac00\uc9c0\uace0 Tuning\ud558\ub294 \uacbd\ud5a5\uc774 \uc788\ub294\ub370
\n\uc774\uac8c \uc544\ub2c8\ub77c ERD\ub97c \ubcf4\uace0 \uc870\uae08\ub354 \ub098\uc740 Access \uacbd\ub85c\uac00 \uc788\ub294\uc9c0\ub97c \ud655\uc778\ud6c4\uc5d0
\nTunning \ud558\uc5ec\uc5ec \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4..<\/p>\n
\uacb0\ub860\uc740 Application Tunning\uc744 \ud558\uae30 \uc704\ud574\uc11c\ub294 RDB\uc5d0 \ub300\ud55c \uc815\ud655\ud55c \uc774\ud574(\uc9d1\ud569)\uac00
\n\ud544\uc694\ud558\uace0 \uc774\ub97c \ubc14\ud0d5\uc73c\ub85c ERD\ub97c \ube60\ub978 \uc2dc\uac04\uc5d0 \uc774\ud574\ud558\ub294\uac8c \uc911\uc694\ud558\ub2e4\uace0 \uc0dd\uac01\uc774 \ub429\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\uba3c\uc800, \uc704\uc5d0 \ubd84\uc774 \ub9d0\uc500\ud574\uc8fc\uc2e0 ERD..\uc544\uc8fc \uc911\uc694\ud558\uc8e0. \ub9d0\uc500\ucc98\ub7fc \uc544\ubb34\ub9ac SQL\ubb38\uc7a5 \ud558\ub098 \ud29c\ub2dd\ud55c\ub2e4\uace0 \ud574\ub3c4 \uad6c\uc870\uc801\uc778 \ubaa8\uc21c\uc744 \uc5b4\uca54 \uc218 \uc5c6\ub294\uac70\uc8e0. \uc560\ucd08\uc5d0 \ub514\uc790\uc778\uc744 \uc798 \ud558\uba74 \uc544\uc8fc \uc720\uc6a9\ud558\uaca0\uc8e0. \ud558\uc9c0\ub9cc \uc2e4\uc81c \ud604\uc7a5\uc5d0\uc120 \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud29c\ub2dd\uc744 \ub514\uc790\uc778 \ud560 \ub2f9\uc2dc\ubd80\ud130 \ub2f9\uc5f0\ud788 \uc2e0\uacbd\uc744 \uc368\uc57c\ud558\uc9c0\ub9cc, \ub300\uccb4\ub85c 99%\uc774\uc0c1\uc740 \uc77c\ub2e8 \uadf8\ub0e5 \uac1c\ubc1c\ud558\uace0, \uc6b4\uc6a9\ud558\ub2e4\uac00 \ubb38\uc81c(\uc18d\ub3c4\ub77c\ub4e0\uc9c0)\uac00 \uc0dd\uae30\uba74 \uadf8 \ub54c\uc11c\uc57c \ud29c\ub2dd\uc774\ub780 \ub9d0\uc774 \ub098\uc624\uae30 \ub9c8\ub828\uc774\uc8e0. \uc774\ub54c\ub294 ERD..\uc989 \uc544\ud0a4\ud14d\uccd0\ub97c \uace0\uce58\uc790\ub294 \ub9d0 \ud558\uae30 … \uc2e4\ub825\uc788\ub294Oracle Tunner<\/span> \ub354\ubcf4\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-267","post","type-post","status-publish","format-standard","hentry","category-18"],"_links":{"self":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/posts\/267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=267"}],"version-history":[{"count":0,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=\/wp\/v2\/posts\/267\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.outofnoise.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}