{"id":710,"date":"2015-11-24T04:52:41","date_gmt":"2015-11-24T04:52:41","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=710"},"modified":"2015-11-24T04:52:41","modified_gmt":"2015-11-24T04:52:41","slug":"%ed%86%b5%ea%b3%84%ec%a0%95%eb%b3%b4-%ed%99%9c%ec%9a%a9-%eb%b0%a9%ec%95%88","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=710","title":{"rendered":"\ud1b5\uacc4\uc815\ubcf4 \ud65c\uc6a9 \ubc29\uc548"},"content":{"rendered":"<ul>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uac1c\uc694<br \/>\n<\/strong><\/span><\/div>\n<ul>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4<br \/>\n<\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4\ub294 \ud574\ub2f9 Table   \ubc0f Index,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column  \uc5d0 \ub300\ud55c \ud1b5\uacc4\uce58\ub85c\uc11c Optimizer \uac00 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 Execution plan \uc744 \uc218\ub9bd\ud558\uae30 \uc704\ud574 \ucd5c\uc18c\ube44\uc6a9\uc744 \uacc4\uc0b0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 \uc815\ubcf4\uc774\ub2e4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\ub610\ud55c Object\uad6c\uc870 \ubc0f Chain\uc815\ubcf4\ub3c4 \uc81c\uacf5\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">COST Based Optimizer \uc758 \uacbd\uc6b0 \ud2b9\ubcc4\ud55c \ubaa9\uc801\uc744 \uc81c\uc678\ud558\uace0\ub294 \ubc18\ub4dc\uc2dc \ud1b5\uacc4\uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\uc5b4\uc57c Optimizer \uac00 \uac00\ub2a5\ud55c \uc815\ud655\ud55c Execution Plan \uc744 \uc0dd\uc131\ud558\uac8c \ub41c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc608\ub97c \ub4e4\uba74, \ud2b9\uc815 \uceec\ub7fc\uc758 distinct value \uac00 3 \uc774\ud558\uc774\uba74, \uc870\uac74\uc808\uc5d0 \ud574\ub2f9 \uceec\ub7fc\uc774 \uc778\ub371\uc2a4\uc0ac\uc6a9 \uc870\uac74\uc5d0 \ub9cc\uc871\ud558\ub354\ub77c\ub3c4 Optimizer \uac00 \uc778\ub371\uc2a4 \uc0ac\uc6a9 Cost \ub97c \ub192\uac8c \uacc4\uc0b0\ud558\uc5ec full scan \uc73c\ub85c \uc720\ub3c4\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uadf8\ub7ec\ub098, <span style=\"color:red\">System Table (sys, system schema)\uc5d0 \ub300\ud574\uc11c\ub294 \uc808\ub300 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud574\uc11c\ub294 \uc548 \ub41c\ub2e4. <\/span>\ub9cc\uc57d \ud1b5\uacc4\uc815\ubcf4\ub97c \uc778\uc704\uc801\uc73c\ub85c \uc0dd\uc131\ud560 \uacbd\uc6b0 \ube44\ud6a8\uc728 \ubc1c\uc0dd \uac00\ub2a5\uc131\uc774 \ub9e4\uc6b0 \ub192\ub2e4. System \uc740 \uadf8 \uc790\uccb4\ub85c \ucd5c\uc801\uc758 \uad00\ub9ac\ub97c \ud568\uc73c\ub85c \uc808\ub300 \uc0dd\uc131\ud574\uc11c\ub294 \uc548 \ub41c\ub2e4. \ub610\ud55c Temporary Table \uc740 Table \ud2b9\uc131 \uc0c1 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\uc9c0 \uc54a\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \uc2dc, &lt; analyze &gt; command  \ub97c \uc9c1\uc811 \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uace0, Oracle \uc5d0\uc11c \uc81c\uacf5\ud574\uc8fc\ub294  DBMS_STATS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Package  \ub97c \ud65c\uc6a9\ud560 \uc218\ub3c4 \uc788\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze \uc5d0 \uc758\ud574 \uc0dd\uc131\ub418\ub294 \uc815\ubcf4\ub294 \uc544\ub798\uc640 \uac19\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;( dba_tables, all_tables )<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Table\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131\ud560 \ub54c\ub294 \ud2b9\ubcc4\ud55c \uc624\ub958\ub294 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\uc558\uc73c\uba70, \ub2e4\ub9cc IOT type \uc758 Table \uc740 \uc544\ub798 \ud1b5\uacc4\uc815\ubcf4 \uc911 Block \uc815\ubcf4(blocks, empty_blocks)\uac00 Null \uac12\uc774 \ub41c\ub2e4. \uc774\uac83\uc740 Index \ub85c \uad00\ub9ac\ub418\uae30 \ub54c\ubb38\uc774\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_ROWS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLOCKS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EMPTY_BLOCKS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVG_SPACE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CHAIN_CNT<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVG_ROW_LEN<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVG_SPACE_FREELIST_BLOCKS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_FREELIST_BLOCKS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SAMPLE_SIZE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LAST_ANALYZED<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022<strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INDEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;( dba_indexes, all_indexes  )<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Index \ub294 \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \ubc0f \uc774\ud589\uc758 \uac00\uc7a5 \uc8fc\uc758\ud574\uc57c \ud560 \ubd80\ubd84\uc73c\ub85c \ubc18\ub4dc\uc2dc \uc0dd\uc131 \ubc0f \uc774\ud589 \uc2dc \uc815\ud655\ud788 Check  \ud574\uc57c \ud568.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud2b9\ud788, Index Type \uc774 &lt;LOB&gt;, &lt;DOMAIN&gt; \uc778 \uacbd\uc6b0\uc5d0\ub294 \uadf8 \ucc38\uc870 \uac12\uc774 \uc5b4\ub5a4 \uac83\uc778\uc9c0 \uc77c\uc77c\uc774 \ucc3e\uc544\uc57c \ud558\uba70, \ub2e8\uc21c dba_indexes View \uc5d0\uc11c\ub294 \ud1b5\uacc4\uc815\ubcf4\uac00 \ubcf4\uc774\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \ub300\ubd80\ubd84\uc774\ub2e4. LOB \uc740 \ud558\ub098\uc758 Column  \uc744 \ucc38\uc870\ud574\uc57c\ub9cc \ud558\ub294 \uc81c\uc57d\uc0ac\ud56d\uc774 \uc788\uc73c\uba70, \uadf8 Column \uc740 \ud558\ub098\uc758 \ub3c5\ub9bd\ub41c object ( Table, Array) \ub4f1\uc73c\ub85c \ud45c\ud604\ub41c \uac83\uc73c\ub85c, \uadf8 depth \uac00 \uba87 \ub2e8\uacc4\uac00 \ub418\ub294 \uac83\ub3c4 \uc788\ub2e4. \ucc38\uc870 \uceec\ub7fc\uc744 \ud655\uc778\ud558\ub824\uba74 (dba_lobs) \ub97c recursive \ud558\uac8c \ucc3e\uc544\uac00\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub610\ud55c, \ub610 \ud558\ub098\uc758 \ud2b9\uc218 Type \uc778 &lt;DOMAIN&gt; \ub3c4 \ud655\uc778\ud558\uae30 \uc5b4\ub824\uc6b0\uba70, \ud1b5\uacc4\uc815\ubcf4 \ub610\ud55c dba_indexes \uc774\uc678\uc758 \ub2e4\ub978 \ucc38\uc870 View  \ub97c \ud1b5\ud574 \ud655\uc778\ud574\uc57c \ud568..<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud574\ub2f9 \uc778\ub371\uc2a4\uc758 \ud1b5\uacc4\uc815\ubcf4\uac00 \ubaa8\ub450 Null \uc774\ub77c\uace0 Analyze \uac00 \uc798\ubabb\ub410\ub2e4\uace0 \ud310\ub2e8\ud558\uba74 \uc704 2\uac1c\uc758 Index Type \uc5d0 \ub300\ud574\uc11c\ub294 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub610\ud55c  Index Rebuild \uc2dc \uc77c\ubc18\uc801\uc73c\ub85c \ud1b5\uacc4\uc815\ubcf4\ub294 \uadf8\ub300\ub85c \uc720\uc9c0 \ub41c\ub2e4.  \uadf8\ub7ec\ub098<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Partition Table \uc758 Local Index \uc758 \uacbd\uc6b0 Rebuild \uc2dc \ud1b5\uacc4\uc815\ubcf4 \uc0ad\uc81c\ub428.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLEVEL<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LEAF_BLOCKS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISTINCT_KEYS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVG_LEAF_BLOCKS_PER_KEY<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVG_DATA_BLOCKS_PER_KEY<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CLUSTERING_FACTOR<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_ROWS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SAMPLE_SIZE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LAST_ANALYZED<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COLUMN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(dba_tab_columns, all_tab_columns )<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Column \ud1b5\uacc4\uc815\ubcf4\ub294 \ub300\uac1c Table \ud1b5\uacc4\uc815\ubcf4\uac00 \uc0dd\uc131\ub418\uba74 \uc815\uc0c1 \uc0dd\uc131 \ub428. \ub2e8, Patch \ub4f1 \uceec\ub7fc\uc774 \ucd94\uac00\ub418\ub294 \uacbd\uc6b0\uac00 \uc788\uc73c\ubbc0\ub85c \uc8fc\uae30\uc801\uc73c\ub85c \ud655\uc778\ud574\uc57c \ud568.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_DISTINCT<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LOW_VALUE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HIGH_VALUE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DENSITY<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_NULLS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_BUCKETS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LAST_ANALYZED<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SAMPLE_SIZE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVG_COL_LEN<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<ul>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Histogram<br \/>\n<\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Histogram \uc740 \ud2b9\uc815 Column \uc5d0 \ub300\ud55c \ubd84\ud3ec\ub3c4\ub97c \ub098\ud0c0\ub0b4\ub294 \uac83\uc73c\ub85c Cost Based Optimizer \ud658\uacbd\uc5d0\uc11c \uc870\uac74\uc808\uc5d0 \uc0ac\uc6a9\ub41c \uceec\ub7fc\uc758 \ube44\uad50 \uac12\uc5d0 \uc758\ud574 \ucc98\ub9ac \ubc94\uc704(\uc120\ud0dd\uc131)\uac00 \ud06c\uac8c \ub2ec\ub77c\uc9c8 \ub54c \ucc38\uc870\ub418\ub294 \uc815\ubcf4\ub85c Optimizer \ub294 Histogram \uc815\ubcf4\ub97c \ucc38\uc870\ud558\uc5ec Execution Plan \uc744 \ub2ec\ub9ac \uc0dd\uc131\ud55c\ub2e4. \ub530\ub77c\uc11c, \uc774\uac83\uc740 \ud574\ub2f9 \uceec\ub7fc\uc758 \uac12\uc758 \ubd84\ud3ec\uac00 Skewed \ub418\uc5b4 \ubd84\ud3ec\ud558\ub294 \uacbd\uc6b0\uc5d0 \ud2b9\ud788 \uc720\uc6a9\ud558\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ube44\uad50\ub418\ub294 \uceec\ub7fc\uc774 Skewed \ub418\uc5b4 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c\uace0, \uadf8 \uceec\ub7fc\uc5d0 \ub300\ud574 Histogram \uc815\ubcf4\uac00 \uc788\uc744 \ub54c\uc5d0\ub294 \uac00\ub2a5\ud55c Literal value \ub97c \uc0ac\uc6a9\ud558\uc5ec Optimizer\uac00 \uc815\ud655\ud55c Plan \uc744 \uc0dd\uc131\ud560 \uc218 \uc788\ub3c4\ub85d \uc720\ub3c4\ud574\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&lt;&lt;  \uc8fc\uc758 \uc0ac\ud56d &gt;&gt;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Where  \uc808\uc5d0 BIND  \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0, Histogram  \uc815\ubcf4\ub97c \uc0ac\uc6a9 \uc548 \ud568.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\ub370\uc774\ud130\uac00 \uc815\uc801\uc73c\ub85c \ubd84\ud3ec\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \uc790\uc8fc \uac31\uc2e0\ud574\uc57c \ud568.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Histogram \uc0dd\uc131\uc740 \ucd94\uac00 Storage \ub97c \ucc28\uc9c0 \ud558\ubbc0\ub85c \uc815\ud655\ud788 \uc0dd\uc131 \uc870\uac74 \ubc0f \ud65c\uc6a9 \uc6a9\ub3c4\ub97c \uc810\uac80 \ud6c4 \uc0dd\uc131\ud574\uc57c \ud568.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column  \uac12\uc774 \ub3d9\uc77c\ud558\uac8c \ubd84\ud3ec\ub418\uc5b4 \uc788\uc744 \uacbd\uc6b0 \uc0ac\uc6a9 \uc790\uc81c (   \ud2b9\ud788, unique   )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;For all indexed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;columns \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 unique column \uc5d0\ub3c4 \uc0dd\uc131\ub420 \uac00\ub2a5\uc131\uc774 \ub9ce\uc73c\ubbc0\ub85c \uc8fc\uc758\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c \ud568.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Histogram \uc0dd\uc131 \uc2dc Sample \uc218\ub294 Bucket size \uc758 100\ubc30 \uc774\uc0c1\uc774\uc5b4\uc57c \ud568.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Default  Bucket  size  :  75 ( size range : 1 ~ 254)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>Histogram \uc815\ubcf4 \ud655\uc778<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COLUMN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(dba_tab_columns, all_tab_columns )<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NUM_BUCKETS ( 2   \ubcf4\ub2e4 \ud070 \uacbd\uc6b0 Histogram   \uc774 \uc0dd\uc131\ub418\uc5c8\ub2e4\uace0 \ud310\ub2e8  )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HISTOGRAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(dba_tab_histgograms , all_tab_ histgograms )<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TABLE_NAME<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COLUMN_NAME<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ENDPOINT_NUMBER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ENDPOINT_VALUE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">&#8211;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ENDPOINT_ACTUAL_VALUE<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<ul>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc6b4\uc601 \ubc29\uc548<span style=\"font-size:12pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/strong><\/span><\/div>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc6b4\uc601 \ubc29\ubc95<br \/>\n<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4\ub294 \ubb3c\ub860 \uac00\uc7a5 \ucd5c\uc2e0 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0  \uc788\uc73c\uba74 \ucd5c\uc120\uc774\uc9c0\ub9cc, Data size \uc5d0 \ube44\ub840\ud574 \ub9ce\uc740 \uc0dd\uc131 \uc2dc\uac04\uc774 \ud544\uc694\ud558\ubbc0\ub85c Table \uc758 \uc131\uaca9\uc5d0 \ub530\ub77c \uc8fc\uae30\ub97c \uc815\ud558\ub294 \uac83\uc774 \ud569\ub9ac\uc801\uc774\ub2e4. \ub610\ud55c \uc218\ub9ce\uc740 Application \ub4e4\uc774 \uc218\ud589\ub418\ub294 \ud658\uacbd\uc5d0\uc11c\ub294 \uc57d\uac04\uc758 \ud1b5\uacc4\uc815\ubcf4 \ubcc0\uacbd\uc73c\ub85c Execution Plan \uc774 \ubc14\ub014 \uc218 \uc788\uace0, \ub610\ud55c \uadf8\uac83\uc774 \ud56d\uc0c1 \ucd5c\uc120\uc774\ub77c\uace0 \ub2e8\uc815\uc9d3\uae30 \uc5b4\ub824\uc6b8 \ubfd0 \uc544\ub2c8\ub77c, Execution Plan \ubcc0\uacbd\uc5d0 \ub530\ub77c Application \uc218\ud589 \uc2dc\uac04 \uc608\uce21\uc774 \uc5b4\ub835\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud604\uc7ac\uae4c\uc9c0 \uc218\ub9ce\uc740 \ud504\ub85c\uadf8\ub7a8\ub4e4\uc5d0 \ub300\ud574 \ud29c\ub2dd\uc774 \uc774\ub8e8\uc5b4\uc84c\uc73c\uba70, \ub610\ud55c \uc911\uc694\ud55c Job \ub4e4\uc5d0 \ub300\ud55c \ud29c\ub2dd\uc774 \ub300\ubd80\ubd84 \uc644\ub8cc\ub418\uc5b4 \uc804\ubc18\uc801\uc73c\ub85c \uac00\ub3d9\uacc4 \uc2dc\uc2a4\ud15c\uc740 \uc548\uc815\ud654 \ub418\uc5c8\ub2e4\uace0 \ud310\ub2e8\ub41c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub530\ub77c\uc11c, \ud604\uc7ac\uc758 DATA (2002. 01) \ub97c \uae30\uc900\uc73c\ub85c \uc804\uccb4 Table\uc5d0 \ub300\ud574 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud55c \ud6c4 \ud1b5\uacc4\uc815\ubcf4\ub97c Fix   \uc2dc\ud0a8\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ucd94\uac00\ub418\ub294 Table  \ubc0f \uc778\ub371\uc2a4,   \ud2b9\ubcc4\ud55c DDL  \uc791\uc5c5, Oracle Patch \uc791\uc5c5\uc5d0 \uc758\ud55c Object\ubcc0\uacbd, \ucca0\uc800\ud55c \ubd84\uc11d\uc5d0 \uc758\ud574 \uac80\uc99d\ub41c Table \ubc0f Column \uc5d0 \ud55c\ud574 \uc608\uc678\uc801\uc73c\ub85c \ud574\ub2f9 Table \ubc0f \uc778\ub371\uc2a4, \uceec\ub7fc\uc5d0 \ub300\ud574 \uc0c8\ub85c\uc6b4 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\ub294 \uac83\uc744 \uc6d0\uce59\uc73c\ub85c \ud55c\ub2e4..<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub2e8, \ud604\uc7ac \ucc44\ucde8\ud55c \ud1b5\uacc4\uc815\ubcf4\ub294 \ucc28\ud6c4 \uc804\ubc18\uc801\uc778 DATA SIZE \ubc0f \ubd84\ud3ec\uc758 \ubcc0\ub3d9\uc774 \uc608\uc0c1\ub418\ub294 \uc2dc\uc810\uc5d0 \uc804\uccb4 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc7ac \uc0dd\uc131\ud558\uc5ec Application \uc131\ub2a5\uc744 \uac80\uc99d\ud55c \ud6c4 \uc0c8\ub85c\uc6b4 \ud1b5\uacc4\uc815\ubcf4\ub85c \ub300\uccb4\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uae30\ubcf8 \uc815\ucc45 :  \uc804\uccb4 \ud1b5\uacc4\uc815\ubcf4 Fix<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">2002. 01. xx \uc5d0 \uac00\ub3d9\uacc4 DB \uc758 \ubaa8\ub4e0 Table \uc5d0 \ub300\ud574 \uc0dd\uc131\ud55c \ud1b5\uacc4\uc815\ubcf4\ub97c Backup \ud55c\ub2e4. \ub610\ud55c \ub300\ub7c9\uc758 \ub370\uc774\ud130 \ubcc0\ud654\uac00 \uc788\ub294 \uc2dc\uc810 \uc804\ubc18\uc801\uc778 Table \uc758 \uad6c\uc870 \ubcc0\ud654\uac00 \uc788\ub294 \uc2dc\uc810\uc5d0 \uc804\uccb4 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc7ac \uc0dd\uc131\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Backup  \uc815\ubcf4\ub97c \ud1b5\ud574 \ud5a5\ud6c4 \ud1b5\uacc4\uc815\ubcf4 \uc774\uc0c1 \uc2dc \ud574\ub2f9 Table  \uc5d0 \ub300\ud574  \ud1b5\uacc4\uc815\ubcf4\ub97c IMPORT \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc608\uc678  1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(<span style=\"color:red\">SYS, SYSTEM Schema  \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \uae08\uc9c0<\/span>)<br \/>\n<\/span><\/p>\n<p><span style=\"color:red; font-family:\ub3cb\uc6c0\uccb4\">SYS, SYSTEM Schema \ub294 \uc808\ub300 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\uc9c0 \ub9d0\uc544\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0dd\uc131\ud588\ub2e4\uba74 \ud655\uc778 \ud6c4 \ubc18\ub4dc\uc2dc \uc0ad\uc81c\ud574 \uc8fc\uc5b4\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Temporary Table\uc740 Table \ud2b9\uc131 \uc0c1 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud558\uc9c0 \uc54a\ub294\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc608\uc678 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;( \uc0c8\ub85c\uc6b4 Table \uc0dd\uc131, \uc0c8\ub85c\uc6b4 Index \uc0dd\uc131 )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud574\ub2f9 Table  \uc5d0 \ub300\ud574\uc11c\ub9cc \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \ubc0f \ud574\ub2f9 Table  \ud1b5\uacc4\uc815\ubcf4\ub97c \uae30\uc874<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Backup  \ubcf8\uc5d0 \ucd94\uac00\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc608\uc678  3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(  Table  Definition  \ubcc0\uacbd \uc2dc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud574\ub2f9 Table\uc758 \uceec\ub7fc\uc5d0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\ub300\ud574\uc11c\ub9cc \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \ubc0f \ud574\ub2f9 Table  \ud1b5\uacc4\uc815\ubcf4\ub97c \uae30\uc874 Backup   \ubcf8\uc5d0 \ucd94\uac00\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">( \uac80\uc99d\uc774 \uac00\ub2a5\ud558\ub2e4\uba74 \uac00\ub2a5\ud55c Table \uc804\uccb4(table, index, histogram)\uc5d0 \ub300\ud574 \uc218\ud589\ud558\ub294 \uac83\uc774 \uc88b\ub2e4. )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc608\uc678 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;( Patch \uc5d0 \uc758\ud55c Table \uc815\ubcf4 \ubcc0\uacbd \uc2dc )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc704 \uc608\uc6781,   \uc608\uc6782&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Case  \ub97c \uc801\uc6a9\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Sampling \ubc29\ubc95<br \/>\n<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze \uc218\ud589 \uc2dc Compute statistics  \ubc29\ubc95\uc73c\ub85c \ud558\uac8c \ub418\uba74, \uc804\uc218 \uac80\uc0ac \ubc29\uc2dd\uc774 \ub418\ubbc0\ub85c \uc804 Table \uc5d0 \ub300\ud574 Full Scan\uc744 \uae30\ubcf8\uc73c\ub85c \uc218\ud589\ud558\uac8c \ub418\uc5b4 \ub9ce\uc740 \uc2dc\uac04\uc774 \uc18c\uc694\ub41c\ub2e4. \ub530\ub77c\uc11c, \uc801\uc808\ud55c Sampling \uae30\uc900\uc744 \uc815\ud574 Sampling \ubc29\ubc95\uc73c\ub85c \uc218\ud589\ud55c\ub2e4. \ub2e4\ub9cc, \uc77c\ubd80 \uac80\uc99d\ub41c Table \ubc0f \ud1b5\uacc4\uc815\ubcf4\uc5d0 \ubbfc\uac10\ud55c Table \uc5d0 \ub300\ud574\uc11c\ub294 \uc608\uc678 \uc0ac\ud56d\uc744 \ubc18\uc601\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p style=\"margin-left: 27pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;99 percent Sampling<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc774\uc804 Analyze \uc790\ub8cc\uc5d0 \uc758\ud574 (dba_tables.num_rows) row  \uc218\uac00 10\ub9cc \uac74 \ubbf8\ub9cc\uc778 Table<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">( compute statistics \ubc29\ubc95\uacfc \uac19\uc73c\ub098, \ub2e4\ub9cc \uc790\ub3d9 Script \ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 \uc774\ub807\uac8c \ucc98\ub9ac\ud568)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p style=\"margin-left: 27pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20 percent Sampling<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc774\uc804 Analyze \uc790\ub8cc\uc5d0 \uc758\ud574 (dba_tables.num_rows)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row \uc218\uac00 10\ub9cc \uac74 \uc774\uc0c1,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">100 \ub9cc\uac74 \ubbf8\ub9cc\uc778 Table<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p style=\"margin-left: 27pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10 percent Sampling<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc774\uc804 Analyze \uc790\ub8cc\uc5d0 \uc758\ud574 (dba_tables.num_rows) row  \uc218\uac00 100\ub9cc \uac74 \uc774\uc0c1, 1000\ub9cc \uac74 \ubbf8\ub9cc\uc778 Table<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p style=\"margin-left: 27pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc120\ud0dd\uc801 \uc218\ud589 ( \ub300\uc6a9\ub7c9 Table )<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc774\uc804 Analyze \uc790\ub8cc\uc5d0 \uc758\ud574 (dba_tables.num_rows) row \uc218\uac00 1000 \ub9cc \uac74 \uc774\uc0c1\uc778 Table ( \uc774\uac83\uc740 \uc218\ud589\uc2dc\uac04\uc744 \uace0\ub824\ud558\uc5ec \uacb0\uc815\ud574\uc57c \ud558\uba70, \ubcf4\ud1b5 \uc774\uc815\ub3c4\uc758 \ub370\uc774\ud130 \uac74\uc218\ub77c\uba74 \ubcf4\ud1b5 Transaction \uc131\uaca9\uc758 Table \uc774\ubbc0\ub85c \uadf8 \uad6c\uc131\ube44\uac00 \ubcc0\ub3d9\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uad73\uc774 \uc7ac \uc218\ud589\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4. \uadf8\ub7ec\ub098 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc218\ud589\ud55c\ub2e4\uba74 Sampling 5 ~ 10 percent \ub85c \ud574\uc57c \ud55c\ub2e4.)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p style=\"margin-left: 27pt\"><span style=\"color:red; font-family:\ub3cb\uc6c0\uccb4\"><strong>\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc608\uc678 1 ( 99 percent )<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud2b9\uc815 Column   \uc5d0 \ub300\ud574 \uc815\ud655\ud55c \ud1b5\uacc4\uc815\ubcf4\uac00 \ud544\uc694\ud55c \uacbd\uc6b0 Compute Statistics<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ubc29\uc2dd\uc73c\ub85c \uc218\ud589\ud55c\ub2e4. (Table  \ub2e8\uc704 \/ Column  \ub2e8\uc704 :  \ubaa9\uc801\uc5d0 \ub9de\uac8c)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uadf8\ub7ec\ub098 \uc774\uac83\uc740 \ucca0\uc800\ud55c \uac80\uc99d\uacfc \ud568\uaed8 \ud3c9\uc18c \ub300\uc0c1 List \ub97c \uad00\ub9ac\ud574\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Example&gt; WIP_DISCRETE_JOBS      (costed_type),<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">WIP_OPERATIONS(status_type)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\ub4f1<br \/>\n<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 27pt\"><span style=\"color:red; font-family:\ub3cb\uc6c0\uccb4\">\u2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc608\uc678 2 ( \ubaa8\ub4e0 \ud1b5\uacc4\uc815\ubcf4\ub97c &#8220;0&#8221; \uc73c\ub85c setting )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4\uac00 \ubaa8\ub450 0 \ub85c Setting \ub418\uc5b4 \uc788\uc5b4\uc57c \ud558\ub294 Table \uc758 \uacbd\uc6b0 \ubcc4\ub3c4 \ud655\uc778 \uc791\uc5c5 \ubc0f .\uc798\ubabb\ub41c \uacbd\uc6b0 \uc774\ud589 \uc791\uc5c5 \ud544\uc694 (  \uc8fc\ub85c Temp \/ Interface Table   )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc774\uac83\uc740 \ucca0\uc800\ud55c \uac80\uc99d\uacfc \ud568\uaed8 \ud3c9\uc18c \ub300\uc0c1 List  \ub97c \uad00\ub9ac\ud574\uc57c \ud55c\ub2e4<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Example&gt;     CST_LISTS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\ub4f1<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<ul>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \uc6b4\uc601 \ubc29\uc548<span style=\"font-size:12pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \uc2dc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\ubc95 \uc911 Table \ub2e8\uc704\uc758 Export \/ Import \ub97c \uad8c\uc7a5\ud55c\ub2e4. \uad00\ub9ac\uc0c1\uc758 \ud3b8\uc758 \ubc0f \uc6b4\uc601 \uc911 \uac1c\ubcc4 Object \ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \uc2dc \ud3b8\ub9ac\ud55c \uc7a5\uc810\uc774 \uc788\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Ex) DBMS_STATS.EXPORT_TABLE_STATS, DBMS_STATS.IMPORT_TABLE_STATS<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \uc21c\uc11c(General)<br \/>\n<\/span><\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table \uc0dd\uc131<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 Export<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table\uc744 EXPORT Utility\ub97c \ud65c\uc6a9\ud558\uc5ec OS file\ub85c dump<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">FTP \ub97c \uc774\uc6a9\ud574 \uc6d0\ud558\ub294 \uc774\ud589 \ub300\uc0c1 DB\uc5d0 dump file \uc804\uc1a1<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \ub300\uc0c1 DB\uc5d0 \uc704 dump file\uc744 IMPORT Utility\ub97c \uc774\uc6a9\ud574 Import<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 Import<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ucd5c\uc885 \ud655\uc778<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table \uc0ad\uc81c<br \/>\n<\/span><\/li>\n<\/ul>\n<p style=\"margin-left: 27pt\">&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \uc21c\uc11c<br \/>\n<\/span><\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">MASTER DB Cloning<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc804 Table\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc815\uc0c1 \uc0dd\uc131 \uc5ec\ubd80 \ud655\uc778 \ubc0f \uc870\uce58<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table \uc0dd\uc131<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 Export<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc815\uc0c1 Export \uc5ec\ubd80 \ud655\uc778 \ubc0f \uc870\uce58<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \ubcc0\uacbd\uc5d0 \uc758\ud55c \uac01\uc885 Program \ubc0f Application Plan \uc810\uac80<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table\uc744 EXPORT Utility\ub97c \ud65c\uc6a9\ud558\uc5ec OS file\ub85c dump<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">FTP \ub97c \uc774\uc6a9\ud574 \uc6d0\ud558\ub294 \uc774\ud589 \ub300\uc0c1 DB \uc5d0 dump file \uc804\uc1a1<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">MASTER DB \ud604\uc7ac \ud1b5\uacc4\uc815\ubcf4 Export<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589 \ub300\uc0c1 DB\uc5d0 \uc704 dump file\uc744 IMPORT Utility\ub97c \uc774\uc6a9\ud574 Import<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 Import<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 Import \ud6c4 \uc815\uc0c1 \uc5ec\ubd80 \ud655\uc778( -&gt; \uac1c\ubcc4 analyze \uc870\uce58)<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ucd5c\uc885 \ud655\uc778 (\uac01 Application \uc810\uac80)<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table \uc0ad\uc81c<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \ubc29\ubc95<span style=\"font-size:12pt\"><br \/>\n\t\t\t\t\t<\/span><\/strong><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \uc2dc \uae30\ubcf8 Command ANALYZE \/ DBMS_STATS \ub97c \uc0ac\uc6a9\ud558\uc9c0\ub9cc, ERP<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc758 \uacbd\uc6b0 \ud2b9\ubcc4\ud788 FND_STATS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PACKAGE \ub97c \ud65c\uc6a9\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc624\ub77c\ud074 ERP\uc758 \uacbd\uc6b0 FND_STATS PACKAGE \ub294 Table , Index , Column  \ubc0f ERP \uc5d0\uc11c \ubbf8\ub9ac \uc815\uc758\ub41c Histogram \uc0dd\uc131 \ub300\uc0c1 Column \uc5d0 \ub300\ud55c Histogram \uc815\ubcf4\ub97c \uc0dd\uc131\ud560 \ubfd0 \uc544\ub2c8\ub77c \ud1b5\uacc4\uc815\ubcf4\uc5d0 \ub300\ud55c History \ub3c4 \uad00\ub9ac\ud558\ub294\ub370 FND_STATS PACKAGE \uac00 \uc790\ub3d9\uc73c\ub85c \ud655\uc778 \ud6c4 \uc218\ud589\ud55c\ub2e4. \ub9cc\uc57d \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \uc791\uc5c5\uc744 &lt;analyze&gt; command \ub97c \uc774\uc6a9\ud574 manual \ud558\uac8c \ud55c\ub2e4\uba74, \ud2b9\ud788 Histogram \ub300\uc0c1 \uceec\ub7fc \uc815\ubcf4\ub97c \ubc18\ub4dc\uc2dc \ud655\uc778 \ud6c4 \ubcc4\ub3c4\ub85c Histogram \uc815\ubcf4\ub97c \uc0dd\uc131\ud574\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uacb0\ub860\uc801\uc73c\ub85c, \uc804\uccb4 DB \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131 \uc2dc \ubc18\ub4dc\uc2dc DBMS_STATS PACKAGE  \ub97c \ud65c\uc6a9\ud558\ub294 \uac83\uc774 Manual  \uc5d0 \uc758\ud55c \uc2e4\uc218\ub97c \uc904\uc77c \uc218 \uc788\ub2e4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uadf8\ub7ec\ub098, \uc815\ud655\ud788 \uc218\ud589\ub9cc \ud55c\ub2e4\uba74 \ud1b5\uacc4\uc815\ubcf4 \uc790\uccb4\ub294 \ucc28\uc774\uac00 \uc5c6\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">DBMS_STATS \ud65c\uc6a9<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>DBMS_STATS.GATHER_TABLE_STATS ( Table <\/strong>\ub2e8\uc704 \uc791\uc5c5 <strong>)<\/strong><\/span>\n\t\t<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc8fc\uc694 \ud30c\ub77c\ubbf8\ud130<\/span>\n\t\t\t<\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Owner : Analyze \ub300\uc0c1 Table\uc758 Owner<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Tabname : Analyze \ub300\uc0c1 Table \uba85<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Percent : Analyze Estimate \uc2dc Sampling \ube44\uc728<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Degree : Analyze \uc2dc\uc758 Parallel Degree<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc8fc\uc694 \uc791\uc5c5<\/span>\n\t\t\t<\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uceec\ub7fc\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4 \ud68d\ub4dd \ubc0f \ubcc0\uacbd<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uc778\ub371\uc2a4\uc5d0 \ub300\ud574 ANALYZE \uc218\ud589<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 ANALYZE FOR TABLE\uc744 \uc218\ud589<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub418\uba74\uc11c, Histogram \uc0dd\uc131\ub300\uc0c1 column\uc5d0 \ub300\ud55c Histogram \uc0dd\uc131<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0ac\uc6a9 \uc608<\/span>\n\t\t\t<\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">dbms_stats.gather_table_stats     (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ownname=&gt;&#8217;BOM&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">,  tabname=&gt;&#8217;CST_STD_COST_ADJ_VALUES&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">,  estimate_percent=&gt;10<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">, degree=&gt;1);<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\">&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>DBMS_STATS.       GATHER_SCHEMA_STATS    ( SCHEMA  \ub2e8\uc704 \uc791\uc5c5 )<\/strong><\/span>\n\t\t<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc8fc\uc694 \ud30c\ub77c\ubbf8\ud130<\/span>\n\t\t\t<\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Schema name : Analyze \ub300\uc0c1 Schema<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Estimate Percent : Analyze Estimate \uc2dc Sampling \ube44\uc728<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Degree : Analyze \uc2dc\uc758 Parallel Degree<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc8fc\uc694 \uc791\uc5c5(\uc544\ub798 \uc791\uc5c5\uc744 \ud574\ub2f9 Schema \uc804 Table\uc5d0 \ub300\ud574 \uc218\ud589)<\/span>\n\t\t\t<\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uceec\ub7fc\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc815\ubcf4 \ud68d\ub4dd \ubc0f \ubcc0\uacbd<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uc778\ub371\uc2a4\uc5d0 \ub300\ud574 ANALYZE \uc218\ud589<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc5d0 \ub300\ud574 ANALYZE FOR TABLE\uc744 \uc218\ud589<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub300\uc0c1 \ud14c\uc774\ube14\uc5d0 \ud3ec\ud568\ub418\uba74\uc11c Histogram \uc0dd\uc131 \ub300\uc0c1 Column\uc5d0 \ub300\ud55c Histogram \uc0dd\uc131<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0ac\uc6a9 \uc608<\/span>\n\t\t\t<\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">dbms_stats.gather_schema_stats ( schemaname =&gt;&#8217;BOM&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">, estimate_percent =&gt;10<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">, degree =&gt;1);<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>DBMS_STATS.   GATHER_COLUMN_STATS    ( Column  \ub2e8\uc704 \uc791\uc5c5 )<\/strong><\/span>\n\t\t<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc8fc\uc694 \ud30c\ub77c\ubbf8\ud130<\/span>\n\t\t\t<\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">COLNAME<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PERCENT<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">DEGREE<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">HSIZE<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">BACKUP_FLAG<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0ac\uc6a9 \uc608<\/span>\n\t\t\t<\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Exec    dbms_stats.gather_column_stats ( ownname=&gt;&#8217;APPS&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">, tabname=&gt;&#8217;T1&#8242;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">,colname=&gt;&#8217;A&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">,percent=&gt;99<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">,degree=&gt;1<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 162pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">,hsize=&gt;254);<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">ANALYZE \ud65c\uc6a9<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>Table<\/strong><\/span>\n\t\t<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc8fc\uc758 \uc0ac\ud56d : Partition Table \uc5d0 \ub300\ud574 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc0dd\uc131\ud560 \ub54c\uc5d0\ub294 \ubc18\ub4dc\uc2dc Table \uc774\ub984\uc73c\ub85c analyze \ub97c \ud574\uc57c \uac01 partition table \ubc0f Parent table \uc5d0 \ub300\ud574\uc11c \ud55c\ub2e4. Partition table \uc5d0 \ub300\ud574\uc11c\ub9cc \ud560 \uacbd\uc6b0 \ud574\ub2f9 Partition \ud1b5\uacc4\uc815\ubcf4\ub9cc \uc0dd\uc131\ub41c\ub2e4.<\/span>\n\t\t<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0ac\uc6a9 \uc608<\/span>\n\t\t\t<\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wip.wip_discrete_jobs compute statistics ;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bom.cst_item_cost_details partition (p1) compute statistics<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wip.wip_discrete_jobs estimate statistics sample 20 percent ;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wip.wip_discrete_jobs estimate statistics sample 10000 rows ;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wip.wip_discrete_jobs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delete statistics ;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>Index<\/strong><\/span>\n\t\t<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0ac\uc6a9 \uc608<\/span>\n\t\t\t<\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table wip.wip_discrate_jobs compute statistic for all indexes;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze index wip.wip_discreate_jobs_u1 compute statistics;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze index wip.wip.discreate_jobs_u1 estimate statistic sample 20 percent;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze index wip.wip_discreate_jobs_u1 delete statistics;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>Column(histogram \uc0dd\uc131 : default bucket size = 75, max = 254, min=1 )<\/strong><\/span>\n\t\t<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc0ac\uc6a9 \uc608<\/span>\n\t\t\t<\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table wip.wip_discreate_jobs compute statistics for all columns;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table wip.wip_discreate_jobs compute statistics for all columns size 75;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table wip.wip_discreate_jobs compute statistics for all indexed columns size 254;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table wip.wip_discreate_jobs compute statistics for columns status_type size 254;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table wip.wip_discreate_jobs compute statistics for columns status_type, class_code size 254;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"color:red\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\uc8fc\uc758 \uc0ac\ud56d<\/strong><\/span><br \/>\n\t\t\t\t<\/span><\/div>\n<ul style=\"margin-left: 54pt\">\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table\uc744 \uc218\ud589\ud558\uba74<br \/>\n<\/span><\/div>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uae30\uc874\uc758 \ud1b5\uacc4\uc815\ubcf4\ub294 \uc0c8\ub85c\uc6b4 \ud1b5\uacc4\uc815\ubcf4\ub85c \ubc14\ub00c\uba70 Histogram \uc815\ubcf4\ub3c4 \ubaa8\ub450 \uc5c6\uc5b4\uc9c4\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\ub530\ub77c\uc11c, Histogram\uc744 \uc7ac \uc0dd\uc131\ud574\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze table .. For columns\ub97c \uc218\ud589\ud558\uba74<br \/>\n<\/span><\/div>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uae30\uc874\uc758 \ud1b5\uacc4\uc815\ubcf4\ub294 \uadf8\ub300\ub85c \uc788\uace0, \ud574\ub2f9 \uceec\ub7fc\uc5d0 \ub300\ud55c Histogram \uc815\ubcf4\ub9cc \uacc4\uc18d \ucd94\uac00 \ub41c\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">IOT Table\uc758 \uacbd\uc6b0 \ud1b5\uacc4\uc815\ubcf4 \uc911 Block \uc815\ubcf4\ub294 Null \uac12\uc774 \ub41c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Partitioned Table\uc758 \uacbd\uc6b0 \uac00\ub054 index\uac00 Analyze \ub418\uc9c0 \uc54a\ub294 \uc624\ub958 \ubc1c\uc0dd(\ud56d\uc0c1 \uadf8\ub807\uc9c0\ub294 \uc54a\uc74c, \ud56d\uc0c1 \ud655\uc778 \ud544\uc694)<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Analyze index \ub97c \ud560 \uacbd\uc6b0<br \/>\n<\/span><\/div>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\uc774\uac83\uc740 \uc778\ub371\uc2a4 \ud1b5\uacc4\uc815\ubcf4\ub9cc\uc744 \ubc14\uafbc\ub2e4. Table \ubc0f Column, Histogram \uc815\ubcf4\ub294 \uc804\ud600 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\ub294\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\">Index type \uc911 LOB, DOMAIN type\uc740 \ud1b5\uacc4\uc815\ubcf4 \ud655\uc778 \uc2dc \ubcc4\ub3c4\uc758 check routine\uc774 \ud544\uc694\ud558\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<ul>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc774\ud589<span style=\"font-size:12pt\"><br \/>\n\t\t\t\t\t<\/span><\/strong><\/span><\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table \uc0dd\uc131<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC   DBMS_STATS.CREATE_STAT_TABLE  (  ownname,    stattab,    tblspace  )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.CREATE_STAT_TABLE ( &#8216;APPS&#8217;,    &#8216;STAT_TEMP&#8217;,    &#8216;SKK&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TBLSPACE : \uc0ac\uc6a9\ud560 TABLESPACE, \uc5ec\uc720 \uc788\ub294 \uc784\uc758\uc758 T.S \uc9c0\uc815<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc800\uc7a5 Table \uc0ad\uc81c<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC  DBMS_STATS.  DROP  _STAT_TABLE  (  ownnae,    stattab)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.DROP_STAT_TABLE ( &#8216;APPS&#8217;,    &#8216;STAT_TEMP&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE \uba85<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Export(Schema)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS. EXPORT_SCHEMA_STATS ( ownname, stattab, statid, statown)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.EXPORT_SCHEMA_STATS ( &#8216;BOM&#8217;,&#8217;STAT_TEMP&#8217;,&#8217;BOM&#8217; ,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 SCHEMA\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) EKS, INDEX\uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131 \uc788\uac8c \uc124\uc815<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Export(Table)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.EXPORT_TABLE_STATS ( ownname, tabname, partname, stattab, statid, cascade, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.EXPORT_TABLE_STATS(&#8216;BOM&#8217;,&#8217;CST_LISTS&#8217;,&#8221;,&#8217;STAT_TEMP&#8217;, &#8216;CST_LISTS&#8217;, TRUE,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8,  INDEX \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131 \uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE : \uc778\ub371\uc2a4, \uceec\ub7fc, HISTOGRAM \ud3ec\ud568 \uc5ec\ubd80<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Export(Index)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.EXPORT_INDEX_STATS ( ownname, indname, partname, stattab, statid, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.EXPORT_INDEX_STATS(&#8216;BOM&#8217;,&#8217;CST_LISTS_U1&#8242;,&#8221;,&#8217;STAT_TEMP&#8217;, &#8216;CST_LISTS&#8217;,&#8217;APPS&#8217; )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">INDNAME : \ub300\uc0c1 INDEX\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Export(Column)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.EXPORT_COLUMN_STATS ( ownname, tabname, colname, partname, stattab, statid, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.EXPORT_COLUMN_STATS(&#8216;BOM&#8217;,&#8217;CST_LISTS&#8217;,&#8217;LIST_ID&#8217;,&#8217;STAT_TEMP&#8217;,&#8217;CST_LISTS&#8217;,&#8217;APPS&#8217; )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE \uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">COLNAME : \ub300\uc0c1 COLUMN\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Import(Schema)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS. IMPORT_SCHEMA_STATS ( ownname, stattab, statid, statown)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">== &gt; EXEC DBMS_STATS.IMPORT_SCHEMA_STATS   (&#8216;BOM&#8217;,&#8217;STAT_TEMP&#8217;,&#8221;,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Import(Table)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.IMPORT_TABLE_STATS ( ownname, tabname, partname, stattab, statid, cascade, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac DBMS_STATS.IMPORT_TABLE_STATS(&#8216;BOM&#8217;,&#8217;CST_LISTS&#8217;,&#8221;,&#8217;STAT_TEMP&#8217;, &#8216;CST_LISTS&#8217;, TRUE,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8,  INDEX \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131 \uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE : \uc778\ub371\uc2a4, \uceec\ub7fc, HISTOGRAM \ud3ec\ud568 \uc5ec\ubd80<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Import(Index)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.IMPORT_INDEX_STATS ( ownname, indname, partname, stattab, statid, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.IMPORT_INDEX_STATS(&#8216;BOM&#8217;,&#8217;CST_LISTS_U1&#8242;,&#8221;,&#8217;STAT_TEMP&#8217;, &#8216;CST_LISTS&#8217;, &#8216;APPS&#8217; )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">INDNAME : \ub300\uc0c1 INDEX\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Import(Column)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.IMPORT_COLUMN_STATS ( ownname, tabname, colname, partname, stattab, statid, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.IMPORT_COLUMN_STATS<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">(&#8216;BOM&#8217;,&#8217;CST_LISTS&#8217;,&#8217;LIST_ID&#8217;,&#8221;,&#8217;STAT_TEMP&#8217;,&#8217;CST_LISTS&#8217;,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE \uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">COLNAME : \ub300\uc0c1 COLUMN\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Delete(Schema)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.DELETE_SCHEMA_STATS ( ownname, stattab, statid, statown)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.DELETE_SCHEMA_STATS ( &#8216;BOM&#8217;,&#8217;STAT_TEMP&#8217;,&#8217;BOM&#8217; ,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Delete(Table)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.DELETE_TABLE_STATS<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 54pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">( ownname, tabname, partname, stattab, statid, cascade_part, cascade_column, cascade_indexes, statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac  EXEC  DBMS_STATS.DELETE_TABLE_STATS<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">(&#8216;BOM&#8217;,&#8217;CST_LISTS&#8217;,&#8221;,&#8217;STAT_TEMP&#8217;,&#8217;CST_LISTS&#8217;,TRUE,TRUE,TRUE,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE \uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE_PART : \uc778\ub371\uc2a4, \uceec\ub7fc, HISTOGRAM \ud3ec\ud568 \uc5ec\ubd80<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE_COLUMNS : DELETE_COLUMN_STATS \ud638\ucd9c<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE_INDEXES : DELETE_INDEX_STATS \ud638\ucd9c<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Delete(Index)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC DBMS_STATS.DELETE_INDEX_STATS ( ownname, indname, partname, stattab, statid, cascade_parts, statown)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.DELETE_INDEX_STATS(&#8216;BOM&#8217;,&#8217;CST_LISTS_U1&#8242;,&#8221;,&#8217;STAT_TEMP&#8217;,&#8217;CST_LISTS&#8217;,TRUE,&#8217;APPS&#8217;)<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE \uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE_PART : \uc778\ub371\uc2a4, \uceec\ub7fc, HISTOGRAM \ud3ec\ud568 \uc5ec\ubd80<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 Delete(Column)<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">EXEC   DBMS_STATS.DELETE_COLUMN_STATS<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">( ownname,tabname,colname,partname,stattab,statid,cascade_parts,statown )<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">\u20ac EXEC DBMS_STATS.DELETE_COLUMN_STATS<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 189pt\"><span style=\"font-family:\ub3cb\uc6c0\uccb4\">(&#8216;BOM&#8217;,&#8217;CST_LISTS&#8217;,&#8217;LIST_ID&#8217;,&#8221;,&#8217;STAT_TEMP&#8217;,&#8217;CST_LISTS&#8217;,TRUE,&#8217;APPS&#8217; )<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">OWNNAME : \ub300\uc0c1 TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">TABNAME : \ub300\uc0c1 TABLE \uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">COLNAME : \ub300\uc0c1 COLUMN\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">PARTNAME : PARTITION\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATTAB : STAT TABLE\uba85<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATID : STAT_ID(\uc784\uc758\uc758 \uac12 \uc124\uc815) \ub2e8, INDEX \uc758 \uccab \uceec\ub7fc\uc774\ubbc0\ub85c \ud65c\uc6a9\uc131\uc788\uac8c \uc124\uc815(EX, TABLE\uba85 \ub4f1)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">CASCADE_PART : \uc778\ub371\uc2a4, \uceec\ub7fc, HISTOGRAM \ud3ec\ud568 \uc5ec\ubd80<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">STATOWN : STAT TABLE\uc758 OWNER<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>\ud1b5\uacc4\uc815\ubcf4 \uc0dd\uc131(Analyze) \ud6c4 \ud655\uc778 Script<span style=\"font-size:12pt\"><br \/>\n\t\t\t\t\t<\/span><\/strong><\/span><\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>Table \ud1b5\uacc4\uc815\ubcf4 \uc815\uc0c1 \uc720\ubb34 \ud655\uc778 &#8211; \ud1b5\uacc4\uc815\ubcf4\uac00 \uc5c6\uc744 \uc2dc \uc18c\ubb38\uc790 \uceec\ub7fc\uc758 \uc870\ud68c \uacb0\uacfc\uac00 \ub098\uc624\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">select OWNER, TABLE_NAME,PARTITIONED, LAST_ANALYZED, num_rows, chain_cnt, avg_space, avg_row_len from dba_tables where owner like &#8216;%SCOTT%&#8217;;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<\/li>\n<li>\n<div><span style=\"font-family:\ub3cb\uc6c0\uccb4\"><strong>Index \ud1b5\uacc4\uc815\ubcf4 \uc815\uc0c1 \uc720\ubb34 \ud655\uc778 &#8211; \uc778\ub371\uc2a4 \ubc0f \ud30c\ud2f0\uc154\ub2dd \uc778\ub371\uc2a4 \uad00\ub828 \ud655\uc778<br \/>\n<\/strong><\/span><\/div>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">select table_name, index_name, status, PARTITIONED, LAST_ANALYZED, num_rows, leaf_blocks, blevel<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\"> from dba_indexes where owner = &#8216;SCOTT&#8217;;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">select INDEX_OWNER,INDEX_NAME,PARTITION_NAME,LAST_ANALYZED,NUM_ROWS,LEAF_BLOCKS,BLEVEL<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">from dba_ind_partitions where index_owner = &#8216;SCOTT&#8217;;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">select INDEX_OWNER,INDEX_NAME,PARTITION_NAME,LAST_ANALYZED,NUM_ROWS,LEAF_BLOCKS,BLEVEL<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4\">from DBA_IND_SUBPARTITIONS where index_owner = &#8216;SCOTT&#8217;;<br \/>\n<\/span><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"font-family:\ub3cb\uc6c0\uccb4; font-size:10pt\">&nbsp;<br \/>\n<\/span>&nbsp;<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ud1b5\uacc4\uc815\ubcf4 \uac1c\uc694 \ud1b5\uacc4\uc815\ubcf4 \ud1b5\uacc4\uc815\ubcf4\ub294 \ud574\ub2f9 Table \ubc0f Index,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Column \uc5d0 \ub300\ud55c \ud1b5\uacc4\uce58\ub85c\uc11c Optimizer \uac00 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 Execution plan \uc744 \uc218\ub9bd\ud558\uae30 \uc704\ud574 \ucd5c\uc18c\ube44\uc6a9\uc744 \uacc4\uc0b0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 \uc815\ubcf4\uc774\ub2e4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\ub610\ud55c Object\uad6c\uc870 \ubc0f Chain\uc815\ubcf4\ub3c4 \uc81c\uacf5\ud55c\ub2e4. &nbsp; &nbsp; COST Based Optimizer \uc758 \uacbd\uc6b0 \ud2b9\ubcc4\ud55c \ubaa9\uc801\uc744 \uc81c\uc678\ud558\uace0\ub294 \ubc18\ub4dc\uc2dc \ud1b5\uacc4\uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\uc5b4\uc57c Optimizer \uac00 \uac00\ub2a5\ud55c \uc815\ud655\ud55c Execution Plan \uc744 \uc0dd\uc131\ud558\uac8c \ub41c\ub2e4. &nbsp; &nbsp; \uc608\ub97c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[326,162],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/710"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=710"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/710\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=710"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}