{"id":351,"date":"2009-11-19T06:41:01","date_gmt":"2009-11-19T06:41:01","guid":{"rendered":"http:\/\/apollo89.com\/wordpress\/?p=351"},"modified":"2013-02-02T12:03:46","modified_gmt":"2013-02-02T03:03:46","slug":"dba%ec%97%90%ea%b2%8c-%ec%9c%a0%ec%9a%a9%ed%95%9c-toad%ec%9d%98-%ec%88%a8%ec%9d%80-%ea%b8%b0%eb%8a%a5-%ec%b0%be%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/apollo89.com\/wordpress\/?p=351","title":{"rendered":"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30"},"content":{"rendered":"

 <\/p>\n

DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30<\/p>\n

\ubc15\uc911\uc218 | \uc5d4\ucee4\ube14\ub8e8 \uae30\uc220\ubcf8\ubd80 \ub300\ud45c \ucee8\uc124\ud134\ud2b8<\/p>\n

\uae30\uc5c5\uc5d0\uc11c\uc758 \ub370\uc774\ud130 \uc99d\uac00\ub294 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \ub298\uc5b4\ub098\uace0 \uc788\uc73c\uba70 \uadf8\uc5d0 \ub530\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\ub3c4 \ub300\uc6a9\ub7c9\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ubc1c\uc804\ud558\uace0 \uc788\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 \uc608\uc804\uacfc \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc6b4\uc601\uc744 \ub9e4\ub274\uc5bc\ud558\uac8c \ud560 \uc218 \uc788\ub294 \uc0c1\ud0dc\uc5d0 \uc9c1\uba74\ud574 \uc788\uc73c\uba70, \uc790\ub3d9\ud654\ub41c \ubaa8\ub2c8\ud130\ub9c1 \ubc0f Alerts\ub85c \uc548\uc815\uc801\uc778 \uc11c\ube44\uc2a4\uc5d0 \ub300\uc751\ud560 \uc218 \uc788\ub294 \ud234\uc744 \uc6d0\ud558\uace0 \uc788\ub2e4. \uc774\ub7ec\ud55c \uc694\uad6c\uc0ac\ud56d\uc744 \uc704\ud55c \ud1a0\ub4dc\uc758 GUI \ud658\uacbd\uc5d0\uc11c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \uae30\ub2a5\uc744 \uc0b4\ud3b4\ubcf4\uc790.<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ubc1c\uc5d0 \uc788\uc5b4 \ud1a0\ub4dc(Toad)\ub97c \uc0ac\uc6a9\ud558\ub294 \uc0ac\ub78c\ub4e4\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \u201c\ud1a0\ub4dc\ub294 \uac1c\ubc1c\uc790\ub4e4\uc744 \uc704\ud55c \uac1c\ubc1c \ud234\u201d\uc774\ub780 \uc0dd\uac01\uc744 \ub9ce\uc774 \ud55c\ub2e4. \uc989 \ub2e8\uc21c\ud788 SQL \ubb38\uc7a5\uc774\ub098 PL\/SQL \ubb38\uc7a5\uc744 \ube60\ub974\uace0 \uc27d\uac8c \uac1c\ubc1c\ud560 \uc218 \uc788\uace0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\uc758 \uc0dd\uc131 \ubc0f \ubcc0\uacbd \uc791\uc5c5\uc744 GUI \ud658\uacbd\uc5d0\uc11c \uac04\ub2e8\ud558\uac8c \uc218\ud589\ud558\uba70 \uc18c\uc2a4\ucf54\ub4dc \uc0c1\uc758 \ubb38\uc81c\uc810\ub4e4\uc744 \uc790\ub3d9\uc73c\ub85c \ucc3e\uc544\uc8fc\uace0, \ub514\ubc84\uae45 \uae30\ub2a5\uc744 \ud1b5\ud574 \uac1c\ubc1c\uc790\ub4e4\uc758 \uc218\uace0\ub97c \ub35c\uc5b4 \uc904 \uc218 \uc788\ub294 \ud234 \uc815\ub3c4\ub85c\ub9cc \uc778\uc2dd\ud558\uace0 \uc788\ub294 \uac83\uc774\ub2e4. \ud558\uc9c0\ub9cc \ud1a0\ub4dc\ub97c \uc880 \ub354 \uc138\ubc00\ud558\uac8c \ub4e4\uc5ec\ub2e4\ubcf4\uba74 \uac1c\ubc1c\uc790\ub9cc\uc744 \uc704\ud55c \ud234\uc774 \uc544\ub2cc \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac(management)\ud558\ub294 DBA(Database Administrator)\uac00 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \uae30\ub2a5\ub4e4\uc774 \uc228\uaca8\uc838 \uc788\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \ud1a0\ub4dc\uc5d0 \uc228\uaca8\uc9c4 \uc720\uc6a9\ud55c \uae30\ub2a5\uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0\uc790 \ud55c\ub2e4.<\/p>\n

DBA\uc758 \uc5ed\ud560\uc740 \ubb34\uc5c7\uc77c\uae4c?<\/p>\n

DBA\ub294 \ud604\uc7ac \uc6b4\uc601\ub418\uace0 \uc788\ub294 \uc2dc\uc2a4\ud15c, \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc560\ud50c\ub9ac\ucf00\uc774\uc158, \ub124\ud2b8\uc6cc\ud06c, \uc11c\ube44\uc2a4 \ub4f1\uc758 \ub2e4\uc591\ud55c \ud658\uacbd\uc744 \uad6c\uc131\ud558\uace0 \uc124\uce58, \ubcf4\uc548, \uc6b4\uc601 \ubc0f \uc124\uacc4\ub098 \uac1c\ubc1c \ub2e8\uacc4\uc5d0 \uc9c1, \uac04\uc811\uc801\uc73c\ub85c \ucc38\uc5ec\ud574 \uc804\uccb4 \uad6c\uc131\uc774 \uc6d0\ud65c\ud558\uac8c \uc720\uc9c0\ub418\ub3c4\ub85d \ud558\ub294 \uc5c5\ubb34\ub97c \ub2f4\ub2f9\ud558\uace0 \uc788\ub2e4.<\/p>\n

\uc774\ub7ec\ud55c \uc5c5\ubb34\ub97c \uc218\ud589\ud558\ub2e4 \ubcf4\uba74 \uc6d0\ud558\ub294 \uc11c\ube44\uc2a4\uac00 \uc81c\ub300\ub85c \ub3d9\uc791\ud558\uc9c0 \ubabb\ud558\uace0 \ud2b9\uc815 \ubd80\ubd84\uc5d0 \ub300\ud55c \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\uac70\ub098 \uc54c \uc218 \uc5c6\ub294 \uadf8 \ubb34\uc5c7\uc778\uac00\uc5d0 \uc758\ud574 \uc131\ub2a5\uc774 \uc6d0\ud558\ub294 \ub9cc\ud07c \ub098\uc624\uc9c0 \uc54a\uc744 \uacbd\uc6b0\ub3c4 \uc788\ub2e4. \ud2b9\ud788 DBA\uc5d0\uac8c \ub0b4\u00b7\uc678\uc801 \uc694\uc18c\uc5d0 \uc758\ud55c \ub73b\ud558\uc9c0 \uc54a\ub294 \ub3cc\ubc1c\uc0c1\ud669\uc73c\ub85c \uc778\ud574 \uc18c\ube44\ub418\ub294 \uc2dc\uac04\uc774\ub098 \ub178\ub825\uc740 \uac00\uc7a5 \ud070 \ubd80\ub2f4\uc774\ub2e4. \uc774\ub7f4 \uacbd\uc6b0 DBA\ub294 \ub204\uad70\uac00\uac00 \ud604\uc7ac\uc758 \uc2dc\uc2a4\ud15c\uc774\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubd80\ud558 \uc5c6\uc774 \ud6a8\uc728\uc801\uc73c\ub85c \ubb38\uc81c\uc810\uc744 \ucc3e\uc544\ub0b4\uc5b4 \uc6d0\uc778 \ud30c\uc545\uc744 \ud574\uc8fc\uace0 \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud560 \ubc29\ubc95\uc744 \uc81c\uc2dc\ud574 \uc900\ub2e4\uba74 \ud558\ub298\ub85c \ub0a0\uc544\uac08 \uac83 \uac19\uc740 \uae30\ubd84\uc744 \ub290\ub084 \uac83\uc774\ub2e4.<\/p>\n

\uc2e4\uc81c DBA\ub4e4\uc740 \uc774\ub85c \uc778\ud574 \ubc1c\uc0dd\ud558\ub294 \ube44\uc6a9\uc744 \ucd5c\uc18c\ud654\ud558\uae30 \uc704\ud574 \ud234\uc744 \uc0ac\uc6a9\ud55c\ub2e4. \ud558\uc9c0\ub9cc \ubb38\uc81c\uc810\uc744 \uac10\uc9c0\ud558\ub294 \ud234, \ubb38\uc81c\uc810\uc744 \ubd84\uc11d\ud558\ub294 \ud234, \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud558\ub294 \ud234\uc5d0 \uc774\ub974\uae30\uae4c\uc9c0 \ub2e4\uc591\ud55c \ud234 \ub3c4\uc785\uc5d0 \ub530\ub77c \ubc1c\uc0dd\ud558\ub294 \ube44\uc6a9 \ubd80\ub2f4\uacfc \ud568\uaed8 \ud234\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uac00\ub97c \uc0dd\uac01\ud574\ubcf4\uba74 \ud798\uc774 \ube60\uc9c8 \uc218\ubc16\uc5d0 \uc5c6\ub2e4.<\/p>\n

\uc774 \uae00\uc5d0\uc11c\ub294 \ud234\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uae30 \uc704\ud574 \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \ud1a0\ub4dc\ub77c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ubc1c \ud234\uc744 \uc120\ud0dd\ud588\ub2e4. \ud2b9\ud788 \ud1a0\ub4dc\ub294 \uac1c\ubc1c \ud234 \uc704\uc8fc\ub85c \uac1c\ubc1c\uc774 \ub410\uc9c0\ub9cc \u2018DBA \ubaa8\ub4c8\u2019\uc774\ub77c\ub294 \uc635\uc158 \uae30\ub2a5\uc774 \uc788\uc5b4 \ud1a0\ub4dc \ud558\ub098\ub9cc \uac16\uace0\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd5c\uc801\uc758 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774 \uc788\ub2e4. \ubb3c\ub860 \uc804\ubb38\uc801\uc73c\ub85c \uac10\uc9c0\u00b7\ubd84\uc11d\u00b7\ud574\uacb0\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd98 \ubc29\ub300\ud55c \ud234\uacfc\uc758 \ube44\uad50\ub294 \uc5b4\ub835\uaca0\uc9c0\ub9cc \uadf8\ub798\ub3c4 \uc801\uc740 \ube44\uc6a9\uc73c\ub85c \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \uc194\ub8e8\uc158\uc774 \uc788\ub2e4\uba74 \uc88b\uc9c0 \uc54a\uaca0\ub294\uac00.<\/p>\n

DB\uc758 \ubb38\uc81c\uc810\uc744 \ubc1c\uacac\ud558\ub77c!<\/p>\n

\ud1a0\ub4dc\ub97c \uad6c\uc785\ud588\ub2e4\uace0 \ud574\uc11c DBA \uae30\ub2a5\uc744 \uc804\ubd80 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4(\u2018\ud1a0\ub4dc DBA \ubaa8\ub4c8\u2019\uc740 \uc635\uc158 \uc81c\ud488\uc774\ub2e4). \uc81c\ud488\uc744 \uad6c\uc785\ud560 \ub2f9\uc2dc\uc5d0 DBA \ubaa8\ub4c8\uc774\ub77c\ub294 \uc81c\ud488\uc744 \ucd94\uac00\uc801\uc73c\ub85c \uad6c\uc785\ud574\uc57c \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4. \ud558\uc9c0\ub9cc \uac1c\ubc1c \uc704\uc8fc\uc758 \uc791\uc5c5\uc774 \uc544\ub2cc \uc804\uc0ac\uc801\uc778 \ubc29\ubc95\uc73c\ub85c \ud1a0\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uac83\uc774\ub77c\uba74 \ucd94\ucc9c\ud560 \ub9cc\ud55c \uc0ac\ud56d\uc774\ub77c\uace0 \uc0dd\uac01\ud55c\ub2e4. \uadf8\ub7ec\uba74 \uc790\uc2e0\uc774 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \ud1a0\ub4dc\ub97c \uac16\uace0 \uc774 DBA \uae30\ub2a5\uc744 \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc744\uae4c?<\/p>\n

\ud655\uc778\ud560 \uc218 \uc788\ub294 \uac00\uc7a5 \uac04\ub2e8\ud55c \ubc29\ubc95\uc740 \ud1a0\ub4dc\uc758 \uba54\uc778 \uba54\ub274 \uc911\uc5d0\uc11c DBA \uba54\ub274\ub97c \ud074\ub9ad\ud574 \ubcf4\uba74 \uadf8 \uc544\ub798 \ub9ac\uc2a4\ud2b8\uac00 \uae38\uac8c \ub098\uc640 \uc788\ub290\ub0d0 \uc9e7\uac8c \ub098\uc640 \uc788\ub290\ub0d0\uc5d0 \ub530\ub77c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\ud654\uba74 1>\ucc98\ub7fc \uae38\uac8c \ub9ac\uc2a4\ud2b8\uac00 \ub098\uc628\ub2e4\uba74 DBA\uc758 \uae30\ub2a5\uc744 \ucd5c\uc801\uc758 \uc0c1\ud0dc\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \ub73b\uc774\ub2e4. \uadf8\ub7fc \ud1a0\ub4dc\uc758 DBA \uae30\ub2a5\uc744 Detect, Diagnostic, Resolve\ub77c\ub294 3\uac1c\uc758 \ub2e8\uacc4\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd94\uc5b4 \uc0b4\ud3b4\ubcf4\uc790.<\/p>\n

<\ud654\uba74 1> DBA \uba54\ub274<\/p>\n

<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uba74 DBA\ub294 \uc77c\ub2e8 \uc6d0\uc778\ubd80\ud130 \ud30c\uc545\ud55c\ub2e4. \ud558\uc9c0\ub9cc \uc5b4\ub290 \ubd80\ubd84\uc774 \ubb38\uc81c\uac00 \uc788\ub294\uc9c0\ub97c \uac10\uc9c0\ud558\uae30\ub780 \uc0ac\ub9c9\uc5d0\uc11c \ubaa8\ub798\uc54c\uc744 \ucc3e\ub294 \uac83\ub9cc\ud07c \uc5b4\ub824\uc6b4 \uc77c\uc774\ub2e4. \ud1a0\ub4dc\uc5d0\uc11c \uc9c0\uc6d0\ud558\uace0 \uc788\ub294 DBA \uae30\ub2a5 \uc911\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130(Database Monitor), \ud5ec\uc4f0 \uccb4\ud06c(Health Check), \uc778\uc2a4\ud134\uc2a4 \ub9e4\ub2c8\uc800(Instance Manager)\ub97c \ud1b5\ud574 \ud604\uc7ac\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0c1\ud0dc\ub97c \uac10\uc9c0\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130<\/p>\n

\uc6b0\uc120 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc790\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc744 \ub192\uc774\uae30 \uc704\ud574 \ubb3c\ub9ac\uc801\uc778 I\/O\uc758 \ubcd1\ubaa9\ud604\uc0c1\uc744 \uc81c\uac70\ud568\uc73c\ub85c\uc368 \uc2dc\uc2a4\ud15c\uc758 \uba54\ubaa8\ub9ac\uc640 CPU \uc790\uc6d0\uc758 \uacbd\ud569\uc744 \uc904\uc774\uba70 \uc548\uc815\uc801\uc778 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\ub2e4. \uadf8\ub9ac\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc790\ub294 \uac01 \uc138\uc158\ub4e4\uc5d0\uc11c \ubc1c\uc0dd\ub418\ub294 Wait Event(\ub124\ud2b8\uc6cc\ud06c \ud1b5\uc2e0\uc774\ub098 I\/O \uc694\uccad \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud2b9\uc815 \uc790\uc6d0\uc744 \uc5ec\ub7ec \ud504\ub85c\uc138\uc2a4\uac00 \ub3d9\uc2dc\uc5d0 \uc561\uc138\uc2a4\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \uacbd\ud569\uc5d0 \uc758\ud55c \ub300\uae30)\uc758 \uc6d0\uc778\uc744 \uc81c\uac70\ud568\uc73c\ub85c\uc368 \uc6d0\ud65c\ud55c \uc751\ub2f5\uc18d\ub3c4\ub97c \uc720\uc9c0\ud574\uc57c \ud55c\ub2e4.<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130 \uae30\ub2a5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 Data Dictionary (V$SYSSTAT, V$SYSTEM_EVENT)\ub97c \uc774\uc6a9\ud574 \uba54\ubaa8\ub9ac, I\/O, Latch, \uc138\uc158 \uadf8\ub8f9\uc73c\ub85c \ub098\ub220 \uad00\ub828 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud574 <\ud654\uba74 2>\uc640 \uac19\uc774 9\uac00\uc9c0 \uadf8\ub8f9\uc73c\ub85c \uc0ac\uc6a9\uc790\uac00 Refresh Rate(Interval)\ub97c \uc801\uc6a9\ud574 \uc8fc\uc5b4\uc9c4 \uc2dc\uac04\uc5d0 \ub530\ub77c \ubcc0\ud654\ub418\ub294 \ubaa8\uc2b5\uc744 \ud55c \ud654\uba74\uc5d0\uc11c \ubcfc \uc218 \uc788\ub2e4. \uc774\uc5d0 \uc131\ub2a5\uacfc \uad00\ub828\ub41c \ubb38\uc81c\uc810\uc744 \uc27d\uac8c \ud30c\uc545\ud560 \uc218 \uc788\uc73c\uba70, \uc131\ub2a5\uc5d0 \uc9c0\uc7a5\uc744 \ucd08\ub798\ud55c SQL\uc758 \uc9c4\ub2e8 \ub610\ub294 \ucd08\uae30 \ud30c\ub77c\ubbf8\ud130\ub97c \uc870\uc815\ud560 \uc218 \uc788\ub2e4.<\/p>\n

<\ud654\uba74 2> \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130<\/p>\n

<\/p>\n

\u25c6 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\uc758 \uc8fc\uc694 \uae30\ub2a5<\/p>\n

\u2460 Auto Refresh \uc124\uc815 \uae30\ub2a5<\/p>\n

\u2461 Refresh Rate \uc124\uc815 \uae30\ub2a5<\/p>\n

\u2462 Alerts\uc5d0 \ub300\ud55c Propagation \uae30\ub2a5<\/p>\n

\u2463 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 Data Dictionary(V$) \uc815\ubcf4 \uadf8\ub798\ud53d \ub514\uc2a4\ud50c\ub808\uc774 \uae30\ub2a5<\/p>\n

\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\uc758 \uadf8\ub798\ud504 \uc815\ubcf4<\/p>\n

\u2460 Logical I\/O : \ub17c\ub9ac\uc801\uc778 I\/O\ub294 SGA(\uba54\ubaa8\ub9ac)\uc5d0 \uc874\uc7ac\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube14\ub7ed\uc758 Change, Current, Consistent Read\ub4e4\uc5d0 \ub300\ud55c \ud1b5\uacc4 \ucd94\uc774\uc758 \uc815\ubcf4<\/p>\n

\u2461 Physical I\/O : \ubb3c\ub9ac\uc801\uc778 I\/O\ub294 \ub370\uc774\ud130\ud30c\uc77c(\ub514\uc2a4\ud06c)\uc758 \ud574\ub2f9 \ube14\ub7ed\uc744 \uc77d\uc5b4 SGA(\uba54\ubaa8\ub9ac)\ub85c \uc62c\ub9ac\uac70\ub098 \ub610\ub294 \uba54\ubaa8\ub9ac\uc5d0\uc11c \ubcc0\uacbd\ub41c \ube14\ub7ed\uc744 \ub370\uc774\ud130\ud30c\uc77c(\ub514\uc2a4\ud06c)\ub85c \uc791\uc131, \uadf8\ub9ac\uace0 LGWR\uc5d0 \uc758\ud574\uc11c \uc628\ub77c\uc778 \ub9ac\ub450(redo) \ub85c\uadf8 \ud30c\uc77c\ub85c \uc791\uc131\ub418\ub294 \ud1b5\uacc4 \ucd94\uc774\uc758 \uc815\ubcf4<\/p>\n

\u2462 Event Wait : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc2dc\uc2a4\ud15c \ub610\ub294 \uc138\uc158\ubcc4\ub85c \ubc1c\uc0dd\ud558\ub294 Wait \uc774\ubca4\ud2b8 \ud1b5\uacc4 \uc815\ubcf4\ub97c \ub204\uc801\ud574 \uae30\ub85d\ud558\ub294\ub370 \ud480 \uc2a4\uce94(Full Scan)\uc2dc I\/O\ub97c \uc694\uccad\ud558\uace0 \ub300\uae30\ud558\ub294 \u2018Mulit-block Read\u2019, \uc778\ub371\uc2a4 \uc2a4\uce94\uc2dc I\/O\ub97c \uc694\uccad\ud558\uace0 \ub300\uae30\ud558\ub294 \u2018Single-block Read\u2019, \ud14c\uc774\ube14 \uc2a4\uce94\uc2dc \ubc84\ud37c \uce90\uc2dc\ub97c \uac70\uce58\uc9c0 \uc54a\ub294 \u2018Direct Patch Read\u2019 \ub4f1\uc758 \ud1b5\uacc4 \ucd94\uc774\uc758 \uc815\ubcf4<\/p>\n

\u2463 Sessions : Sessions\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c \ubaa8\ub4e0 \uc138\uc158\ub4e4\uc744 \ud65c\ub3d9 \uc138\uc158(active), \ubc31\uadf8\ub77c\uc6b4\ub4dc \uc138\uc158(system), \uc544\uc774\ub4e4(Idle) \uc138\uc158\uc73c\ub85c \ubd84\ub958\ud574 \ud45c\ud604\ud55c \uc815\ubcf4<\/p>\n

\u2464 all Rates : \uc0ac\uc6a9\uc790\uac00 \uc694\uccad\ud55c SQL\uc5d0 \ub300\ud55c \uad6c\ubb38 \ubd84\uc11d(parse), \uc2e4\ud589(execute), \ubcc0\uacbd \uc815\ubcf4 \uc601\uad6c\uc800\uc7a5(commit), \ubcc0\uacbd \uc815\ubcf4 \ucde8\uc18c(rollback) \uc815\ubcf4<\/p>\n

\u2465 Miss Rates : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub300\ud45c\uc801\uc778 \uc131\ub2a5 \uc9c0\ud45c\uc778 \ubc84\ud37c \uce90\uc2dc(Buffer Cache) \ubbf8\uc2a4\uc728, \ub77c\uc774\ube0c\ub7ec\ub9ac\/\ub515\uc154\ub108\ub9ac \ubbf8\uc2a4\uc728(SQL Area), \ub798\uce58 \ubbf8\uc2a4\uc728(Latch)\uc758 \uc815\ubcf4<\/p>\n

\u2466 SGA Memory Usage : SGA\uc5d0 \ud560\ub2f9\ub41c \uba54\ubaa8\ub9ac\uc758 \uc0ac\uc6a9\ub960\uc5d0 \ub300\ud55c \uc815\ubcf4(Shared Pool, \ubc84\ud37c \uce90\uc2a4, \ub85c\uadf8 \ubc84\ud37c)<\/p>\n

\u2467 Shared Pool : SGA\uc5d0 \ud560\ub2f9\ub41c \uba54\ubaa8\ub9ac \uc911 SQL\uc5d0 \ub300\ud55c \uacf5\uc720 \uba54\ubaa8\ub9ac\uc758 Detail \uc0ac\uc6a9\ub960\uc5d0 \ub300\ud55c \uc815\ubcf4(\ub77c\uc774\ube0c\ub7ec\ub9ac \uce90\uc2dc, \ub515\uc154\ub108\ub9ac \uce90\uc2dc, Misc Area \ub4f1)<\/p>\n

\u2468 Index Query % : \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ub41c SQL \uc911 \ucffc\ub9ac\uc5d0 \ub300\ud574 \uc778\ub371\uc2a4 \uc0ac\uc6a9(Indexed %)\uacfc \ubbf8\uc0ac\uc6a9(Non-Indexed %)\uc5d0 \ub300\ud55c \uc815\ubcf4<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\uc758 Alert<\/p>\n

\uadf8\ub807\ub2e4\uba74 DBA\ub294 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ubb38\uc81c\uc810\uc774 \uc788\ub294\uc9c0\uc758 \uc5ec\ubd80\ub97c \ud310\ub2e8\ud558\uae30 \uc704\ud574 \ud56d\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \ud234\uc744 \ubcf4\uace0\ub9cc \uc788\uc5b4\uc57c \ud558\ub294\uac00? \uadf8\ub807\ub2e4\uba74 \uc9c4\uc815\ud55c \ud0d0\uc9c0 \ud234(Detection Tool)\uc774\ub77c\uace0 \ud560 \uc218\uac00 \uc5c6\uc744 \uac83\uc774\ub2e4. \uc774\ub97c \uc704\ud574 Alert \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4. \ud1a0\ub4dc \uc635\uc158\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\ub97c \ucc3e\uc544\ubcf4\uba74 \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0\uc790 \ud558\ub294 \uc55e\uc758 9\uac00\uc9c0 \ud56d\ubaa9\ub4e4\uc5d0 \ub300\ud574 \uc784\uacc4\uce58(Thresholds)\ub97c \uc124\uc815\ud574 \ud574\ub2f9 \uc784\uacc4\uce58\uc5d0 \ub3c4\ub2ec\ud558\uba74 Alert\ub97c DBA\uc5d0\uac8c \ubcf4\uc5ec\uc904 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\ub2e4. \uadf8\ub7ec\uba74 \ud1a0\ub4dc\uac00 \uc124\uce58\ub418\uc5b4 \uc788\ub294 PC\uc758 \ub9e8 \uc544\ub798\uc5d0 Toad Database Monitor\ub77c\ub294 \uc544\uc774\ucf58\uc774 \ub098\ud0c0\ub098\uc11c DBA\uc5d0\uac8c \uc2e0\ud638\ub97c \ubcf4\ub0b4\uc900\ub2e4.<\/p>\n

\ud5ec\uc4f0 \uccb4\ud06c<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\ucd95 \ud6c4 \uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c \ub370\uc774\ud130\uc758 \ud06c\uae30\ub294 \ud604\uc800\ud558\uac8c \uc99d\uac00\ud558\uac8c \ub418\uace0 \ub610\ud55c \ub2e4\uc591\ud55c \ubb38\uc81c\uc810\ub4e4\uc774 \ub098\ud0c0\ub098\uac8c \ub418\ub294\ub370, \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\uc810\ub4e4\uc744 DBA\uac00 \ucc3e\uc544\uc11c \uc870\uce58\ud558\uae30\uc5d0\ub294 \uc2dc\uac04\uacfc \ube44\uc6a9\uc774 \ub9cc\ub9cc\uce58 \uc54a\ub2e4. \uc774\uc5d0 DBA\ub294 C \uac80\uc0ac\ub97c \uc6d0\ud558\ub294 \ud56d\ubaa9(SGA, Analyze, Extent, JOB\u2026\u2026)\ub4e4\uc5d0 \ub300\ud574 \uc870\uac74\uc744 \uc124\uc815\ud55c\ub2e4. \ud574\ub2f9 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \ub0b4\uc6a9\uc5d0 \ub300\ud574 \uc790\ub3d9\uc73c\ub85c \uccb4\ud06c\ud574 \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc900\ub2e4\uba74 DBA\uc758 \uc5ed\ud560\uc740 \uadf8\ub9cc\ud07c \uc904\uc5b4\ub4e4 \uac83\uc774\uba70, \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc9c0\uc7a5\uc744 \ucd08\ub798\ud560 \uc218 \uc788\ub294 \uc6d0\uc778\ub4e4\uc744 \ubbf8\uc5f0\uc5d0 \ubc29\uc9c0\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\u25c6 \ud5ec\uc4f0 \uccb4\ud06c\uc758 \uc8fc\uc694 \uae30\ub2a5<\/p>\n

\u2460 \uc804\uccb4\uc758 \uc544\uc774\ud15c\uc744 \uc218\ud589\ud558\uac70\ub098 \ud2b9\uc815\ud55c \uc544\uc774\ud15c\ub9cc \uc120\ud0dd\ud574 \uccb4\ud06c\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\u2461 \ubd84\uc11d \uacb0\uacfc\uc5d0 \ub300\ud55c \ub9ac\ud3ec\ud2b8<\/p>\n

\u2462 SGA \uc0ac\uc6a9 \ub0b4\uc5ed<\/p>\n

\u2463 Unanalyzed Segments(\ud14c\uc774\ube14, \uc778\ub371\uc2a4, \ud30c\ud2f0\uc158 \ud14c\uc774\ube14\/\uc778\ub371\uc2a4)<\/p>\n

\u2464 100\uac1c\uac00 \ub118\ub294 Extent\ub97c \uc18c\uc720\ud55c \uc138\uadf8\uba3c\ud2b8<\/p>\n

\u2465 JOB\uc758 Broken, Sysdate\ubcf4\ub2e4 \uc774\uc804\uc758 JOB, Long running JOB \ub4f1<\/p>\n

<\ud654\uba74 3>\uc740 \ud1a0\ub4dc\uc758 \ud5ec\uc4f0 \uccb4\ud06c \uae30\ub2a5\uc744 \uc218\ud589\ud55c \ud654\uba74\uc774\ub2e4. \uc5ec\uae30\uc5d0\ub294 Checks and Options, Other Settings, Report Output \ub4f1 3\uac00\uc9c0 \ud0ed\uc73c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub294\ub370, Check and Options \ud0ed\uc5d0\uc11c \uc774\ubbf8 \uc9c0\uc815\ub418\uc5b4 \uc788\ub294 \ub2e4\uc591\ud55c \uc778\uc2a4\ud134\uc2a4 \uccb4\ud06c \uc0ac\ud56d \uc911\uc5d0\uc11c \uc6d0\ud558\ub294 \ud56d\ubaa9\uc744 \uc9c0\uc815\ud558\uace0 \uadf8\uc5d0 \ub530\ub978 \uac12\uc744 \uc785\ub825\ud558\uace0 \uc2e4\ud589\ud558\uba74 Report Output \ud0ed\uc5d0 Health Check\ub97c \uc218\ud589\ud55c \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n

<\ud654\uba74 3> \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud5ec\uc4f0 \uccb4\ud06c<\/p>\n

<\/p>\n

\uc778\uc2a4\ud134\uc2a4 \ub9e4\ub2c8\uc800<\/p>\n

\uc774 \uae30\ub2a5\uc740 \ud604\uc7ac \ub3d9\uc791 \uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\uc2a4\ud134\uc2a4\uc5d0 \ucee4\ub125\uc158\uc744 \uc790\ub3d9\uc73c\ub85c \uc218\ud589\ud574 Startup \uc0c1\ud0dc\uc778\uc9c0 Shutdown \uc0c1\ud0dc\uc778\uc9c0\ub97c \uccb4\ud06c\ud560 \uc218 \uc788\uc73c\uba70, \ud1a0\ub4dc\uc5d0\uc11c \uc9c1\uc811 Startup\/Shutdown \uba85\ub839\uc744 \uc218\ud589\ud558\uac70\ub098 Init \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c\uc744 \ube4c\ub529(building)\ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n

<\ud654\uba74 4> \uc778\uc2a4\ud134\uc2a4 \uba54\ub2c8\uc800<\/p>\n

<\/p>\n

DB\uc758 \ubb38\uc81c\uc810\uc744 \ubd84\uc11d\ud558\ub77c!<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubb38\uc81c\uc810\uc744 \ud30c\uc545\ud588\uc73c\uba74 \uacfc\uc5f0 \uc774 \ubb38\uc81c\uc810\uc758 \uc6d0\uc778\uc740 \ubb34\uc5c7\uc774\uba70, \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc5d0\uc11c \ubcd1\ubaa9\ud604\uc0c1(Bottleneck)\uc774 \ubc1c\uc0dd\ud558\ub294 \uc601\uc5ed\uc740 \uc5b4\ub514\uc778\uc9c0\uc5d0 \ub300\ud574 \uc790\uc138\ud558\uac8c \ubd84\uc11d\ud574\uc57c \ud55c\ub2e4.<\/p>\n

\ubd84\uc11d \uc791\uc5c5\uc740 \uc2dc\uc791\ud574\uc57c \ud558\ub294 \ud3ec\uc778\ud2b8\uac00 \uc911\uc694\ud558\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud604\uc7ac \uc2ec\uac01\ud558\uac8c \uc131\ub2a5\uc774 \ub2e4\uc6b4\ub418\ub294 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud558\uace0 \uc788\ub2e4\uba74 \uacfc\uc5f0 \uc774 \ubb38\uc81c\uac00 \uba54\ubaa8\ub9ac \ucabd\uc778\uc9c0, I\/O \ucabd\uc778\uc9c0, I\/O\ub77c\uba74 \ub370\uc774\ud130\ud30c\uc77c\uc778\uc9c0 \ub9ac\ub450 \ub85c\uadf8 \ud30c\uc77c\uc778\uc9c0\ub97c \ud30c\uc545\ud574\uc57c \ud55c\ub2e4. \uba54\ubaa8\ub9ac\ub77c\uba74 Shared Pool\uc778\uc9c0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc84\ud37c \uce90\uc2dc\uc778\uc9c0 \ub9ac\ub450 \ub85c\uadf8\uc778\uc9c0 \ud310\ub2e8\ud574\uc57c \ud55c\ub2e4. DBA \uc785\uc7a5\uc5d0\uc11c \ud2b9\uc815 \ubb38\uc81c\uc810\uc774 \ubc1c\uc0dd\ud55c \uc601\uc5ed\uc744 \uc54c \uc218 \uc788\ub2e4\uba74 \uadf8 \ubd80\ubd84\uc744 \uc9d1\uc911\uc801\uc73c\ub85c \ubd84\uc11d\ud574 \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud574\uc57c \ud558\ub294\ub370, \ud1a0\ub4dc\ub294 \uc774\ub7ec\ud55c \ubd84\uc11d\uc744 \uc27d\uac8c \ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \uae30\ub2a5\ub4e4\uc744 \uac16\uace0 \uc788\ub2e4.<\/p>\n

Database Probe<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc131\uc740 \ud06c\uac8c \uba54\ubaa8\ub9ac(SGA), \ud504\ub85c\uc138\uc2a4, \ub370\uc774\ud130\ud30c\uc77c(Online Redo Logfile, User Datafile)\ub85c \uad6c\uc131\ub418\uba70 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uc640 \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uc5d0 \uc758\ud574 \uc790\ub3d9\uc801\uc73c\ub85c \uc6b4\uc601\ub41c\ub2e4. Database Probe\ub294 <\ud654\uba74 5>\uc640 \uac19\uc774 3\uac1c\uc758 \uadf8\ub8f9\uc73c\ub85c \ub098\ub258\uc5b4 \uac01 \uadf8\ub8f9\ubcc4\ub85c \uc911\uc694\ud55c \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\uac8c \ub41c\ub2e4.<\/p>\n

<\ud654\uba74 5> Database Probe<\/p>\n

<\/p>\n

\uba3c\uc800 \ud504\ub85c\uc138\uc2a4 \ubd80\ubd84\uc740 \uc804\uc6a9 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uc640 \uacf5\uc720 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uc758 \uc218 \ubc0f \ubcd1\ub82c \ucc98\ub9ac \ub0b4\uc6a9\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 \uc0ac\uc6a9\ud558\ub294 \ub3c5\uc810 \uba54\ubaa8\ub9ac\uc778 PGA \uba54\ubaa8\ub9ac\uc758 \uc0ac\uc6a9 \ud604\ud669\uc758 \uad00\uacc4\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uc788\uc73c\uba70, \uba54\ubaa8\ub9ac(SGA) \ubd80\ubd84\uc740 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uac00 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \ubc84\ud37c \uce90\uc2dc, SQL\uacfc PL\/SQL \ubb38\uc7a5\uc744 \uc800\uc7a5\ud558\uae30 \uc704\ud55c Shared Pool, \uacf5\uc720 \uc11c\ubc84\uc758 \uc138\uc158 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 Large Pool, \ub370\uc774\ud130 \ube14\ub7ed\uc758 \ubcc0\uacbd\ub41c \uc815\ubcf4(Before\/After)\ub97c \uc800\uc7a5\ud558\ub294 \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c, \uc790\ubc14 \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9\ud558\ub294 \uc601\uc5ed\uc758 Java Pool\uc758 \uc0ac\uc6a9\ub960\uc744 \ubcf4\uc5ec\uc8fc\uba70, \ub9c8\uc9c0\ub9c9\uc73c\ub85c \ub370\uc774\ud130\ud30c\uc77c \ubd80\ubd84\uc740 \ud30c\uc77c\uc758 \ud06c\uae30\uc640 \ud604\uc7ac\uae4c\uc9c0\uc758 \uc0ac\uc6a9\ub960\uc744 \uadf8\ub798\ud53d\ud558\uac8c \ucc98\ub9ac\ud558\uace0 \uc788\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc804\ubc18\uc801\uc778 \ub9ac\uc18c\uc2a4\ub97c \uc5bc\ub9c8\ub098 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \ud310\ub2e8\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ucd08\uae30 \ud30c\ub77c\ubbf8\ud130 \ubc0f \ub370\uc774\ud130\ud30c\uc77c\uc758 \ud06c\uae30 \ub610\ub294 \ub9ac\ub450 \ub85c\uadf8 \ud30c\uc77c\uc758 \ud06c\uae30 \ubc0f \uac1c\uc218 \ub4f1\uc744 \uc870\uc815\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n

\u25c6 Database Probe\uc758 \uc8fc\uc694 \uae30\ub2a5<\/p>\n

\u2460 SGA \uac01 \uc601\uc5ed\uc758 Hit Ratio \ubc0f \uc0ac\uc6a9\ub960 \ubc0f Wait\/Retry \uc815\ubcf4<\/p>\n

\u2461 \uc804\uc6a9 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4 \ubc0f \uacf5\uc720 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uc758 \uc218 \ubc0f PGA \uc815\ubcf4<\/p>\n

\u2462 \ub370\uc774\ud130\ud30c\uc77c\uc758 \uc804\uccb4 \ud06c\uae30 \ubc0f \uc0ac\uc6a9\ub960<\/p>\n

Top Session Finder<\/p>\n

\ud604\uc7ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ud2b9\uc815 \ub9ac\uc18c\uc2a4\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uc624\ub77c\ud074 \uc138\uc158\ub4e4\uc744 \ubc1c\ucdcc\ud574 \ud0d1 \ub9ac\uc2a4\ud2b8(Top List)\ub85c \ubcf4\uc5ec\uc900\ub2e4. \uc55e\uc758 Database Probe\ub97c \uc774\uc6a9\ud574 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uce21\uba74\uc744 \ubd84\uc11d\ud588\uc73c\uba74, \uadf8 \ub0b4\ubd80\uc5d0\uc11c \uc791\uc5c5 \uc911\uc778 \uc138\uc158\ub4e4\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4\ub97c \ubd84\uc11d\ud574\uc57c \ud560 \uac83\uc774\ub2e4. \ud558\uc9c0\ub9cc \uadf8 \ub9ce\uc740 \uc138\uc158\ub4e4\uc744 \uc77c\uc77c\uc774 \ubd84\uc11d\ud558\uae30\ub780 \uc5ec\uac04 \ud798\ub4e0 \uc77c\uc774 \uc544\ub2c8\ub2e4. \uadf8 \uc911\uc5d0\uc11c \uc2dc\uc2a4\ud15c\uc758 \ub9ac\uc18c\uc2a4\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \uc138\uc158\uc774 \ubb38\uc81c\uc810\uc744 \uac16\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0, \uadf8\uc5d0 \ub530\ub978 \uc774\ubca4\ud2b8 \uc815\ubcf4\ub97c \ud1a0\ub300\ub85c \ud0d1 \uc138\uc158\uc744 \ubc1c\ucdcc\ud55c\ub2e4. \uc608\ub97c \ub4e4\uc5b4 CPU\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \ud0d1 \uc138\uc158, I\/O\ub97c \ub9ce\uc774 \ubc1c\uc0dd\uc2dc\ud0a4\ub294 \ud0d1 \uc138\uc158\ucc98\ub7fc DBA\uac00 \uc6d0\ud558\ub294 \uc2dc\uc2a4\ud15c \ub9ac\uc18c\uc2a4 \uce21\uba74\uc744 \uac15\uc870\ud55c \uae30\ub2a5\uc774\ub77c\uace0 \ud560 \uc218 \uc788\ub2e4. <\ud654\uba74 6>\uc5d0\uc11c\ub294 \uc138\uc158\ub4e4 \uc911\uc5d0\uc11c \u2018session logical reads\u2019, \uc989 \ub17c\ub9ac\uc801\uc778 \uc77d\uae30\uac00 \ud070 \uc138\uc158\ubd80\ud130 \ub0b4\ub9bc\ucc28\uc21c\uc73c\ub85c \uc815\ub82c\ub41c \uc815\ubcf4\ub97c Dataset \ud615\ud0dc\ub85c \uc81c\uacf5\ud558\uace0 \uc788\ub2e4.<\/p>\n

<\ud654\uba74 6> Top Session Finder<\/p>\n

<\/p>\n

\u25c6 Top Session Finder\uc758 \uc8fc\uc694 \uae30\ub2a5<\/p>\n

\u2460 CPU, \uba54\ubaa8\ub9ac, \ucee4\uc11c(CURSORS) \ub4f1\uacfc \uac19\uc740 \uc790\uc6d0 \uadf8\ub8f9\ubcc4\ub85c \ubb38\uc81c \uc138\uc158\uc744 \uac80\uc0c9<\/p>\n

\u2461 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc138\uc158 \uc815\ubcf4\uc758 \uacb0\uacfc\ub97c Dataset \ud615\ud0dc\ub098 Pie Chart \ud615\uc2dd\uc73c\ub85c \uc81c\uacf5<\/p>\n

\uc138\uc158 \ube0c\ub77c\uc6b0\uc800<\/p>\n

\uc138\uc158 \ube0c\ub77c\uc6b0\uc800 \uae30\ub2a5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d \uc911\uc778 \ubaa8\ub4e0 \uc138\uc158\ub4e4\uc5d0 \ub300\ud574 \ucd1d\uad04\uc801\uc73c\ub85c \uc138\uc158 \uc561\ud2f0\ube44\ud2f0(Session Activity)\ub97c \ubd84\uc11d\ud558\uae30 \uc704\ud574 \uc81c\uacf5\ub41c \uae30\ub2a5\uc774\ub2e4. <\ud654\uba74 7>\uc740 \ud2b9\uc815 \uc138\uc158\uc758 Wait Event\uc5d0 \ub300\ud55c \uc0c1\uc138 \uc815\ubcf4\ub97c \u2018Current Waits\u2019\uc640 \u2018Total Waits\u2019\ub85c \ubd84\ub9ac\ud574 \uc81c\uacf5\ud558\uace0 \uc788\ub2e4. \ud2b9\uc815 \uc138\uc158\uc744 \uc120\ud0dd\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0c1\uc138\uc815\ubcf4\ub97c \ub3d9\uc801\uc73c\ub85c \ucd94\ucd9c\ud560 \uc218 \uc788\ub2e4.<\/p>\n

<\ud654\uba74 7> \uc138\uc158\ube0c\ub77c\uc6b0\uc800<\/p>\n

<\/p>\n

– \uc138\uc158 : \uc120\ud0dd\ud55c \uc138\uc158\uc758 ID, \ud504\ub85c\uadf8\ub7a8, \ubaa8\ub4c8, Machine, OS \uc720\uc800, DB \uc720\uc800 \ub4f1\uc758 \uc815\ubcf4\ub97c \uc81c\uacf5
<\/p>\n

– \ud504\ub85c\uc138\uc2a4 : <\/b>\uc120\ud0dd\ud55c \uc138\uc158\uc758 \ud504\ub85c\uc138\uc2a4 \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– I\/O :<\/b> \uc120\ud0dd\ud55c \uc138\uc158\uc774 \ubc1c\uc0dd\uc2dc\ud0a8 I\/O \uc815\ubcf4\uc778 \uc77d\uae30\/\uc4f0\uae30 \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Waits :<\/b> \uc120\ud0dd\ud55c \uc138\uc158\uc5d0\uc11c \ubc1c\uc0dd\ud55c Wait Event \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Current Statement : <\/b>\uc120\ud0dd\ud55c \uc138\uc158\uc5d0\uc11c \uc218\ud589 \uc911\uc778 SQL \ubb38\uc7a5 \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Open Cursors :<\/b> \uc120\ud0dd\ud55c \uc138\uc158\uc774 \uc624\ud508\ud55c \ucee4\uc11c \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Access : <\/b>\uc120\ud0dd\ud55c \uc138\uc158\uc774 \uc561\uc138\uc2a4\ud55c \uac1d\uccb4 \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Locks :<\/b> \uc138\uc158 \uc7a0\uae08 \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– RBS Usage :<\/b> \uc120\ud0dd\ud55c \uc138\uc158\uc774 \uc0ac\uc6a9\ud55c \ub864\ubc31 \uc138\uadf8\uba3c\ud2b8(Rollback Segment) \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Long Ops :<\/b> \uc120\ud0dd\ud55c \uc138\uc158\uc774 \ubc30\uce58(Batch)\uc131 \uc791\uc5c5\uc744 \uc218\ud589\ud588\uc744 \uacbd\uc6b0 \ud604\uc7ac\uae4c\uc9c0 \uc9c4\ud589\ub41c \uc0c1\ud669\uc5d0 \ub300\ud55c \uc815\ubcf4 \uc81c\uacf5
<\/p>\n

– Statistics :<\/b> \uc120\ud0dd\ud55c \uc138\uc158\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc815\ubcf4 \uc81c\uacf5 <\/p>\n

OS \uc720\ud2f8\ub9ac\ud2f0<\/b> <\/p>\n

\uc774 \uae30\ub2a5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uce21\uba74\uc774 \uc544\ub2cc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub3d9\uc791 \uc911\uc778 \uc2dc\uc2a4\ud15c(OS) \ubd80\ubd84\uc758 \uc815\ubcf4\ub97c \ubd84\uc11d\ud558\uace0\uc790 \ud560 \uacbd\uc6b0 \uc0ac\uc6a9\ud55c\ub2e4. \uc720\ub2c9\uc2a4\ub098 \uc708\ub3c4\uc6b0 \uacc4\uc5f4\uc758 OS\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ub610\ub294 \ud574\ub2f9 OS\uc5d0 \ud574\ub2f9\ub418\ub294 \uc815\ubcf4\ub97c \ubd84\uc11d\ud558\uace0\uc790 \ud560 \uacbd\uc6b0 \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. <\ud654\uba74 8>\uc740 CPU\uc758 \uc0ac\uc6a9\ub960\uc744 \uc2dc\uc2a4\ud15c, \uc0ac\uc6a9\uc790\ub97c \uad6c\ubd84\ud574 \uc0ac\uc6a9\ub418\uace0 \uc788\ub294 \uc815\ubcf4\uc640 \ud504\ub85c\uc138\uc2a4 \uc815\ubcf4 \ubc0f \ub514\uc2a4\ud06c I\/O\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uadf8\ub798\ud504\ub85c \uc81c\uacf5\ud558\uace0 \uc788\uc5b4, \uc2dc\uc2a4\ud15c\uc758 \uc804\ubc18\uc801\uc778 \uc790\uc6d0 \uc0ac\uc6a9\uc728\uc744 \ub098\ud0c0\ub0b4\uace0 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 8> OS \uc720\ud2f8\ub9ac\ud2f0 \uba54\ub274 <\/p>\n

<\/p>\n

<\ud654\uba74 9> \uc720\ub2c9\uc2a4 \ubaa8\ub2c8\ud130 <\/p>\n

<\/p>\n

DB\uc0c1\uc758 \ubb38\uc81c\uc810\uc744 \uc5b4\ub5bb\uac8c \ud574\uacb0\ud560 \uac83\uc778\uac00? <\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubb38\uc81c\uc810\uc744 \uac10\uc9c0(detect)\ud558\uace0 \ubd84\uc11d(diagnostic)\ud588\uc73c\uba74, \uadf8\uc5d0 \ub530\ub978 \ud589\ub3d9\uc744 \ucde8\ud574\uc57c \ud55c\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc81c\uc2dc\ud558\ub294 \ud574\uacb0\ubc29\uc548\uc740 \uc2dc\uc2a4\ud15c \ud29c\ub2dd, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud29c\ub2dd, \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud29c\ub2dd, SQL Statement \ud29c\ub2dd\uc73c\ub85c \uad6c\ubd84\ud560 \uc218 \uc788\ub294 \ub370, \ud1a0\ub4dc\uc5d0\uc11c\ub294 \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \uae30\ub2a5\uc774 \uc874\uc7ac\ud55c\ub2e4. <\/p>\n

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc640 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub9f5<\/p>\n

\uc774\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub17c\ub9ac\uc801 \uad6c\uc870\ub97c \uc774\ub8e8\ub294 \uac00\uc7a5 \ud575\uc2ec\uc801\uc778 \uc694\uc18c\uc774\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\ub294 \ubb3c\ub9ac\uc801\uc778 \ub370\uc774\ud130\ud30c\uc77c\uacfc \uc5f0\uacb0\ub418\uc5b4 \uc788\uc73c\uba70, \uadf8 \uc548\uc5d0 \uc138\uadf8\uba3c\ud2b8, \uc775\uc2a4\ud134\ud2b8(Extent), \ube14\ub7ed\uc774\ub77c\ub294 \uad6c\uc870\uac00 \uc874\uc7ac\ud558\uace0 \uc788\ub2e4. \ub9cc\uc57d \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uacf5\uac04\uc774 \ubd80\uc871\ud558\uac70\ub098, \ub370\uc774\ud130\ud30c\uc77c\uc5d0 Fragmentation\uc774 \ubc1c\uc0dd\ud574 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud55c \uacbd\uc6b0\ub77c\uba74 \ud574\ub2f9 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uacf5\uac04\uc744 \ub298\ub824\uc8fc\ub294 \uc791\uc5c5\uacfc \uadf8 \uc548\uc5d0 \uc874\uc7ac\ud558\ub294 Fragmentation\uc744 Coalesce\ud558\ub294 \uc791\uc5c5\uc744 \uc218\ud589\ud574 \ub2e4\uc2dc \uc7ac\uad6c\uc131\ud558\ub294 \ubb38\uc81c\ub97c \uc0dd\uac01\ud574\uc57c \ud560 \uac83\uc774\ub2e4. \ub610\ud55c \uc774\ub85c \uc778\ud574 I\/O Wait\uac00 \ubc1c\uc0dd\ud574 \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c0\ub294 \uc6d0\uc778\uc774 \ub41c\ub2e4\uba74 \ud574\ub2f9 \ub370\uc774\ud130\ud30c\uc77c\ub3c4 \ub2e4\uc2dc \uc7ac\uad6c\uc131\ud558\uac70\ub098 \uc7ac\uad6c\ucd95\ud558\ub294 \uc808\ucc28\ub97c \uc218\ud589\ud574\uc57c \ud55c\ub2e4. \uc774\ub7ec\ud55c \uacfc\uc815\uc744 \uc190\uc27d\uac8c \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \uae30\ub2a5\uc774 \ubc14\ub85c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uae30\ub2a5\uc774\ub2e4. <\/p>\n

\ud1a0\ub4dc\uc5d0\uc11c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc640 \ub370\uc774\ud130\ud30c\uc77c\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\uc73c\uba70, \ud504\ub9ac \uc2a4\ud398\uc774\uc2a4(Free Space)\uc640 \ud574\ub2f9 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud558\ub294 \uac1d\uccb4 \uc815\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\/p>\n

\uadf8\ub9ac\uace0 \ub4a4\uc5d0 \uc788\ub294 Space History\uc640 I\/O History \ud0ed\uc5d0\uc11c\ub294 \ud2b9\uc815 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub098 \ub370\uc774\ud130\ud30c\uc77c\uc5d0 \ub300\ud55c Capacity Plan \uc815\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\ud654\uba74 10>\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uac01 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574 \ud560\ub2f9\ub41c \ud06c\uae30\uc640 \uac00\uc7a5 \ud070 \uc5f0\uc18d\ub41c \uacf5\uac04 \ubc0f \ud504\ub9ac \uc2a4\ud398\uc774\uc2a4\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uc788\ub2e4. \ub9cc\uc57d\uc5d0 \ud2b9\uc815 \uc138\uadf8\uba3c\ud2b8\uc758 \ud06c\uae30\uac00 \ubd80\uc871\ud574 \ud655\uc7a5\ub420 \ub54c \u2018MAX Mb\u2019\uc758 \uac12\ubcf4\ub2e4 \ud06c\ub2e4\uba74 \ud655\uc7a5\ud558\uc9c0 \ubabb\ud558\uace0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4. \ub530\ub77c\uc11c DBA\ub294 \uc774\ub7ec\ud55c \uc815\ubcf4\ub85c \uac01 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \uc18d\ud55c \uc624\ube0c\uc81d\ud2b8 \uc911 MAX \uac12\ubcf4\ub2e4 \ud070 \ud14c\uc774\ube14\uc774\ub098 \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud55c\ub2e4\uba74 \ud574\ub2f9 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ud30c\uc77c\uc744 \ucd94\uac00\ud55c\ub2e4\uac70\ub098 \ub2e4\uc74c \uc775\uc2a4\ud134\ud2b8\uc758 \ud06c\uae30\ub97c \uc904\uc774\uae30 \uc704\ud574 \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4\uc758 NEXT \uc635\uc158\uc744 \ubcc0\uacbd\ud574\uc57c \ud560 \uac83\uc774\ub2e4. <\/p>\n

<\ud654\uba74 10> \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc608 <\/p>\n

<\/p>\n

\ub610\ud55c \ud2b9\uc815 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \ubb3c\ub9ac\uc801\uc778 \uad6c\uc870 \uc911\uc5d0\uc11c \uac00\uc7a5 \uc791\uc740 \ub2e8\uc704\uc778 \ube14\ub7ed\ub4e4\uc744 \uadf8\ub798\ud53d\ud558\uac8c \ubcf4\uc5ec\uc918 \ud574\ub2f9 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uac1d\uccb4\uac00 \ucc28\uc9c0\ud558\uace0 \uc788\ub294 \ube14\ub7ed\uc758 \uac2f\uc218\ub098 \uc138\uadf8\uba3c\ud2b8 \uc815\ubcf4\ub97c \uc790\uc138\ud558\uac8c \ud655\uc778\ud560 \uc218\ub3c4 \uc788\uc73c\uba70, \ub370\uc774\ud130\ud30c\uc77c\uc5d0 \uc874\uc7ac\ud558\ub294 Fragmentation\ub3c4 \ubd84\uc11d\ud574 Coalesce \uacfc\uc815\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294\ub370, \uc774 \uae30\ub2a5\uc740 <\ud654\uba74 11>\uc758 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub9f5\uc744 \ud65c\uc6a9\ud574 \uc218\ud589\ud560 \uc218 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 11> \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc608 <\/p>\n

<\/p>\n

\u3000\u3000\u3000\u3000 \ucee8\ud2b8\ub864 \ud30c\uc77c\uacfc \ub9ac\ub450 \ub85c\uadf8 \ub9e4\ub2c8\uc800<\/b> <\/p>\n

\ubb3c\ub9ac\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\uc778 \ucee8\ud2b8\ub864 \ud30c\uc77c(Control File)\uacfc \ub9ac\ub450 \ub85c\uadf8 \ud30c\uc77c(Redo Log File)\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \ub85c\uadf8 \uc2a4\uc704\uce58(Log Switch), \ub9ac\ub450 \ub85c\uadf8 \ud30c\uc77c \ubcc0\uacbd \uc791\uc5c5, \uc544\uce74\uc774\ube0c \uc2a4\ud0c0\ud2b8\/\uc2a4\ud1b1(Archive Start\/Stop)\uacfc \uac19\uc740 \ud2b9\uc815 \uc791\uc5c5\uc744 \uc9c1\uc811 \uc218\ud589\ud560 \uc218 \uc788\ub2e4. \ucee8\ud2b8\ub864 \ud30c\uc77c\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubb3c\ub9ac\uc801\uc778 \uad6c\uc870\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uace0 \uc788\uc73c\uba70 \uac01 \ud0c0\uc785\ubcc4\ub85c \ub808\ucf54\ub4dc \uc138\uc158(Record Section)\uc744 \uc0ac\uc6a9\ud558\uac8c \ub41c\ub2e4. <\ud654\uba74 12>\uc5d0\uc11c\uc758 \ucee8\ud2b8\ub864 \ud30c\uc77c\uc758 \uc0c1\uc138\ub0b4\uc6a9\uc744 \ubcf4\uba74 \uac01 \uc138\uc158(\u201cREDO LOG\u201d, \u201cDATAFILE\u201d\u2026)\ubcc4\ub85c \ucd5c\ub300 \ub808\ucf54\ub4dc\ub97c \uac16\uace0, \ub610\ud55c \uc0ac\uc6a9\ub7c9\uc744 \ud45c\uc2dc\ud558\ub294\ub370, \ub9cc\uc57d \uac01 \uc138\uc158\uc758 \ud1a0\ud0c8 \ub808\ucf54\ub4dc\ub4e4\uacfc \uc0ac\uc6a9\ub41c \ub808\ucf54\ub4dc\uac00 \ub3d9\uc77c\ud558\uac8c \ub418\uba74 \ub354 \uc774\uc0c1 \ud574\ub2f9 \uc138\uc158\uc5d0 \ub300\ud55c \uc790\uc6d0 \ud560\ub2f9\uc744 \ud560 \uc218 \uc5c6\uac8c \ub418\ubbc0\ub85c \ucee8\ud2b8\ub864 \ud30c\uc77c\uc744 \uc7ac\uc0dd\uc131\ud574\uc57c \ub41c\ub2e4. \uadf8\ub9ac\uace0 \uc774\ub7ec\ud55c \uc815\ubcf4\ub97c \ubbf8\ub9ac \ud655\uc778\ud574 \ub300\ucc98\ud560 \uc218 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 12> \ucee8\ud2b8\ub864 \ud30c\uc77c \uad00\ub9ac
<\/p>\n

<\ud654\uba74 13> \uce78\ud2b8\ub864 \ud30c\uc77c\uacfc \ub9ac\ub450 \ub85c\uadf8 \ub9e4\ub2c8\uc800
<\/p>\n

Log Switch Frequency Map<\/b>
<\ud654\uba74 14>\ub294 \ud558\ub8e8\ub97c 1\uc2dc\uac04 \uadf8\ub8f9\uc73c\ub85c \uad6c\ubd84\ud574 \uac01 \uc2dc\uac04\ub300\ubcc4\ub85c \ub85c\uadf8 \uc2a4\uc704\uce58\uc758 \ubc1c\uc0dd \uc815\ub3c4\ub97c \ub098\ud0c0\ub0b4\uc5b4 \ud2b8\ub79c\uc7ad\uc158 \uc591\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc73c\uba70, \ub610\ud55c \ud558\ub8e8 \uc911\uc5d0 \uac00\uc7a5 \ud2b8\ub79c\uc7ad\uc158\uc774 \ub9ce\uc740 \uc2dc\uac04\ub300\ub97c \ud30c\uc545\ud574 \uadf8 \uc2dc\uac04\ub300\uc5d0 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uc791\uc5c5(Batch Job) \ub4f1\uc744 \ub2e4\ub978 \uc2dc\uac04\ub300\ub85c \ubcc0\uacbd\ud574 \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\uace0 \uc788\ub2e4. Log Switch Frequency Map \uae30\ub2a5\uc740 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \ub85c\uadf8 \uc2a4\uc704\uce58\uc758 \ud68c\uc218\ub97c \uccb4\ud06c\ud574 \ubcf4\uc5ec\uc900\ub2e4. <\/p>\n

<\ud654\uba74 14> Log Switch Frequency Map
<\/p>\n

\uc2dc\uac04\ub300\ubcc4\ub85c \uba87 \ubc88\uc758 \ub85c\uadf8 \uc2a4\uc704\uce58\uac00 \ubc1c\uc0dd\ud588\ub294\uc9c0 \ud30c\uc545\ud560 \uc218 \uc788\uc73c\uba70 \uac00\uc7a5 \ub9ce\uc740 \ub85c\uadf8 \uc2a4\uc704\uce58\uac00 \ubc1c\uc0dd\ud55c \uc2dc\uac04\uc774 \uc5b8\uc81c\uc778\uc9c0\ub97c \ud655\uc778\ud574 DBA\ub85c \ud558\uc5ec\uae08 \ub85c\uadf8 \ud30c\uc77c\uc758 \uc7ac\uad6c\uc131\uacfc \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c\uc758 \ud06c\uae30\uc5d0 \ub300\ud55c \uc5b4\ub4dc\ubc14\uc774\uc2a4\ub97c \ubc1b\uc744 \uc218 \uc788\ub3c4\ub85d \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uace0 \uc788\uc73c\uba70, \uc774\ub97c \ud1b5\ud574 \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c \uccb4\ud06c\ud3ec\uc778\ud2b8\uc758 \ubc1c\uc0dd \ube48\ub3c4\ub97c \uc608\uce21\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc900\ub2e4. DBA\ub294 \uc774 \uc815\ubcf4\ub97c \ud1a0\ub300\ub85c SGA \uba54\ubaa8\ub9ac\uc758 \ucd5c\uc801\ud654 \uc0c1\ud0dc\ub97c \uc810\uac80\ud560 \uc218 \uc788\ub2e4. <\/p>\n

Rebuild Objects<\/b>
\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud55c \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub2e4 \ubcf4\uba74 \uadf8 \uc548\uc5d0 \uc874\uc7ac\ud558\ub294 \ud2b9\uc815 \uac1d\uccb4\uc5d0 \ub300\ud574 \ub2e4\uc2dc \uc7ac\uad6c\uc131\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub808\ubca8\uc5d0\uc11c\ub9cc \ubb38\uc81c\uac00 \ud574\uacb0\ub418\uba74 \uac00\uc7a5 \uc88b\uaca0\uc9c0\ub9cc \uc2e4\uc81c\ub85c\ub294 \ub370\uc774\ud130\uac00 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc774\ub098 \uc778\ub371\uc2a4 \ucabd\uc5d0 \ub354 \ubb34\uac8c\ub97c \ub458 \uc218\ubc16\uc5d0 \uc5c6\uac8c \ub41c\ub2e4. \uc774 \uae30\ub2a5\uc744 \uc774\uc6a9\ud574 \ud2b9\uc815 \ud14c\uc774\ube14\uc774\ub098 \uc778\ub371\uc2a4 \ub610\ub294 \ud2b9\uc815 \uc720\uc800, \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ud574\ub2f9\ud558\ub294 \uac1d\uccb4\uc5d0 \ub300\ud574 \uc77c\uad04\uc801\uc73c\ub85c \ub610\ub294 \uac1c\ubcc4\uc801\uc73c\ub85c Rebuild \uacfc\uc815\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\ub2e4. <\/p>\n

\u3000\u3000 Repair Chained Rows<\/b>
\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 block_size\uac00 \uc801\uac70\ub098 \ud2b9\uc815 \ud14c\uc774\ube14\uc758 Row\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube14\ub7ed\uc758 \ud06c\uae30\ubcf4\ub2e4 \ud070 \uacbd\uc6b0\uc5d0 UPDATE \ubb38\uc7a5\uc774 \ubc1c\uc0dd\ud558\ub294 \ud14c\uc774\ube14\uc5d0 \uc885\uc885 \ubc1c\uc0dd\ub418\ub294 Chaining\uc774\ub098 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc774 \uc77c\uc5b4\ub098\uac8c \ub418\ub294\ub370, \uc774\ub807\uac8c \ud558\ub098\uc758 Row\uac00 \uc5ec\ub7ec \ube14\ub7ed\uc5d0 \uac78\uccd0 \uc788\uc73c\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c0\uae30 \ub9c8\ub828\uc774\ub2e4. \uc774 \uae30\ub2a5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud2b9\uc815 \ud14c\uc774\ube14\uc5d0\uc11c Chaining\uc774\ub098 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc774 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 \ud574\ub2f9 \ud14c\uc774\ube14\uc744 \ubd84\uc11d\ud574 Chained Row\ub97c \ud574\uacb0\ud558\uace0\uc790 \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc774\ub2e4. <\ud654\uba74 15>\ub294 \u2018CHAIN_TEST\u2019 \ud14c\uc774\ube14\uc5d0 Chain\ub41c Row\uac00 \uc57d 3\ub9cc \uac74 \uc815\ub3c4\uac00 \ubc1c\uc0dd\ud55c \uac83\uc778\ub370, \ud654\uba74 \uc624\ub978\ucabd\uc5d0 \u2018Repair\u2019 \ubc84\ud2bc\uc744 \ub204\ub974\uba74 Chained Row\ub97c \uc81c\uac70\ud560 \uc218 \uc788\uac8c \ub41c\ub2e4. <\/p>\n

<\ud654\uba74 15> Repair Chanined Rows
<\/p>\n

Export\/Import Utility Wizard\uc640 SQL*Loader Wizard<\/b>
Export\/Import Utility Wizard\uc640 SQL*Loader Wizard\ub294 \uc624\ub77c\ud074\uc758 Export\/Import \uba85\ub839\uacfc SQL*Loader\ub97c Wizard \ub97c \ud1b5\ud574 \uc27d\uac8c \uad6c\ud604\ud560 \uc218 \uc788\ub3c4\ub85d \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc774\ub2e4. Export\/Import\ub97c \uc774\uc6a9\ud574 \uc77c\ubc18\uc801\uc73c\ub85c \ud574\ub2f9 \uac1d\uccb4\ub97c \uc7ac\uad6c\uc131\ud558\ub294 \uacfc\uc815\uc744 \uac70\uce58\uac8c \ub418\ub294\ub370 GUI \ud658\uacbd\uc5d0\uc11c \ub204\uad6c\ub098 \uc190\uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uc81c\uacf5\ud558\uace0 \uc788\uc73c\uba70, \ud14c\uc774\ube14, \uc720\uc800, \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub4dc\ub97c \ubaa8\ub450 \uc9c0\uc6d0\ud55c\ub2e4. \ub610\ud55c SQL*Loader\uc758 \ubaa8\ub4e0 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud574 \ucee8\ud2b8\ub864 \ud30c\uc77c\uc744 \uad6c\uc131\ud560 \uacbd\uc6b0 \uc774\ubbf8 \uc9c0\uc815\ub418\uc5b4 \uc788\ub294 \ub9ce\uc740 \uc635\uc158\ub4e4\uc744 \uac04\ub2e8\ud558\uac8c \uc124\uc815\ud560 \uc218 \uc788\ub2e4. <\/p>\n

Server Statistics<\/b>
\uc774 \uae30\ub2a5\uc740 \ud604\uc7ac \uc778\uc2a4\ud134\uc2a4\uc5d0 \ub300\ud574 \ud1b5\uacc4 \uc815\ubcf4\ub97c \ubd84\uc11d\ud574 \ubcf4\uc5ec\uc8fc\uba70, \uc778\uc2a4\ud134\uc2a4 \ub0b4\ubd80\uc5d0 \ubc1c\uc0dd\ud558\ub294 \ub2e4\uc591\ud55c \ud56d\ubaa9\ub4e4\uc744 DBA\uac00 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.
Analysis, Waits, Latched, Session, Instance Summary \ub4f1\uc758 5\uac00\uc9c0 \ud0ed\uc744 \ud1b5\ud574 \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c \ud30c\uc545\ud55c\ub2e4. \ub610\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud1b5\uacc4\uce58\uc758 \uac12\uc774 \uc5b4\ub5a0\ud55c\uc9c0\uc5d0 \ub300\ud574 \ubd84\uc11d\ud574 DBA\uc5d0\uac8c \uc81c\uc2dc\ud574 \uc900\ub2e4. \uc774\ub97c \ud1b5\ud574 \ud604\uc7ac \ud1b5\uacc4\uc815\ubcf4\uc758 \ubd80\uc815\ud655\ud55c \uac12\ub4e4\uc5d0 \ub300\ud55c \uc5b4\ub4dc\ubc14\uc774\uc2a4\ub97c \uc81c\uc2dc\ud574 DBA\ub85c \ud558\uc5ec\uae08 \ucd5c\uc801\uc758 \uc778\uc2a4\ud134\uc2a4 \uc0c1\ud0dc\ub97c \uc720\uc9c0\ud560 \uc218 \uc788\ub294 \ubc29\ud5a5\uc744 \uc81c\uc2dc\ud55c\ub2e4. DBA\ub294 <\ud654\uba74 16>\uc5d0\uc11c \ube68\uac04\uc0c9\uc73c\ub85c \ud45c\uc2dc\ub418\uc5b4 \uc788\ub294 \uac12\ub4e4\uc5d0 \ub300\ud574 \uccb4\ud06c\ud574 \uc778\uc2a4\ud134\uc2a4 \ud658\uacbd\uc744 \uc218\uc815\ud560 \uc218 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 16> Server Statistics, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub300\ud45c\uc801\uc778 \uc131\ub2a5 \uc9c0\uc218\ub4e4\uc758 \ud604\uc7ac \uac12
<\/p>\n

\uc774 \uc678\uc5d0 \ud1a0\ub4dc\uc5d0\uc11c \uc9c0\uc6d0\ub418\ub294 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4. <\/p>\n

\u25c6 Oracle Parameter and NLS Parameter :<\/b> Server Statistics \uae30\ub2a5\uc5d0\uc11c \uc81c\uc2dc\ud55c \ub0b4\uc6a9\uc744 \uae30\uc900\uc73c\ub85c \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\ub77c\ubbf8\ud130\ub97c \uc218\uc815\ud560 \uacbd\uc6b0, \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574 \uc27d\uac8c \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4. <\/p>\n

\u25c6 New Database Wizard : <\/b>\uc774 \uae30\ub2a5\uc740 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud574 Create Database \uba85\ub839\uc744 \uc218\ud589\ud558\ub3c4\ub85d \ud558\ub294 \uae30\ub2a5\uc774\ub2e4. DBA\uac00 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131(create)\ud558\uace0\uc790 \ud560 \uacbd\uc6b0 \uc27d\uac8c GUI \ud658\uacbd\uc5d0\uc11c \uc0dd\uc131\ud560 \uc218 \uc788\ub3c4\ub85d \ub3c4\uc640\uc8fc\ub294 \uc704\uc800\ub4dc \uae30\ub2a5\uc774\ub2e4. <\/p>\n

\u25c6 Compare Schema and Compare Database :<\/b> \uc11c\ub85c \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub07c\ub9ac \ube44\uad50\ub97c \ud558\uac70\ub098 \ud2b9\uc815 \uc2a4\ud0a4\ub9c8\ub4e4\ub07c\ub9ac\uc758 \ube44\uad50\ucc98\ub7fc DBA\uac00 \ud2b9\uc815 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc774\uc804\uacfc \uc774\ud6c4\uc5d0 \ub300\ud55c \ube44\uad50 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uacbd\uc6b0 \uc801\uc6a9\ud55c\ub2e4. <\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800 \uae30\ub2a5\uc774\ub780?<\/p>\n

\uc9c0\uae08\uae4c\uc9c0 DBA \uae30\ub2a5\uc5d0 \ub300\ud574 \uac01 \uae30\ub2a5\ubcc4\ub85c \uc18c\uac1c\ub97c \ud588\ub2e4. \ud558\uc9c0\ub9cc DBA\uac00 \uc774 \ubaa8\ub4e0 \uae30\ub2a5\ub4e4\uc744 \uc77c\uc77c\uc774 \ud558\ub098\uc529 \ud655\uc778\ud55c\ub2e4\uba74 \uc774\uac83 \ub610\ud55c \ub108\ubb34 \ubd88\ud3b8\ud560 \uac83\uc774\ub2e4.
\uc774\ub97c \uc704\ud574 \ud1a0\ub4dc\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\ub97c \uc704\ud574 \ud544\uc694\ud55c \ub0b4\uc6a9\ub4e4\uc744 \uc885\ud569\uc801\uc73c\ub85c \uad6c\uc131\ud574 \ud558\ub098\uc758 \ud654\uba74\uc5d0\uc11c \ud655\uc778\ud558\uace0 \uc124\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \ud1b5\ud569\uad00\ub9ac \uccb4\uc81c\ub85c \uad00\ub9ac\ud558\uace0 \uc788\ub2e4. \uc774 \uae30\ub2a5\uc774 \ubc14\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800(Database Browser)\uc774\ub2e4. <\ud654\uba74 17>\ucc98\ub7fc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800\ub294 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uae30\uc900\uc73c\ub85c \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \ud604\uc7ac \ub124\ud2b8\uc6cc\ud06c \uc0c1\uc5d0 \uc874\uc7ac\ud558\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud55c\ub208\uc5d0 \ud655\uc778\ud560 \uc218 \uc788\ub3c4\ub85d \uc911\uc559\uc9d1\uc911 \ubc29\uc2dd\uc744 \uc120\ud0dd\ud558\uace0 \uc788\ub2e4. DBA\uac00 A DB, B DB \ub4f1\uc744 \ubd84\uc0b0\ud574 \uad00\ub9ac\ud55c\ub2e4\uba74 \uc5c5\ubb34 \ud6a8\uc728\uc131\ub3c4 \ub5a8\uc5b4\uc9c8 \ubfd0\ub9cc \uc544\ub2c8\ub77c \uadf8\ub85c \uc778\ud574 \ubc1c\uc0dd\ud558\ub294 \uc2dc\uac04\uacfc \ub178\ub825\uc5d0 \ub300\ud55c \ube44\uc6a9\ub3c4 \ud55c\uc774 \uc5c6\uc744 \uac83\uc774\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800\ub294 \ub2e4\uc74c\uc758 \ub2e4\uc591\ud55c \ud0ed\uc744 \uac16\uace0 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 17> \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800
<\/p>\n

\u25c6 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800\uc758 \ub2e4\uc591\ud55c \ud0ed<\/b>
– \uc624\ubc84\ubdf0(Overview) :<\/b> SGA \ud06c\uae30, Shared Pool\uc758 \ud06c\uae30, Hit Ratio, Event Wait \uc815\ubcf4 \ud655\uc778
– \uc778\uc2a4\ud134\uc2a4 : <\/b>\uc778\uc2a4\ud134\uc2a4 \uc815\ubcf4 \ud655\uc778
– \ub370\uc774\ud130\ubca0\uc774\uc2a4 : <\/b>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc815\ubcf4 \ud655\uc778
– Options :<\/b> \ud574\ub2f9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc124\uc815\ub418\uc5b4 \uc788\ub294 \uc81c\ud488\uc758 \uc635\uc158 \ub9ac\uc2a4\ud2b8 \ud655\uc778
– \ud30c\ub77c\ubbf8\ud130 : <\/b>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\ub77c\ubbf8\ud130 \uc815\ubcf4 \ud655\uc778
– \uc138\uc158 : <\/b>\ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ub418\uc5b4 \uc788\ub294 \uc138\uc158 \uc815\ubcf4 \ud655\uc778
– \ud0d1 \uc138\uc158 :<\/b> \ud604\uc7ac \uc5f0\uacb0\ub418\uc5b4 \uc788\ub294 \uc138\uc158 \uc911\uc5d0\uc11c \ud0d1 \uc138\uc158 \ub9ac\uc2a4\ud2b8 \ud655\uc778
– RBS \uc561\ud2f0\ube44\ud2f0 : <\/b>\ub864\ubc31 \uc138\uadf8\uba3c\ud2b8\uc758 \uc561\ud2f0\ube44\ud2f0 \uc815\ubcf4 \ud655\uc778
– Space Usage :<\/b> \uac01 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc758 \uc2a4\ud1a0\ub9ac\uc9c0 \ud30c\ub77c\ubbf8\ud130 \uc815\ubcf4\uc640 \uc2a4\ud398\uc774\uc2a4 \uc815\ubcf4 \ud655\uc778
– \ub370\uc774\ud130\ud30c\uc77c I\/O :<\/b> \uac01 \ub370\uc774\ud130\ud30c\uc77c\uc758 \ud1a0\ud0c8 \uc0ac\uc774\uc988, \ud504\ub9ac \uc0ac\uc774\uc988(Free Size)\uc640 \ub0b4\ubd80 \ube14\ub7ed\ub9c8\ub2e4\uc758 \uc77d\uae30\/\uc4f0\uae30 \ud68c\uc218 \ub4f1\uc5d0 \ub300\ud55c \uc815\ubcf4 \ud655\uc778 <\/p>\n

SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8<\/p>\n

SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8\ub294 \ud1a0\ub4dc\uc758 DBA \ubaa8\ub4c8\uc5d0 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 \uae30\ub2a5\uc740 \uc544\ub2c8\uba70, \ud1a0\ub4dc\uc758 \uc5d1\uc2a4\ud37c\ud2b8 \ud29c\ub2dd \ubaa8\ub4c8(Xpert Tuning Module)\uc5d0 \uc788\ub294 \uae30\ub2a5\uc774\ub2e4.
DBA\uac00 \uc2dc\uc2a4\ud15c \ud37c\ud3ec\uba3c\uc2a4 \ud29c\ub2dd\ub9cc \uc218\ud589\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \uadf8 \uc548\uc5d0\uc11c \ub3d9\uc791\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud29c\ub2dd\uc5d0 \ub354\uc6b1 \ub9ce\uc740 \uc2dc\uac04\uc744 \uc18c\ube44\ud560 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \ud1a0\ub4dc\ub97c \uc774\uc6a9\ud574 \uc774 \ubd80\ubd84\uc744 \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc81c\uc2dc\ud558\uace0\uc790 \ud55c\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc6b4\uc601\ud558\ub2e4 \ub9ce\uc774 \uc811\ud558\uac8c \ub418\ub294 \ubb38\uc81c\ub294 \ubc14\ub85c \uc798\ubabb \uc791\uc131\ub41c SQL \ubb38\uc7a5\uc774 \ub420 \uac83\uc774\ub2e4. \ud1a0\ub4dc\uc758 \uc5d1\uc2a4\ud37c\ud2b8 \uc5d0\ub514\uc158\uc740 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc798\ubabb \uc791\uc131\ub418\uc5b4 \uc131\ub2a5\uc774 \ub2e4\uc6b4\ub418\ub294 \uc694\uc778\uc774 \ub418\uace0 \uc788\ub294 SQL \ubb38\uc7a5\uc744 \ucc3e\uc544 \uac00\uc7a5 \ucd5c\uc801\uc758 SQL \ubb38\uc7a5\uc73c\ub85c \ubc14\uafd4\uc8fc\ub294 \uae30\ub2a5\uc744 \uac16\uace0 \uc788\ub2e4.
SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8 \uae30\ub2a5\uc740 SQL \uc5d0\ub514\ud130\ub098 \ud504\ub85c\uc2dc\uc800 \uc5d0\ub514\ud130(Procedure Editor)\uc5d0\uc11c SQL \ubb38\uc7a5\uc774\ub098 PL\/SQL \ubb38\uc7a5\uc744 \ub300\uc0c1\uc73c\ub85c \uac1c\ubc1c\uc2dc\uc5d0 \ucd5c\uc801\uc758 SQL\uacfc PL\/SQL\uc744 \ub9cc\ub4e4\uace0 \uc2f6\uc744 \uacbd\uc6b0\uc774\uac70\ub098, \uc2e4\ud589\ud588\uc73c\ub098 \ubc18\uc751 \uc2dc\uac04(Response Time)\uc774 \ub108\ubb34 \ub192\uac8c \ub098\ud0c0\ub098\uc11c \ud604\uc7ac \ud658\uacbd\uc5d0 \ub9de\ub294 \ucd5c\uc801\uc758 \ubb38\uc7a5\uc744 \ub9cc\ub4e4\uace0 \uc2f6\uc744 \uacbd\uc6b0 \uc0ac\uc6a9\ud55c\ub2e4. \uc77c\ub2e8 SQL \uc5d0\ub514\ud130\uc640 \ud504\ub85c\uc2dc\uc800 \uc5d0\ub514\ud130 \uc544\uc774\ucf58 \ubc84\ud2bc\uc744 \uc2e4\ud589\ud558\uba74 SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8\ub77c\ub294 \ud654\uba74\uc73c\ub85c \uc774\ub3d9\ud560 \uc218 \uc788\ub2e4. SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8 \ud654\uba74\uc758 \uc67c\ucabd\uc5d0\ub294 \ub124\ube44\uac8c\uc774\ud130 \ud328\ub110(Navigator Panel)\uc774\ub77c\ub294 \uac83\uc774 \uc788\ub294\ub370, \uc774 \ub124\ube44\uac8c\uc774\ud130 \ud328\ub110\uc758 \uc21c\uc11c\uc5d0 \ub530\ub77c SQL \ud29c\ub2dd \uacfc\uc815\uc744 \uc9c4\ud589\ud558\uba74 \ub41c\ub2e4. \ub2e4\uc74c\uc740 SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8\uc5d0\uc11c SQL \ud29c\ub2dd \uacfc\uc815\uc744 \uc9c4\ud589\ud558\ub294 \uc808\ucc28\uc774\ub2e4. <\/p>\n

1\ub2e8\uacc4, SQL Detail<\/p>\n

\uc5ec\uae30\uc11c\ub294 SQL \uc5d0\ub514\ud130\ub098 \ud504\ub85c\uc2dc\uc800 \uc5d0\ub514\ud130\uc5d0\uc11c \uc218\ud589 \uc911\uc778 SQL \ubb38\uc7a5\uc744 \ub4dc\ub798\uadf8\ud574 Execution Plan\uacfc \ud574\ub2f9 SQL \ubb38\uc7a5\uc5d0 \ub098\ud0c0\ub09c \uac1d\uccb4\uc758 \uc815\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. Execution Plan\uc744 \ud1b5\ud574 \ud604\uc7ac SQL \ubb38\uc7a5\uc774 \uc5b4\ub5bb\uac8c \uc218\ud589\ub420 \uac83\uc774\uc9c0 \uc608\uce21\ud560 \uc218 \uc788\uc73c\uba70, \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 \uc778\ub371\uc2a4\ub098 \uceec\ub7fc\uc758 \uc815\ubcf4\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 18> SQL Detail Window
<\/p>\n

2\ub2e8\uacc4, View Advice<\/p>\n

\uc774 \ubd80\ubd84\uc740 \ud604\uc7ac\uc758 SQL \ubb38\uc7a5\uc5d0 \ub300\ud574 Execution Plan\uc758 \uc815\ubcf4\ub9cc \uac16\uace0 \ud29c\ub2dd \uc561\uc158\uc744 \uacb0\uc815\ud560 \uc218\uac00 \uc5c6\uc744 \uacbd\uc6b0 \uac1c\ubc1c\uc790\ub098 DBA\uc5d0\uac8c \ud604\uc7ac \ud658\uacbd\uc5d0 \uc801\ud569\ud55c \uac00\uc7a5 \ucd5c\uc801\uc758 SQL \uc194\ub8e8\uc158\uc744 \uc81c\uacf5\ud55c\ub2e4. <\/p>\n

<\ud654\uba74 19> View Advice Window
<\/p>\n

– Auto Tune :<\/b> \uc774\ub294 \uc624\ub77c\ud074 \uc635\ud2f0\ub9c8\uc774\uc800\uac00 \ud310\ub2e8\ud55c \uadfc\uac70\ub97c \uae30\uc900\uc73c\ub85c \uc790\ub3d9\uc73c\ub85c \ud604\uc7ac SQL \ubb38\uc7a5\uc5d0 \ub9de\ub294 \ucd5c\uc801\uc758 \uc194\ub8e8\uc158 \ub9ac\uc2a4\ud2b8\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc774\ub294 \ud29c\ub2dd \ucd08\ubcf4\uc790\uc5d0\uac8c \uc801\ud569\ud55c \uac83\uc73c\ub85c SQL \ud29c\ub2dd\uc5d0 \ub300\ud55c \uc9c0\uc2dd\uc774 \uc5c6\ub354\ub77c\ub3c4 \ud29c\ub2dd \uc194\ub8e8\uc158\uc744 \ucc3e\uc744 \uc218 \uc788\uac8c \ud55c\ub2e4. <\/p>\n

– Advice : <\/b>\uc774\ub294 \ud604\uc7ac \ud658\uacbd\uc5d0 \uc801\ud569\ud55c Advice List\ub97c \ubcf4\uc5ec\uc90c\uc73c\ub85c\uc368 \uc5b4\ub290 \uc815\ub3c4 \uc219\ub828\ub41c \ud29c\ub108\uac00 \uc790\uae30\uac00 \uc0dd\uac01\ud55c \ud29c\ub2dd \uc194\ub8e8\uc158\uacfc \uc77c\uce58\ud558\ub294 \uc0ac\ud56d\uc744 \ucc3e\uc544 \uc218\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uc815\ubcf4\ub97c \uc81c\uacf5\ud55c\ub2e4. <\/p>\n

– Manual Tune : <\/b>\ud1a0\ub4dc\uc758 SQL \ud29c\ub2dd \uc5d1\uc2a4\ud37c\ud2b8\uc5d0\uac8c \uc758\uc874\ud558\uc9c0 \uc54a\uace0 \uc9c1\uc811 SQL \ubb38\uc7a5\uc744 \ucf54\ub529\ud558\ub294 \uacbd\uc6b0 \uc0ac\uc6a9\ud55c\ub2e4. <\/p>\n

3\ub2e8\uacc4, Compare Scenario<\/p>\n

Advice\uc5d0\uc11c \uc120\ud0dd\ud55c \uc0ac\ud56d\uc744 \ud1a0\ub300\ub85c Original SQL \ubb38\uc7a5\uacfc Advice SQL \ubb38\uc7a5\uc758 Explain Plan\uacfc SQL \ubb38\uc7a5\uc744 \uae30\uc900\uc73c\ub85c \ube44\uad50\ud560 \uc218 \uc788\ub3c4\ub85d \uc815\ubcf4\ub97c \uc81c\uacf5\ud55c\ub2e4. <\/p>\n

<\ud654\uba74 20> Compare Scenario Window
<\/p>\n

4\ub2e8\uacc4, Execution Scenario<\/p>\n

Compare Scenario \uc2a4\ud15d\uae4c\uc9c0\ub294 \uc9c1\uc811 SQL \ubb38\uc7a5\uc744 \uc2e4\ud589\ud558\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc5d0\uc11c \uac04\uc811\uc801\uc73c\ub85c \ube44\uad50\ub97c \uc218\ud589\ud55c \uac83\uc5d0 \ubc18\ud574 \uc774 \ubd80\ubd84\uc740 \uc9c1\uc811 Original SQL \ubb38\uc7a5\uacfc Advice SQL \ubb38\uc7a5\uc744 \uc2e4\ud589\ud574 \ube44\uad50\ud560 \uc218 \uc788\ub294 \uc815\ubcf4\ub97c \uc81c\uacf5\ud55c\ub2e4. \ub9cc\uc57d Trace \uc815\ubcf4\ub97c \ub9cc\ub4e4\uace0 \uc2f6\ub2e4\uba74 \uc635\uc158\uc73c\ub85c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\ub2e4.
\uc2e4\ud589 \uacfc\uc815\uc774 \ub05d\ub098\uba74 Original SQL\uacfc Advice SQL\uc5d0 \ub300\ud574 \uadf8\ub798\ud53d\ud558\uac8c \ube44\uad50\ud560 \uc218 \uc788\ub294 \uadf8\ub9bc\uc774 \ub098\ud0c0\ub098\uba70 \uc774\ub97c \ud1b5\ud574 \uc2dc\uac01\uc801\uc73c\ub85c \ucd5c\uc801\uc758 \uc194\ub8e8\uc158\uc744 \ucc3e\uc744 \uc218 \uc788\ub2e4. <\/p>\n

<\ud654\uba74 21> Advice \uc801\uc6a9 \ud6c4 \uc131\ub2a5 \ud5a5\uc0c1 \uae30\ub300\uce58 \ube44\uad50
<\/p>\n

– Index Advice :<\/b> \ub9cc\uc57d View Advice \ub2e8\uacc4\uc5d0\uc11c \uc120\ud0dd\ud55c Advice\uac00 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\u00b7\uc0ad\uc81c\u00b7\ubcc0\uacbd\ud558\ub294 \uc791\uc5c5\uc774\uc5c8\ub2e4\uba74 \uc774\ubc88 \ub2e8\uacc4\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c DDL \uba85\ub839\uc744 \uc218\ud589\ud574\uc57c \ud55c\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub97c \uc801\uc6a9\ud588\uc744 \uacbd\uc6b0 \ub2e4\ub978 SQL \ubb38\uc7a5\uc774 \uc601\ud5a5\uc744 \ubc1b\uc744 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc870\uc2ec\uc2a4\ub7fd\uac8c \uc811\uadfc\ud574\uc57c \ud560 \uac83\uc774\ub2e4. \ub530\ub77c\uc11c \uc2e4\uc81c\ub85c\ub294 \uc2e4\ud589\uc2dc\uc5d0 \uc778\ub371\uc2a4\uc5d0 \ub300\ud55c DDL \uba85\ub839\uc744 \uc218\ud589\ud558\uc9c0 \uc54a\uace0 \ubc84\ucd94\uc5bc\ud558\uac8c \uc218\ud589\ud574 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\ub294 \uc120\uc5d0\uc11c \ube44\uad50\ud560 \uc218 \uc788\ub3c4\ub85d \uc815\ubcf4\ub97c \uc81c\uacf5\ud55c\ub2e4. <\/p>\n

– Rewrite : <\/b>View Advice \ub2e8\uacc4\uc5d0\uc11c \uc120\ud0dd\ud55c Advice\uac00 \ubb38\uc7a5\uc744 \ubc14\uafb8\ub294 \uc120\uc5d0\uc11c \uc81c\uacf5\ub418\uace0 \uc788\ub2e4\uba74, \ud604\uc7ac Original SQL\ubb38\uc7a5\uc744 \ub300\uc2e0\ud560 \uc218 \uc788\ub294 \ub300\uccb4 SQL \ubb38\uc7a5\uc744 \uc120\ud0dd\ud55c \uacbd\uc6b0\uc774\ub2e4. \uc774\ub97c \ud1b5\ud574 \ud604\uc7ac \uacfc\uc815\uc744 \uc9c4\ud589\ud558\uba74 Original SQL\uacfc Advice SQL\uc744 \uc804\ubd80 \uc2e4\uc81c\ub85c \uc2e4\ud589\ud558\ub294 \uacfc\uc815\uc744 \uac70\uce58\uac8c \ub41c\ub2e4. <\/p>\n

– Other Advice : <\/b>DDL Advice\ub098 SQL Rewrite\uac00 \uc544\ub2cc \ub2e4\ub978 \ub0b4\uc6a9\ub4e4\uc744 \uc81c\uc2dc\ud55c \uac83\uc744 \uc120\ud0dd\ud55c \uacbd\uc6b0\uac00 \ud574\ub2f9\ub41c\ub2e4. <\/p>\n

5\ub2e8\uacc4, Execution Results<\/p>\n

\uc2e4\ud589\ud55c \ub0b4\uc6a9\uc744 \ud1a0\ub300\ub85c \uadf8 \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc8fc\uba70 \uc2e4\ud589\uc2dc\uc5d0 \uc0dd\uc131\ub41c \ud1b5\uacc4 \uc815\ubcf4\ub97c \ube44\uad50\ud560 \uc218 \uc788\ub2e4. \ud1a0\ud0c8 CPU, Elapsed Time, Logical Read, Physical Read \ub4f1\uc758 \ub9ce\uc740 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc11c\ub85c \ube44\uad50\ud560 \uc218 \uc788\ub2e4. <\/p>\n

6\ub2e8\uacc4, Best Practice<\/p>\n

\uc55e\uc758 Advice\uc5d0\uc11c \uc120\ud0dd\ud55c \uc0ac\ud56d\uc744 \ud1a0\ub300\ub85c \uc2e4\uc81c \uc2e4\ud589\uacfc\uc815\uc744 \uac70\uce5c\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc778\ub371\uc2a4 \uc0dd\uc131 Advice\ub97c \uc120\ud0dd\ud588\ub2e4\uba74 4\ubc88 \ub2e8\uacc4\uc5d0\uc11c\ub294 \uac00\uc0c1\uc801\uc73c\ub85c \uc0dd\uc131\ud574 \ube44\uad50\ub97c \uc218\ud589\ud588\ub294\ub370, \uc774\ub97c \ube44\uad50 \uac80\ud1a0 \ud6c4 \uc801\uc6a9\ud558\ub294 \uacfc\uc815\uc774\ub77c\uace0 \uc0dd\uac01\ud558\uba74 \ub41c\ub2e4. \ub610\ud55c \ucd94\uac00\uc801\uc73c\ub85c \uc218\ud589\ud560 \ub54c \ub354 \uc801\ud569\ud55c \ub0b4\uc6a9\ub4e4\uc774 \uc788\ub2e4\uba74, \uc608\ub97c \ub4e4\uc5b4 \ubd84\uc11d \uc791\uc5c5 \uac19\uc740 \ub0b4\uc6a9\uc774 \uc5ec\uae30\uc5d0 \ud3ec\ud568\ub420 \uc218 \uc788\ub294\ub370 \ucd5c\uc801\uc758 \uc0c1\ud0dc\uac00 \ub420 \uc218 \uc788\ub294 \ub9ac\uc2a4\ud2b8\ub97c \uc81c\uc2dc\ud558\uba74 \ud29c\ub108\ub294 \uc5ec\uae30\uc5d0\uc11c \uc6d0\ud558\ub294 \ub0b4\uc6a9\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\ub2e4. <\/p>\n

7\ub2e8\uacc4, Tuning Resolution<\/p>\n

\uc9c0\uae08\uae4c\uc9c0 \uc9c4\ud589\ud574\uc628 \ubaa8\ub4e0 \uc0ac\ud56d\uc744 \uae30\ubcf8\uc73c\ub85c \ud574 Original SQL\uacfc Advice SQL\uc5d0 \ub300\ud574 \uc5b4\ub290 \uc815\ub3c4 \uc131\ub2a5 \ud6a8\uacfc\ub97c \ubcf4\uc600\ub294\uc9c0\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\/p>\n

\ud1a0\ub4dc\uc758 \ub2e4\uc591\ud55c \uae30\ub2a5\uc744 \uc2b5\ub4dd\ud558\uae30 \ubc14\ub77c\uba70<\/p>\n

\uc9c0\uae08\uae4c\uc9c0 \ud1a0\ub4dc\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 DBA \ubaa8\ub4c8\uc5d0 \ub300\ud55c \uc77c\ubd80 \uae30\ub2a5\uc744 \uc18c\uac1c\ud588\ub2e4. \ud1a0\ub4dc\ub77c\ub294 \ud234\uc740 \ub108\ubb34\ub098 \ub9ce\uc740 \uae30\ub2a5\ub4e4\uc744 \uac16\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc0ac\uc6a9\uc790\uc758 \uc785\uc7a5\uc5d0\uc11c \uc5b4\ub5a4 \uae30\ub2a5\ub4e4\uc774 \ud1a0\ub4dc\uc5d0 \uc788\ub294\uc9c0\uc870\ucc28 \ubaa8\ub974\ub294 \uacbd\uc6b0\uac00 \ub2e4\ubc18\uc0ac\ub77c\uace0 \uc0dd\uac01\ud55c\ub2e4. \uc774\ub807\uac8c \ud1a0\ub4dc\uc5d0\ub294 \uc228\uaca8\uc9c4 \ub9ce\uc740 \uae30\ub2a5\ub4e4\uc774 \ub3c5\uc790\uc758 \uc5c5\ubb34\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc73c\uba74 \ud558\ub294 \ubc14\ub78c\uc774\ub2e4. <\/p>\n

\uc81c\uacf5 : DB\ud3ec\ud0c8\uc0ac\uc774\ud2b8 DBguide.net <\/font><\/b><\/a><\/p>\n

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

  DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 \ubc15\uc911\uc218 | \uc5d4\ucee4\ube14\ub8e8 \uae30\uc220\ubcf8\ubd80 \ub300\ud45c \ucee8\uc124\ud134\ud2b8 \uae30\uc5c5\uc5d0\uc11c\uc758 \ub370\uc774\ud130 \uc99d\uac00\ub294 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \ub298\uc5b4\ub098\uace0 \uc788\uc73c\uba70 \uadf8\uc5d0 \ub530\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\ub3c4 \ub300\uc6a9\ub7c9\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ubc1c\uc804\ud558\uace0 \uc788\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 \uc608\uc804\uacfc \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc6b4\uc601\uc744 \ub9e4\ub274\uc5bc\ud558\uac8c \ud560 \uc218 \uc788\ub294 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[685,670],"tags":[446,209,63],"class_list":["post-351","post","type-post","status-publish","format-standard","hentry","category-database-","category-util-tools","tag-dba","tag-toad","tag-oracle"],"yoast_head":"\nDBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 - Apollo89.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/apollo89.com\/wordpress\/?p=351\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 - Apollo89.com\" \/>\n<meta property=\"og:description\" content=\"  DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 \ubc15\uc911\uc218 | \uc5d4\ucee4\ube14\ub8e8 \uae30\uc220\ubcf8\ubd80 \ub300\ud45c \ucee8\uc124\ud134\ud2b8 \uae30\uc5c5\uc5d0\uc11c\uc758 \ub370\uc774\ud130 \uc99d\uac00\ub294 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \ub298\uc5b4\ub098\uace0 \uc788\uc73c\uba70 \uadf8\uc5d0 \ub530\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\ub3c4 \ub300\uc6a9\ub7c9\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ubc1c\uc804\ud558\uace0 \uc788\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 \uc608\uc804\uacfc \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc6b4\uc601\uc744 \ub9e4\ub274\uc5bc\ud558\uac8c \ud560 \uc218 \uc788\ub294 … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/apollo89.com\/wordpress\/?p=351\" \/>\n<meta property=\"og:site_name\" content=\"Apollo89.com\" \/>\n<meta property=\"article:published_time\" content=\"2009-11-19T06:41:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-02T03:03:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbguide.net\/images\/know\/tech\/041103_243_1.jpg\" \/>\n<meta name=\"author\" content=\"apollo89\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"apollo89\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351\"},\"author\":{\"name\":\"apollo89\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\"},\"headline\":\"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30\",\"datePublished\":\"2009-11-19T06:41:01+00:00\",\"dateModified\":\"2013-02-02T03:03:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351\"},\"wordCount\":712,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbguide.net\\\/images\\\/know\\\/tech\\\/041103_243_1.jpg\",\"keywords\":[\"DBA\",\"Toad\",\"\uc624\ub77c\ud074\"],\"articleSection\":[\"Database\",\"Util\\\/Tools\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351\",\"name\":\"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 - Apollo89.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbguide.net\\\/images\\\/know\\\/tech\\\/041103_243_1.jpg\",\"datePublished\":\"2009-11-19T06:41:01+00:00\",\"dateModified\":\"2013-02-02T03:03:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#primaryimage\",\"url\":\"http:\\\/\\\/www.dbguide.net\\\/images\\\/know\\\/tech\\\/041103_243_1.jpg\",\"contentUrl\":\"http:\\\/\\\/www.dbguide.net\\\/images\\\/know\\\/tech\\\/041103_243_1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=351#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/apollo89.com\\\/wordpress\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/\",\"name\":\"Apollo89.com\",\"description\":\"\uc544\ud3f4\ub85c\uc528\uc758 \uc7a1\ub2e4\ud55c \uacbd\ud5d8\ub4e4..\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\",\"name\":\"apollo89\",\"description\":\"\uc544\ud3f4\ub85c89 \uc785\ub2c8\ub2e4.\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 - Apollo89.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/apollo89.com\/wordpress\/?p=351","og_locale":"ko_KR","og_type":"article","og_title":"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 - Apollo89.com","og_description":"  DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 \ubc15\uc911\uc218 | \uc5d4\ucee4\ube14\ub8e8 \uae30\uc220\ubcf8\ubd80 \ub300\ud45c \ucee8\uc124\ud134\ud2b8 \uae30\uc5c5\uc5d0\uc11c\uc758 \ub370\uc774\ud130 \uc99d\uac00\ub294 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \ub298\uc5b4\ub098\uace0 \uc788\uc73c\uba70 \uadf8\uc5d0 \ub530\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\ub3c4 \ub300\uc6a9\ub7c9\uc744 \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ubc1c\uc804\ud558\uace0 \uc788\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 \uc608\uc804\uacfc \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc6b4\uc601\uc744 \ub9e4\ub274\uc5bc\ud558\uac8c \ud560 \uc218 \uc788\ub294 … Continue reading →","og_url":"https:\/\/apollo89.com\/wordpress\/?p=351","og_site_name":"Apollo89.com","article_published_time":"2009-11-19T06:41:01+00:00","article_modified_time":"2013-02-02T03:03:46+00:00","og_image":[{"url":"http:\/\/www.dbguide.net\/images\/know\/tech\/041103_243_1.jpg","type":"","width":"","height":""}],"author":"apollo89","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"apollo89","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/apollo89.com\/wordpress\/?p=351#article","isPartOf":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=351"},"author":{"name":"apollo89","@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82"},"headline":"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30","datePublished":"2009-11-19T06:41:01+00:00","dateModified":"2013-02-02T03:03:46+00:00","mainEntityOfPage":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=351"},"wordCount":712,"commentCount":1,"image":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=351#primaryimage"},"thumbnailUrl":"http:\/\/www.dbguide.net\/images\/know\/tech\/041103_243_1.jpg","keywords":["DBA","Toad","\uc624\ub77c\ud074"],"articleSection":["Database","Util\/Tools"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/apollo89.com\/wordpress\/?p=351#respond"]}]},{"@type":"WebPage","@id":"https:\/\/apollo89.com\/wordpress\/?p=351","url":"https:\/\/apollo89.com\/wordpress\/?p=351","name":"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30 - Apollo89.com","isPartOf":{"@id":"https:\/\/apollo89.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=351#primaryimage"},"image":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=351#primaryimage"},"thumbnailUrl":"http:\/\/www.dbguide.net\/images\/know\/tech\/041103_243_1.jpg","datePublished":"2009-11-19T06:41:01+00:00","dateModified":"2013-02-02T03:03:46+00:00","author":{"@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82"},"breadcrumb":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=351#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/apollo89.com\/wordpress\/?p=351"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/apollo89.com\/wordpress\/?p=351#primaryimage","url":"http:\/\/www.dbguide.net\/images\/know\/tech\/041103_243_1.jpg","contentUrl":"http:\/\/www.dbguide.net\/images\/know\/tech\/041103_243_1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/apollo89.com\/wordpress\/?p=351#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/apollo89.com\/wordpress"},{"@type":"ListItem","position":2,"name":"DBA\uc5d0\uac8c \uc720\uc6a9\ud55c Toad\uc758 \uc228\uc740 \uae30\ub2a5 \ucc3e\uae30"}]},{"@type":"WebSite","@id":"https:\/\/apollo89.com\/wordpress\/#website","url":"https:\/\/apollo89.com\/wordpress\/","name":"Apollo89.com","description":"\uc544\ud3f4\ub85c\uc528\uc758 \uc7a1\ub2e4\ud55c \uacbd\ud5d8\ub4e4..","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/apollo89.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82","name":"apollo89","description":"\uc544\ud3f4\ub85c89 \uc785\ub2c8\ub2e4.","url":"https:\/\/apollo89.com\/wordpress\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=351"}],"version-history":[{"count":0,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/351\/revisions"}],"wp:attachment":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}