{"id":1603,"date":"2018-01-23T18:42:56","date_gmt":"2018-01-23T09:42:56","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1603"},"modified":"2018-01-23T18:48:27","modified_gmt":"2018-01-23T09:48:27","slug":"oracle-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4%ec%9d%98-%ed%86%b5%ea%b3%84%ec%a0%95%eb%b3%b4","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1603","title":{"rendered":"Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud1b5\uacc4\uc815\ubcf4"},"content":{"rendered":"<h2>Oracle Enhanced Statistics Gathering<br \/>\n<\/h2>\n<p style=\"text-align: justify; margin-left: 17pt\">Cost-Based Optimizer(CBO)\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud1b5\uacc4 \uc815\ubcf4\uc5d0 \uc758\uc874\ud569\ub2c8\ub2e4.  \ub530\ub77c\uc11c, CBO\uac00 \uc815\ud655\ud55c \uc2e4\ud589 \uacc4\ud68d(Execution Plan)\uc744 \uc0dd\uc131\ud558\ub3c4\ub85d \ud558\ub824\uba74, \uc0ac\uc6a9\uc790\ub294 CBO\ub97c \uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 SQL \ubb38\uc5d0\uc11c \uc811\uadfc\ud558\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14, \uc778\ub371\uc2a4, \ud074\ub7ec\uc2a4\ud130 \ub4f1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0dd\uc131\ud574 \ub450\uc5b4\uc57c \ud569\ub2c8\ub2e4.  \ub9cc\uc57d, \ud14c\uc774\ube14\uc758 \ud06c\uae30\ub098 \ub370\uc774\ud130 \ubd84\ud3ec\uac00 \uc790\uc8fc \ubcc0\uacbd\ub41c\ub2e4\uba74, \ud1b5\uacc4 \uc815\ubcf4\uc758 \uc815\ud655\uc131\uc744 \uc704\ud574 \uc0ac\uc6a9\uc790\ub294 \uc8fc\uae30\uc801\uc73c\ub85c \uad00\ub828 \uac1d\uccb4\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0dd\uc131\ud574 \ub450\uc5b4\uc57c \ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 17pt\">Oracle \uc5d0\uc11c\ub294 \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131 \uc2dc \ub370\uc774\ud130\uc758 \uc0d8\ud50c \ud06c\uae30\ub97c \uc790\ub3d9\uc73c\ub85c \uc9c0\uc815\ud574 \uc8fc\ub294 \uae30\ub2a5, CPU\uc640 I\/O \ub4f1\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c Cost-Based Optimizer\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\ub4e4\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 17pt\">Oracle \uc5d0 \uc0c8\ub86d\uac8c \ucd94\uac00\ub41c \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1 \uad00\ub828 \uae30\ub2a5\uacfc \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4 \ubcf4\ub3c4\ub85d \ud569\ub2c8\ub2e4\n<\/p>\n<p style=\"text-align: justify; margin-left: 17pt\">\n\u00a0<\/p>\n<p style=\"background: black\">\n\u00a0<\/p>\n<h3>New Gathering Statistics Estimation<br \/>\n<\/h3>\n<p style=\"text-align: justify; margin-left: 17pt\">\uc815\ud655\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0dd\uc131(CUMPUTE STATISTICS)\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud544\uc694\ud55c \uac1d\uccb4\uc5d0 \ub300\ud55c \uac80\uc0c9 \ubc0f \uc815\ub82c \uc791\uc5c5 \ub54c\ubb38\uc5d0 \ub9ce\uc740 \uc591\uc758 \ub514\uc2a4\ud06c\/\uba54\ubaa8\ub9ac \uacf5\uac04\uacfc \uc2dc\uac04\uc744 \ud544\uc694\ub85c \ud569\ub2c8\ub2e4.   \ub530\ub77c\uc11c, \uacf5\uac04 \ub0ad\ube44\uc640 \uc2dc\uac04\uc744 \uc904\uc774\uae30 \uc704\ud558\uc5ec \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131 \uc2dc \uc0d8\ud50c\ub9c1 \uae30\ubc95(ESTIMATE STATISTICS)\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.  \ud558\uc9c0\ub9cc, \ucd5c\uc801\uc758 \uc0d8\ud50c \ud06c\uae30\ub97c \uacb0\uc815\ud558\ub294 \uac83\uc740 \uc27d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 17pt\">\uc0d8\ud50c\ub9c1 \uae30\ubc95\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ud14c\uc774\ube14 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uc788\ub294 \ube14\ub85d\uc758 \uc218, \uc778\ub371\uc2a4 \uae4a\uc774(depth of index) \ub4f1\uc740 \uc815\ud655\ud558\uac8c \uacc4\uc0b0\ub418\uc9c0\ub9cc, \ubaa8\ub4e0 \ud1b5\uacc4 \uc815\ubcf4\uac00 \uc815\ud655\ud558\uac8c \uacc4\uc0b0\ub418\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4.  \ub530\ub77c\uc11c, \uc815\ud655\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub9ce\uc740 \uc591\uc758 \ub370\uc774\ud130\ub97c \uc0d8\ud50c\ub85c \uc124\uc815\ud558\uc5ec \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.  \ud558\uc9c0\ub9cc, \uc774\ub7f4 \uacbd\uc6b0 \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1 \uc2dc \uacf5\uac04 \ub0ad\ube44\uc640 \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1 \uc2dc\uac04\uc774 \uae38\uc5b4\uc9d1\ub2c8\ub2e4.  \ub610\ud55c, \ub108\ubb34 \uc801\uc740 \uc591\uc758 \uc0d8\ud50c \ud06c\uae30\ub97c \uc9c0\uc815\ud560 \uacbd\uc6b0 \uc815\ud655\ud55c \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1\uc744 \uae30\ub300\ud558\uae30 \ud798\ub4ed\ub2c8\ub2e4. Oracle \uc5d0\uc11c\ub294 \uc704\uc640 \uac19\uc740 \uc0d8\ud50c \ud06c\uae30\ub97c \uacb0\uc815\ud558\ub294 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud558\uc5ec \ud1b5\uacc4 \uc815\ubcf4 \uacc4\uc0b0\uc758 \uc815\ud655\uc131\uc744 \ub192\uc774\uba74\uc11c \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1 \uc2dc \uc0ac\uc6a9\ub418\ub294 \uacf5\uac04 \ubc0f \uc2dc\uac04\uc744 \uc808\uc57d\ud560 \uc218 \uc788\ub3c4\ub85d CBO\uac00 \uc0d8\ud50c \ud06c\uae30\ub97c \uc790\ub3d9\uc73c\ub85c \uc124\uc815\ud560 \uc218 \uc788\ub3c4\ub85d DBMS_STATS Package\uc5d0 \uc0c8\ub85c\uc6b4 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \ucd94\uac00\ud558\uc600\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 17pt\">\n\u00a0<\/p>\n<h4>ESTIMATE_PERCENT Parameter value of DBMS_STATS Package<br \/>\n<\/h4>\n<p style=\"text-align: justify; margin-left: 17pt\">Oracle \uc5d0\uc11c\ub294 \uc0d8\ud50c\uc758 \ud06c\uae30\ub97c \uc790\ub3d9\uc73c\ub85c \uacc4\uc0b0\ud574 \uc8fc\uae30 \uc704\ud55c \uc0c8\ub85c\uc6b4 \ud30c\ub77c\ubbf8\ud130 \uac12\uc774 DBMS_STATS Package\uc5d0 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.  DBMS_STATS Package\uc758 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \ud504\ub85c\uc2dc\uc800\uc758 <span style=\"color:blue\">ESTIMATE_PERCENT<\/span> \ud30c\ub77c\ubbf8\ud130 \uac12\uc73c\ub85c <span style=\"color:blue\">DBMS_STATS. AUTO_SAMPLE_SIZE<\/span> \ub77c\ub294 \uc0c8\ub85c\uc6b4 \uac12\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.  \uc774 \uac12\uc744 \uc0ac\uc6a9\ud558\uba74 \ubd80\uc815\ud655\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc5bb\uac70\ub098 \ud639\uc740 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uad6c\ud558\ub294\ub370 \ub4dc\ub294 \uc2dc\uac04\uc744 \uc904\uc774\uace0, \uc801\uc808\ud55c \ud1b5\uacc4 \uc815\ubcf4\uc758 \uc815\ud655\ub3c4\ub97c \uc720\uc9c0\ud558\uace0 \ucd5c\ub300\uc758 \uc131\ub2a5 \uc0c1\uc758 \uc774\ub4dd\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc608\ub97c \ub4e4\uc5b4 &#8220;SCOTT&#8221; \uc2a4\ud0a4\ub9c8\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud14c\uc774\ube14\uacfc \uceec\ub7fc\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uad6c\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 17pt\">\n\u00a0<\/p>\n<div style=\"margin-left: 22pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"color:blue; font-size:8pt\">EXECUTE DBMS_STATS.GET_SCHEMA_STATS( &#8216;SCOTT&#8217;, <span style=\"color:red\">DBMS_STATS.AUTO_SAMPLE_SIZE<span style=\"color:blue\"> );<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 31pt\">\n\u00a0<\/p>\n<h4>METHOD_OPT Parameter Values of DBMS_STATS Package<br \/>\n<\/h4>\n<p style=\"margin-left: 17pt\">Oracle \uc5d0\uc11c\ub294 DBMS_STATS Package\uc758 \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1 \ud504\ub85c\uc2dc\uc800\ub4e4\uc758 METHOD_OPT \ud30c\ub77c\ubbf8\ud130\uc5d0\ub3c4 \uc0c8\ub85c\uc6b4 \uac12\uc744 \ucd94\uac00\ud558\uc600\uc2b5\ub2c8\ub2e4.\n<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify\"><span style=\"font-size:10pt\"><span style=\"font-family:Times\">Size <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc808\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t\t<span style=\"color:blue\">REPEAT<\/span><\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc124\uc815\ub418\uc5b4<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\uc73c\uba74<\/span><span style=\"font-family:Times\">, <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uceec\ub7fc\uc5d0<\/span><span style=\"font-family:Times\"> Histogram<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\uc73c\uba74<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub3d9\uc77c\ud55c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc758<\/span><span style=\"font-family:Times\"> bucket<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774\uc6a9\ud558\uc5ec<\/span><span style=\"font-family:Times\"> Histogram<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0dd\uc131\ud558\uace0<\/span><span style=\"font-family:Times\">, <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uceec\ub7fc\uc5d0<\/span><span style=\"font-family:Times\"> Histogram<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5c6\uc73c\uba74<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0c8\ub86d\uac8c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0dd\uc131\ud558\uc9c0<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc54a\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.  <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc989<\/span><span style=\"font-family:Times\">, REPEAT <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc635\uc158\uc740<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub3d9\uc77c\ud55c<\/span><span style=\"font-family:Times\"> &#8220;Class&#8221;<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc758<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4\ub97c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc9d1\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.<br \/>\n<\/span><\/span><\/div>\n<\/li>\n<\/ul>\n<p>\n\u00a0<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify\"><span style=\"font-size:10pt\"><span style=\"font-family:Times\">Size<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc808\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t\t<span style=\"color:blue\">AUTO<\/span><\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc124\uc815\ub418\uc5b4<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\uc73c\uba74<\/span><span style=\"font-family:Times\">, Oracle<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc740<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub370\uc774\ud130<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd84\uc0b0<\/span><span style=\"font-family:Times\">(skew)<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uacfc<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uceec\ub7fc\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc811\uadfc\ud558\ub294<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubc29\ubc95<\/span><span style=\"font-family:Times\">(sparsity)<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uace0\ub824\ud558\uc5ec<\/span><span style=\"font-family:Times\"> Histogram<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0dd\uc131\ud560<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac83\uc778\uc9c0\ub97c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uacb0\uc815\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.  <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud558\uc9c0\ub9cc<\/span><span style=\"font-family:Times\">, <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud574\ub2f9<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uceec\ub7fc\uc5d0<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub300\ud55c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd80\ud558\ub97c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uad6c\ud558\ub294\ub370<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ucda9\ubd84\ud55c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uac04\ub3d9\uc548<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\ud589\ub418\uc9c0<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc54a\uc558\ub2e4\uba74<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc784\uc2dc\uc801\uc73c\ub85c<\/span><span style=\"font-family:Times\"> SKEWONLY <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud30c\ub77c\ubbf8\ud130<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac12\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0ac\uc6a9\ud558\ub294<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac83\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc720\uc6a9\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.<br \/>\n<\/span><\/span><\/div>\n<\/li>\n<\/ul>\n<p>\n\u00a0<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify\"><span style=\"font-size:10pt\"><span style=\"font-family:Times\">Size<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc808\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t\t<span style=\"color:blue\">SKEWONLY<\/span><\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc124\uc815\ub418\uc5b4<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\uc73c\uba74<\/span><span style=\"font-family:Times\">, Oracle<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc740<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub370\uc774\ud130\uc758<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd84\uc0b0<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ub3c4\ub9cc<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uace0\ub824\ud558\uc5ec<\/span><span style=\"font-family:Times\"> Histogram<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0dd\uc131\ud560<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac83\uc778\uc9c0\ub97c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uacb0\uc815\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.  <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc635\uc158\uc740<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ucc98\uc74c\uc73c\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4\ub97c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc9d1\ud560<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub54c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc720\uc6a9\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.  <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc989<\/span><span style=\"font-family:Times\">, <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ucda9\ubd84\ud788<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\ud589\ub418\uc9c0<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc54a\uc544<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uceec\ub7fc\uc5d0<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub300\ud55c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd80\ud558<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc790\ub8cc\uac00<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5c6\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub54c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0ac\uc6a9\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.<br \/>\n<\/span><\/span><\/div>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\uc544\ub798\uc758 \uc608\ub294 SCOTT \uc2a4\ud0a4\ub9c8\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14, \uc778\ub371\uc2a4, \uceec\ub7fc\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uad6c\ud558\ub294 \uc608\ub97c \ubcf4\uc5ec\uc900\ub2e4.  \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uba74 Oracle\uc774 Sampling Percentage\ub97c \uc5bc\ub9c8\ub85c \ud560\uc9c0, Histogram\uc774 \ud544\uc694\ud55c\uc9c0\ub97c \uacb0\uc815\ud558\uc5ec \ucc98\ub9ac\ud569\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:491px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">    Ownname =&gt; &#8216;SCOTT&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">    Estimate_percent =&gt; DBMS_STATS.AUTO_SAMPLE_SIZE,<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">    Method_opt =&gt; &#8216;for all column size AUTO&#8217; );<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"background: black\">\n\u00a0<\/p>\n<h3>Gathering System Statistics<br \/>\n<\/h3>\n<p style=\"text-align: justify; margin-left: 28pt\">Oracle \uc5d0\uc11c\ub294 Optimizer\ub294 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec \uc2dc\uc2a4\ud15c\uc758 I\/O \ubc0f CPU\uc758 \uc131\ub2a5\ub3c4 \uace0\ub824\ud558\uc5ec Plan\uc744 \uc791\uc131\ud569\ub2c8\ub2e4. Optimizer\ub294 \ubaa8\ub4e0 \uac00\ub2a5\ud55c Plan\uc5d0 \ub300\ud574 I\/O \uc640 CPU\uc758 \uc608\uc0c1 \ube44\uc6a9\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.  \ub530\ub77c\uc11c, I\/O\uc640 CPU \ube44\uc6a9\uc744 \ucd5c\uc801\ud654\ud55c \ud6a8\uc728\uc801\uc778 Plan\uc744 \uc5bb\uae30 \uc704\ud574\uc11c\ub294 \uc2dc\uc2a4\ud15c\uc758 \ud2b9\uc9d5\uc744 \uc54c\uc544 \ub0b4\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 28pt\">CPU\uc640 IO \ud2b9\uc131\uc740 \ub9ce\uc740 \uc694\uc18c\uc5d0 \uc758\ud574 \uc601\ud5a5\uc744 \ubc1b\uace0 \uc77c\uc815\ud558\uac8c \uc720\uc9c0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.  \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4 \uad00\ub9ac \uae30\ub2a5\uc744 \uc774\uc6a9\ud558\uba74, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 \uc2dc\uc2a4\ud15c\uc774 \uc77c\ubc18\uc801\uc778 \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uae30\uac04 \ub3d9\uc548\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc608\ub97c \ub4e4\uba74, \uc8fc\uac04\uc5d0\ub294 OLTP \ud2b8\ub79c\uc7ad\uc158\uc774 \uc218\ud589\ub418\uace0 \uc57c\uac04\uc5d0\ub294 OLAP \ub9ac\ud3ec\ud2b8 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4\uace0 \ud558\uc790.  \uc774\ub7f4 \uacbd\uc6b0, \uad00\ub9ac\uc790\ub294 \ud544\uc694\ud560 \uacbd\uc6b0 OLTP \uc640 OLAP \uc791\uc5c5\uc774 \ucc98\ub9ac\ub418\ub294 \ub3d9\uc548\uc758 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc774\ub807\uac8c \uc218\uc9d1\ub41c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uace0\ub824\ud558\uc5ec Optimizer\ub294 \uc0c1\ub300\uc801\uc778 \ube44\uc6a9\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 28pt\">Oracle\uc740 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0dd\uc131\ud560 \ub54c \uc8fc\uc5b4\uc9c4 \uc2dc\uac04 \ub3d9\uc548\uc758 \uc2dc\uc2a4\ud15c \ud65c\ub3d9\uc744 \ubd84\uc11d\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14, \uc778\ub371\uc2a4, \uceec\ub7fc \ub4f1\uc758 \ud1b5\uacc4 \uc815\ubcf4\uc640 \ub2ec\ub9ac \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\uac00 \ubcc0\uacbd\ub418\uc5c8\uc744 \ub54c Oracle\uc740 \uc774\ubbf8 Parse\ub41c SQL \ubb38\uc7a5\uc740 invalidate\uc2dc\ud0a4\uc9c0 \uc54a\uace0, \uc0c8\ub85c\uc6b4 SQL \ubb38\uc7a5\uc740 \ubcc0\uacbd\ub41c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec parsing\ud569\ub2c8\ub2e4.  Oracle\uc5d0\uc11c\ub294 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub3c4\ub85d \uad8c\uc7a5\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 28pt\"><span style=\"font-family:Courier New\">DBMS_STATS.GATHER_SYSTEM_STATS<\/span> \ud568\uc218\ub294 \uc0ac\uc6a9\uc790\uac00 \uc815\uc758\ud55c \uae30\uac04 \ub3d9\uc548 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4.  <span style=\"font-family:Courier New\">DBMS_STATS.SET_SYSTEM_STATS<\/span> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uba85\uc2dc\uc801\uc73c\ub85c \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4 \uac12\uc744 \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.  \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4 \uac12\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 <span style=\"font-family:Courier New\">DBMS_STATS.GET_SYSTEM_STATS<\/span> \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\n<\/p>\n<h4>DBMS_STATS Package Subprograms related to System Statistics<br \/>\n<\/h4>\n<p style=\"text-align: justify; margin-left: 39pt\">DBMS_STATS Package \uc911 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uad00\ub9ac\uc640 \uad00\ub828\ub41c \ud504\ub85c\uc2dc\uc800\ub4e4\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 39pt\">\n\u00a0<\/p>\n<h5>DBMS_STATS.GATHER_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"margin-left: 17pt\">\uc774 \ud568\uc218\ub294 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 17pt\"><strong><em>Syntax<br \/>\n<\/em><\/strong><\/p>\n<p style=\"margin-left: 17pt\"><span style=\"font-family:Courier New\">DBMS_STATS.GATHER_SYSTEM_STATS (<br \/>    gathering_mode  VARCHAR2 DEFALUT &#8216;INTERVAL&#8217;,<br \/>    interval        INTEGER  DEFAULT 60,<br \/>    stattab         VARCHAR2 DEFAULT NULL,<br \/>    statid          VARCHAR2 DEFAULT NULL,<br \/>    statown         VARCHAR2 DEFAULT NULL );<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 39pt\"><strong><em>Parameters<br \/>\n<\/em><\/strong><\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:104px\"\/>\n<col style=\"width:378px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 25px; background: #dfdfdf\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><strong>Parameter<\/strong><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt\">\n<p><strong>Description<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Gathering_mode<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>Mode \uac12\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4 :<br \/>&#8211; <span style=\"font-family:Courier New\">INTERVAL<\/span> : \uc9c0\uc815 \uc2dc\uac04\ub3d9\uc548 \uc2dc\uc2a4\ud15c \ud65c\ub3d9 \uc815\ubcf4\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4.  \uc0ac\uc6a9\uc790\ub294 \uc2dc\uac04\uc744 \ubd84\ub2e8\uc704\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>&#8211; <span style=\"font-family:Courier New\">START | STOP<\/span> : \uc9c0\uc815\ud55c \uc2dc\uc791 \uc2dc\uac04\uacfc \uc885\ub8cc \uc2dc\uac04 \ub3d9\uc548 \uc2dc\uc2a4\ud15c \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\uc5ec dictionary \ub098 stattab \uc744 \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Interval<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \uc2dc\uac04. \ubd84\ub2e8\uc704\ub85c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Stattab<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\uac00 \uc800\uc7a5\ub420 \uc0ac\uc6a9\uc790 Stat \ud14c\uc774\ube14<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Statid<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub420 \ud1b5\uacc4 \uc815\ubcf4\uc758 ID.  (Optional)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Statown<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc744 \uc18c\uc720\ud558\ub294 \uc2a4\ud0a4\ub9c8. \uc774 \ud568\uc218\ub97c \uc218\ud589\ud558\ub294 \uc0ac\uc6a9\uc790\uc640 \ub2e4\ub97c \uacbd\uc6b0 \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 125pt\">\n\u00a0<\/p>\n<h5>DBMS_STATS.SET_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"margin-left: 28pt\">\uc774 \ud568\uc218\ub294 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \uac12\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 28pt\"><strong><em>Syntax<br \/>\n<\/em><\/strong><\/p>\n<p style=\"margin-left: 28pt\"><span style=\"font-family:Courier New\">DBMS_STATS.SET_SYSTEM_STATS (<br \/>    pname        VARCHAR2,<br \/>    pvalue       NUMBER,<br \/>    stattab  IN  VARCHAR2 DEFAULT NULL,<br \/>    statid   IN  VARCHAR2 DEFAULT NULL,<br \/>    statown  IN  VARCHAR2 DEFAULT NULL );<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 50pt\"><strong><em>Parameters<br \/>\n<\/em><\/strong><\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:104px\"\/>\n<col style=\"width:378px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"background: #dfdfdf\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><strong>Parameter<\/strong><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt\">\n<p><strong>Description<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Pname<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\uc124\uc815\ud560 \ud30c\ub77c\ubbf8\ud130 \uc774\ub984.  \ub2e4\uc74c \uc911 \ud558\ub098\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\u2013 sreadtim : \ud55c \ube14\ub85d\uc744 \uc77d\uae30\uc704\ud55c \ub300\uae30 \uc2dc\uac04.  Miliseconds \ub2e8\uc704<br \/>\u2013 mreadtim : \ub2e4\uc911 \ube14\ub85d\uc744 \uc77d\uae30 \uc704\ud55c \ub300\uae30 \uc2dc\uac04. Miliseconds \ub2e8\uc704<br \/>\u2013 cpuspeed : \ucd08\ub2f9 cycle \uc218. Million \ub2e8\uc704<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Pvalue<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\uc124\uc815\ud560 \ud30c\ub9ac\ubbf8\ud130 \uac12<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Stattab<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\uac00 \uc800\uc7a5\ub420 \uc0ac\uc6a9\uc790 Stat \ud14c\uc774\ube14<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Statid<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub420 \ud1b5\uacc4 \uc815\ubcf4\uc758 ID.  (Optional)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">Statown<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc744 \uc18c\uc720\ud558\ub294 \uc2a4\ud0a4\ub9c8. \uc774 \ud568\uc218\ub97c \uc218\ud589\ud558\ub294 \uc0ac\uc6a9\uc790\uc640 \ub2e4\ub97c \uacbd\uc6b0 \uc9c0\uc815\ud569\ub2c8\ub2e4<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 125pt\">\n\u00a0<\/p>\n<h5>DBMS_STATS.GET_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"text-align: justify; margin-left: 28pt\">\uc774 \ud568\uc218\ub294 Stattab\uc73c\ub85c \ubd80\ud130 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uac00\uc838 \uc628\ub2e4.  \ub9cc\uc57d Stattab\uc774 NULL \uc774\uba74 dictionary\ub85c\ubd80\ud130 \uac00\uc838\uc628\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 28pt\"><strong><em>Syntax<br \/>\n<\/em><\/strong><\/p>\n<p style=\"margin-left: 28pt\"><span style=\"font-family:Courier New\">DBMS_STATS.GET_SYSTEM_STATS (<br \/>    status   OUT  VARCHAR2,<br \/>    dstart   OUT  DATE,<br \/>    dstop    OUT  DATE,<br \/>    pname         VARCHAR2,<br \/>    pvalue   OUT  NUMBER,<br \/>    stattab  IN   VARCHAR2 DEFAULT NULL,<br \/>    statid   IN   VARCHAR2 DEFAULT NULL,<br \/>    statown  IN   VARCHAR2 DEFAULT NULL );<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 50pt\"><strong><em>Parameters<br \/>\n<\/em><\/strong><\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:104px\"\/>\n<col style=\"width:378px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"background: #dfdfdf\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\"><strong>Parameter<\/strong><\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt; border-right:  none\">\n<p><strong>Description<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Status ( OUT )<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>\ucd9c\ub825\ub420 \uc218 \uc788\ub294 \uac12\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br \/>\u2013 COMPLETED<br \/>\u2013 AUTOGATHERING<br \/>\u2013 MANUALGATHERING<br \/>\u2013 BADSTATS<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Dstart ( OUT )<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>\ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1\uc774 \uc2dc\uc791\ub41c \uc2dc\uac04.  <br \/>\ub9cc\uc57d status\uac00 MANUALGATHERING \uc774\uba74 \uc2dc\uc791 \uc2dc\uac04\uc774 \ub9ac\ud134\ub429\ub2c8\ub2e4.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Dstop ( OUT )<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>\ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1\uc774 \uc885\ub8cc\ub41c \uc2dc\uac04.<br \/>Status\uac00 COMPLTE\uba74 \uc885\ub8cc \uc2dc\uac04\uc774 \ub9ac\ud134\ub429\ub2c8\ub2e4.<br \/>Status\uac00 AUTOGATHERING\uc774\uba74 \ub2e4\uc74c \uc885\ub8cc \uc2dc\uac04\uc774 \ub9ac\ud134\ub429\ub2c8\ub2e4.<br \/>Status\uac00 BADSTATS\uc774\uba74 had-to-be-finished-by \uc2dc\uac04\uc774 \ub9ac\ud134\ub429\ub2c8\ub2e4.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Pname<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>\uad6c\ud558\uace0\uc790 \ud558\ub294 \ud30c\ub77c\ubbf8\ud130 \uc774\ub984.  \ub2e4\uc74c \uc911 \ud558\ub098\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\u2013 sreadtim : \ud55c \ube14\ub85d\uc744 \uc77d\uae30 \uc704\ud55c \ub300\uae30 \uc2dc\uac04.  Miliseconds \ub2e8\uc704<br \/>\u2013 mreadtim : \ub2e4\uc911 \ube14\ub85d\uc744 \uc77d\uae30 \uc704\ud55c \ub300\uae30 \uc2dc\uac04. Miliseconds \ub2e8\uc704<br \/>\u2013 cpuspeed : \ucd08\ub2f9 cycle \uc218. Million \ub2e8\uc704<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Pvalue<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>\uad6c\ud558\uace0\uc790 \ud558\ub294 \ud30c\ub77c\ubbf8\ud130 \uac12<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Stattab<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\uac00 \uc800\uc7a5\ub420 \uc0ac\uc6a9\uc790 Stat \ud14c\uc774\ube14<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Statid<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt; border-right:  none\">\n<p>Stat \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub420 \ud1b5\uacc4 \uc815\ubcf4\uc758 ID.  (Optional)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Book Antiqua; font-size:10pt\">Statown<\/span><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt; border-right:  none\">\n<p>Stat \ud14c\uc774\ube14\uc744 \uc18c\uc720\ud558\ub294 \uc2a4\ud0a4\ub9c8. \uc774 \ud568\uc218\ub97c \uc218\ud589\ud558\ub294 \uc0ac\uc6a9\uc790\uc640 \ub2e4\ub97c \uacbd\uc6b0 \uc9c0\uc815\ud569\ub2c8\ub2e4<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h5>DBMS_STATS.EXPORT_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"margin-left: 50pt\">\uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\uc5ec \uc0ac\uc6a9\uc790 stattab\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 50pt\"><strong><em>Syntax<br \/>\n<\/em><\/strong><\/p>\n<p style=\"margin-left: 50pt\"><span style=\"font-family:Courier New\">DBMS_STATS.EXPORT_SYSTEM_STATS (<br \/>    statab    VARCHAR2,<br \/>    statid    VARCHAR2 DEFAULT NULL,<br \/>    statown   VARCHAR2 DEFAULT NULL );<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 50pt\"><strong><em>Parameters<br \/>\n<\/em><\/strong><\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:104px\"\/>\n<col style=\"width:378px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"background: #dfdfdf\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><strong>Parameter<\/strong><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt\">\n<p><strong>Description<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p>Stattab<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\uac00 \uc800\uc7a5\ub420 \uc0ac\uc6a9\uc790 Stat \ud14c\uc774\ube14<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p>Statid<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub420 \ud1b5\uacc4 \uc815\ubcf4\uc758 ID.  (Optional)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p>Statown<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc744 \uc18c\uc720\ud558\ub294 \uc2a4\ud0a4\ub9c8. \uc774 \ud568\uc218\ub97c \uc218\ud589\ud558\ub294 \uc0ac\uc6a9\uc790\uc640 \ub2e4\ub97c \uacbd\uc6b0 \uc9c0\uc815\ud569\ub2c8\ub2e4<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 70pt\">\n\u00a0<\/p>\n<h5>DBMS_STATS.IMPORT_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"margin-left: 50pt\">\uc0ac\uc6a9\uc790 Stat \ud14c\uc774\ube14\uc758 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c Dictionary\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 50pt\"><strong><em>Syntax<br \/>\n<\/em><\/strong><\/p>\n<p style=\"margin-left: 50pt\"><span style=\"font-family:Courier New\">DBMS_STATS.IMPORT_SYSTEM_STATS (<br \/>    stattab    VARCHAR2,<br \/>    statid     VARCHAR2 DEFAULT NULL,<br \/>    statown    VARCHAR2 DEFAULT NULL );<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 50pt\">\n\u00a0<\/p>\n<p style=\"margin-left: 50pt\">\n\u00a0<\/p>\n<p style=\"margin-left: 50pt\"><strong><em>Parameters<br \/>\n<\/em><\/strong><\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:104px\"\/>\n<col style=\"width:378px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"background: #d9d9d9\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><strong>Parameter<\/strong><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt\">\n<p><strong>Description<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #d9d9d9; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p>Stattab<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud560 \uc0ac\uc6a9\uc790 Stat \ud14c\uc774\ube14<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #d9d9d9; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p>Statid<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub420 \ud1b5\uacc4 \uc815\ubcf4\uc758 ID.  (Optional)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #d9d9d9; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p>Statown<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc744 \uc18c\uc720\ud558\ub294 \uc2a4\ud0a4\ub9c8. \uc774 \ud568\uc218\ub97c \uc218\ud589\ud558\ub294 \uc0ac\uc6a9\uc790\uc640 \ub2e4\ub97c \uacbd\uc6b0 \uc9c0\uc815\ud569\ub2c8\ub2e4<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 125pt\">\n\u00a0<\/p>\n<h5>DBMS_STATS.DELETE_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"margin-left: 28pt\">\uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0ad\uc81c\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 28pt\"><strong><em>Syntax<br \/>\n<\/em><\/strong><\/p>\n<p style=\"margin-left: 28pt\"><span style=\"font-family:Courier New\">DBMS_STATS.DELETE_SYSTEM_STATS (<br \/>    statab    VARCHAR2 DEFAULT NULL,<br \/>    statid    VARCHAR2 DEFAULT NULL,<br \/>    statown   VARCHAR2 DEFAULT NULL );<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 39pt\"><strong><em>Parameters<br \/>\n<\/em><\/strong><\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:104px\"\/>\n<col style=\"width:378px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"background: #dfdfdf\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p><strong>Parameter<\/strong><\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 1.5pt; border-left:  none; border-bottom:  solid 1.5pt\">\n<p><strong>Description<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p>Stattab<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>\ud1b5\uacc4 \uc815\ubcf4\uac00 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uc0ac\uc6a9\uc790 stat \ud14c\uc774\ube14<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p>Statid<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 0.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub41c \ud1b5\uacc4 \uc815\ubcf4\uc758 ID.  (Optional)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background: #dfdfdf; padding-left: 7px; padding-right: 7px; border-top:  none; border-bottom:  solid 1.5pt; border-right:  solid 0.5pt\">\n<p>Statown<\/p>\n<\/td>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  none; border-bottom:  solid 1.5pt\">\n<p>Stat \ud14c\uc774\ube14\uc744 \uc18c\uc720\ud558\ub294 \uc2a4\ud0a4\ub9c8. \uc774 \ud568\uc218\ub97c \uc218\ud589\ud558\ub294 \uc0ac\uc6a9\uc790\uc640 \ub2e4\ub97c \uacbd\uc6b0 \uc9c0\uc815\ud569\ub2c8\ub2e4<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 125pt\">\n\u00a0<\/p>\n<p style=\"background: black\">\n\u00a0<\/p>\n<h3>\ud14c\uc2a4\ud2b8<br \/>\n<\/h3>\n<p style=\"text-align: justify; margin-left: 39pt\">Oracle\uc5d0 \uc0c8\ub86d\uac8c \ucd94\uac00\ub41c \uc790\ub3d9 \uc0d8\ud50c \ud06c\uae30 \uc124\uc815 \uae30\ub2a5\uacfc \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4 \uad00\ub9ac \uae30\ub2a5\uc5d0 \ub300\ud55c \ud14c\uc2a4\ud2b8\ub97c \uc218\ud589\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 60pt\">\n<h4>New Gathering Statistics Estimation<br \/>\n<\/h4>\n<\/p>\n<p style=\"text-align: justify; margin-left: 39pt\">\ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 Sales History(SH) \uc2a4\ud0a4\ub9c8\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.  SH \uc2a4\ud0a4\ub9c8\uc758 SALES \ud14c\uc774\ube14\uc740 \uc57d 90\ub9cc \uac74\uc774 \ub118\ub294 \ub370\uc774\ud130\uac00 \uc788\uc2b5\ub2c8\ub2e4.  \uc774 \uacbd\uc6b0, \ud1b5\uacc4 \uc815\ubcf4 \uacc4\uc0b0 \uc2dc DBMS_STATS.AUTO_SAMPLE_SIZE \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 39pt\">\uba3c\uc800 \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \uc0ac\uc6a9\uc790 STAT \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:510px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">SQL&gt; execute dbms_stats.create_stat_table( &#8216;SH&#8217;, &#8216;STATTAB&#8217; );<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 39pt\">DBMS_STATS.GATHER_TABLE_STATS \ud568\uc218\ub97c \uc774\uc6a9\ud558\uc5ec SALES \ud14c\uc774\ube14\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:482px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">SQL&gt; execute dbms_stats.gather_table_stats( <br \/>        ownname =&gt; &#8216;SH&#8217;, <br \/>        tabname =&gt; &#8216;SALES&#8217;, <br \/>\n\t\t\t\t\t\t\t\t<span style=\"color:blue\">estimate_percent<\/span> =&gt; <span style=\"color:blue\">DBMS_STATS.AUTO_SAMPLE_SIZE<\/span>, <br \/>\n\t\t\t\t\t\t\t\t<span style=\"color:blue\">method_opt<\/span> =&gt; <span style=\"color:blue\">&#8216;for all columns size AUTO&#8217;<\/span>,<br \/>        stattab=&gt;&#8217;STATTAB&#8217; );<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 125pt\">\n\u00a0<\/p>\n<p style=\"text-align: justify; margin-left: 60pt\">\n<h4>Gathering System Statistics<br \/>\n<\/h4>\n<\/p>\n<p style=\"text-align: justify; margin-left: 39pt\">\uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4 \uc218\uc9d1 \uad00\ub828 DBMS_STATS \ud568\uc218\ub4e4\uc744 \ud14c\uc2a4\ud2b8\ud574 \ubcf4\ub3c4\ub85d \ud569\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 70pt\">\n<h5>\uc0ac\uc6a9\uc790 STAT \ud14c\uc774\ube14 \uc0dd\uc131<br \/>\n<\/h5>\n<\/p>\n<p style=\"text-align: justify; margin-left: 39pt\">\uc77c\ubc18\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub294 Dictionary\uc5d0 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uc9c0\ub9cc \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \uc0ac\uc6a9\uc790 \uc2a4\ud0a4\ub9c8\uc5d0 STAT \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 42pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">SQL&gt;execute dbms_stats.create_stat_table(&#8216;akira&#8217;,&#8217;STATTAB&#8217;);<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt;select * from STATTAB;<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">No rows selected<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 125pt\">\uc704 \uc608\ub294 &#8216;AKIRA&#8217; \uc2a4\ud0a4\ub9c8\uc5d0 &#8216;STATTAB&#8217; \uc774\ub77c\ub294 \uc774\ub984\uc73c\ub85c \uc0ac\uc6a9\uc790 STAT \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 70pt\">\n<h5>GATHER_SYSTEM_STATS<br \/>\n<\/h5>\n<\/p>\n<p style=\"text-align: justify; margin-left: 50pt\">\uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 <span style=\"font-family:Courier New\">DBMS_STATS.GATHER_SYSTEM_STATS<\/span> \ud568\uc218\ub294 \ub450\uac00\uc9c0 \ubc29\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div style=\"text-align: justify\"><span style=\"font-size:10pt\"><span style=\"font-family:Courier New\">gathering_mode<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub97c<\/span><span style=\"font-family:Times\"> &#8216;<\/span><span style=\"font-family:Courier New\">INTERVAL<\/span><span style=\"font-family:Times\">&#8216;<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc124\uc815\ud558\uc5ec<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc9c0\uc815<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uac04\ub3d9\uc548<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc2a4\ud15c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4\ub97c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc9d1\ud558\ub3c4\ub85d<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.  <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc791\uc5c5\uc740<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub0b4\ubd80\uc801\uc73c\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud050\uc789<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uae30\ubc95\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0ac\uc6a9\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.  <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub530\ub77c\uc11c<\/span><span style=\"font-family:Times\">, init.ora <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc758<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:Courier New\">job_queue_processes<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac12\uc744<\/span><span style=\"font-family:Times\"> 1 <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774\uc0c1\uc774<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub418\ub3c4\ub85d<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc124\uc815\ud558\uc5ec\uc57c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.<br \/>\n<\/span><\/span><\/div>\n<\/li>\n<\/ul>\n<p>\n\u00a0<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div style=\"text-align: justify\"><span style=\"font-size:10pt\"><span style=\"font-family:Courier New\">gathering_mode<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub97c<\/span><span style=\"font-family:Times\"> &#8216;<\/span><span style=\"font-family:Courier New\">START | STOP<\/span><span style=\"font-family:Times\">&#8216; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc73c\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc124\uc815\ud558\uc5ec<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0ac\uc6a9\uc790\uac00<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uba85\uc2dc\uc801\uc73c\ub85c<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc791\uacfc<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub05d\uc744<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc9c0\uc815\ud560<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218<\/span><span style=\"font-family:Times\"><br \/>\n\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\uc2b5\ub2c8\ub2e4<\/span><span style=\"font-family:Times\">.<em><br \/>\n\t\t\t\t\t\t<\/em><\/span><\/span><\/div>\n<\/li>\n<\/ul>\n<p>\ub450 \uac00\uc9c0 \ubc29\ubc95 \uac01\uac01\uc5d0 \ub300\ud55c \ud14c\uc2a4\ud2b8 \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; 3<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd84<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub3d9\uc548<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc2a4\ud15c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4\ub97c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc9d1\ud558\ub3c4\ub85d<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; <span style=\"color:blue\">execute<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">     dbms_stats.gather_system_stats(&#8216;INTERVAL&#8217;,3,&#8217;STATTAB&#8217;);<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc704\uc758<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc791\uc5c5\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\ud589\ud55c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud6c4<\/span><span style=\"font-family:Courier New\"> USER_JOB <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud14c\uc774\ube14\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud655\uc778\ud574<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd05\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt;select job,to_char(next_date,&#8217;YYYY\/MM\/DD HH:MI:SS&#8217;),what<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  2 from user_jobs;<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">       JOB TO_CHAR(NEXT_DATE,&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">WHAT<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">        10 2001\/03\/21 05:56:53<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">dbms_stats.gather_system_stats(gathering_mode =&gt; &#8216;AUTO_STOP&#8217;, stattab =&gt; &#8216;STATTAB&#8217;, statown =&gt; &#8216;AKIRA&#8217;);<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; 3<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd84<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud6c4<\/span><span style=\"font-family:Courier New\"> queue<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5d0<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\ub294<\/span><span style=\"font-family:Courier New\"> job<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ucc98\ub9ac\ub41c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud6c4<\/span><span style=\"font-family:Courier New\"> STATTAB<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud655\uc778\ud574<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd05\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud558\uc9c0\ub9cc<\/span><span style=\"font-family:Courier New\">, Queue<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5d0<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc788\ub294<\/span><span style=\"font-family:Courier New\"> job<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ucc98\ub9ac\ud560<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub54c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc5d0\ub7ec\uac00<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubc1c\uc0dd\ud558\uae30<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub54c\ubb38\uc5d0<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t\t<br \/>&#8212; STATTAB <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0c1\ud0dc\ub294<\/span><span style=\"font-family:Courier New\"> &#8216;BADSTATS&#8217;<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub85c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub098\uc628\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; select type, version, flags, c1 from stattab;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">T    VERSION      FLAGS C1<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">S          4          0 <span style=\"color:blue\">BADSTATS<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 50pt\">\ud558\uc9c0\ub9cc \uc704\uc640 \uac19\uc774 \uc218\ud589\ud560 \uacbd\uc6b0, 3\ubd84 \ud6c4 \ud050\uc5d0 \uc788\ub294 JOB \uc744 \ucc98\ub9ac\ud560 \ub54c \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.   \uc544\uc9c1 \uc6d0\uc778\uc740 \uc54c \uc218 \uc5c6\ub2e4.\n<\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">*** SESSION ID:(13.157) 2001-03-21 17:56:54.836<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">*** 2001-03-21 17:56:54.836<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">ORA-12012: error on auto execute of job 10<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">ORA-23421: job number 10 is not a job in the job queue<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">ORA-06512: at &#8220;SYS.DBMS_SYS_ERROR&#8221;, line 86<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">ORA-06512: at &#8220;SYS.DBMS_IJOB&#8221;, line 525<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">ORA-06512: at &#8220;SYS.DBMS_IJOB&#8221;, line 258<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">ORA-06512: at line 1<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 50pt\">\n\u00a0<\/p>\n<p style=\"text-align: justify; margin-left: 50pt\">\ub2e4\uc74c\uc740 &#8216;gathering_mode&#8217;\ub97c &#8216;START | STOP&#8217;\uc73c\ub85c \uc218\ud589\ud55c \uacb0\uacfc\uc785\ub2c8\ub2e4.  \uc774 \uacbd\uc6b0\uc5d0\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c STATTAB\uc758 \uc0c1\ud0dc\ub294 &#8216;BADSTATS&#8217;\uc785\ub2c8\ub2e4.  \uc6d0\uc778 \ubd84\uc11d\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; gathering_mode<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub97c<\/span><span style=\"font-family:Courier New\"> &#8216;START&#8217;<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub85c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud558\uc5ec<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc2a4\ud15c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc9d1\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t\t<br \/>&#8212; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc791\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; <span style=\"color:blue\">execute dbms_stats.gather_system_stats ( gathering_mode=&gt;&#8217;START&#8217;, stattab=&gt;&#8217;STATTAB&#8217; );<\/span><br \/>\n\t\t\t\t\t\t\t<\/span><\/p>\n<p style=\"margin-left: 125pt\">\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; gathering_mode<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub97c<\/span><span style=\"font-family:Courier New\"> &#8216;STOP&#8217;<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc73c\ub85c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud558\uc5ec<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc2a4\ud15c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\uc9d1\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t\t<br \/>&#8212; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc885\ub8cc\ud569\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; <span style=\"color:blue\">execute dbms_stats.gather_system_stats ( gathering_mode=&gt;&#8217;STOP&#8217;, stattab=&gt;&#8217;STATTAB&#8217; );<\/span><br \/>\n\t\t\t\t\t\t\t<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; STATTAB<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud655\uc778\ud574<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd05\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; select type, version, flags, c1 from stattab;<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">T    VERSION      FLAGS C1<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">S          4          1 <span style=\"color:blue\">BADSTATS<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\n\u00a0<\/p>\n<h5>SET_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"text-align: justify; margin-left: 17pt\">\uba3c\uc800, GET_SYSTEM_STATS \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc704\uc5d0\uc11c \uc218\uc9d1\ud55c \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \ud655\uc778\ud574 \ubcf4\uc544\uc57c \ud558\uc9c0\ub9cc,  \uc704\uc758 \uacbd\uc6b0\ucc98\ub7fc \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\uac00 &#8216;BADSTATS&#8217;\uc77c \uacbd\uc6b0\uc5d4 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c, SET_SYSTEM_STATS \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0ac\uc6a9\uc790\uac00 \uc815\uc758\ud55c \uac12\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubcc0\uacbd<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac00\ub2a5\ud55c<\/span><span style=\"font-family:Courier New\"> &#8216;sreadtim&#8217;, &#8216;mreadtim&#8217;, &#8216;cpuspeed&#8217; <br \/>&#8212; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc138\uac00\uc9c0<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac12\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubcc0\uacbd\ud574<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd05\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; execute <span style=\"color:blue\">dbms_stats.set_system_stats( pname=&gt;&#8217;sreadtim&#8217;, pvalue=&gt;99, stattab=&gt;&#8217;STATTAB&#8217;);<br \/>\n<\/span><\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; execute <span style=\"color:blue\">dbms_stats.set_system_stats( pname=&gt;&#8217;mreadtim&#8217;, pvalue=&gt;99, stattab=&gt;&#8217;STATTAB&#8217;);<br \/>\n<\/span><\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; execute <span style=\"color:blue\">dbms_stats.set_system_stats( pname=&gt;&#8217;cpuspeed&#8217;, pvalue=&gt;4, stattab=&gt;&#8217;STATTAB&#8217;);<\/span><br \/>\n\t\t\t\t\t\t\t<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>&#8212; STAT <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud14c\uc774\ube14\uc758<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0c1\ud0dc\ub97c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud655\uc778\ud574<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ubd05\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\u2013- <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\uc0c1\uc801\uc73c\ub85c<\/span><span style=\"font-family:Courier New\"> SET_SYSTEM_STATS<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc774<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc218\ud589\ub418\uc5c8\uc744<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uacbd\uc6b0<\/span><span style=\"font-family:Courier New\"><br \/>\u2013- <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc2dc\uc2a4\ud15c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ud1b5\uacc4<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc815\ubcf4\ub294<\/span><span style=\"font-family:Courier New\"> &#8216;COMPLETED&#8217; <\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\ub77c\ub294<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uc0c1\ud0dc\ub97c<\/span><span style=\"font-family:Courier New\"><br \/>\n\t\t\t\t\t\t\t<\/span><span style=\"font-family:\ubc14\ud0d5\uccb4\">\uac00\uc9d1\ub2c8\ub2e4<\/span><span style=\"font-family:Courier New\">.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; select type, version, flags, c1 from stattab;<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">T    VERSION      FLAGS C1<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">S          4          1 <span style=\"color:blue\">COMPLETED<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 116pt\">\n\u00a0<\/p>\n<h5>GET_SYSTEM_STATS<br \/>\n<\/h5>\n<p style=\"margin-left: 50pt\">\uc704\uc5d0\uc11c SET_SYSTEM_STATS \uc73c\ub85c \uc124\uc815\ud55c \uac12\uc744 \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4.\n<\/p>\n<div style=\"margin-left: 52pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:501px\"\/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:Courier New\">SQL&gt; set serveroutput on<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">SQL&gt; declare<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  2  v_status        varchar2(20);<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  3  v_dstart        STATTAB.D1%TYPE;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  4  v_dstop         STATTAB.D1%TYPE;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  5  v_sreadtim NUMBER;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  6  v_mreadtim NUMBER;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  7  v_cpuspeed NUMBER;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  8  begin<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\">  9  <span style=\"color:blue\">dbms_stats.get_system_stats( v_status, v_dstart, v_dstop, &#8216;sreadtim&#8217;, v_sreadtim, &#8216;STATTAB&#8217; );<\/span><br \/>\n\t\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 10  <span style=\"color:blue\">dbms_stats.get_system_stats( v_status, v_dstart, v_dstop, &#8216;mreadtim&#8217;, v_mreadtim, &#8216;STATTAB&#8217; );<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 11  <span style=\"color:blue\">dbms_stats.get_system_stats( v_status, v_dstart, v_dstop, &#8216;cpuspeed&#8217;, v_cpuspeed, &#8216;STATTAB&#8217; );<\/span><br \/>\n\t\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 12  dbms_output.put_line( &#8216;STATUS=&#8217; || v_status );<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 13  dbms_output.put_line( &#8216;START TIME=&#8217; || to_char( v_dstart, &#8216;YY\/MM\/DD HH:MI:SS&#8217;));<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 14  dbms_output.put_line( &#8216;STOP TIME=&#8217; || to_char(v_dstop, &#8216;YY\/MM\/DD HH:MI:SS&#8217;));<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 15<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 16  dbms_output.put_line( &#8216;sreadtim=&#8217; || v_sreadtim );<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 17  dbms_output.put_line( &#8216;mreadtim=&#8217; || v_mreadtim );<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 18  dbms_output.put_line( &#8216;cpuspeed=&#8217; || v_cpuspeed );<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 19  end;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:Courier New\"> 20  \/<br \/>\n<\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">STATUS=COMPLETED<br \/>\n<\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">START TIME=01\/03\/22 10:21:00<br \/>\n<\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">STOP TIME=01\/03\/22 10:21:00<br \/>\n<\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">sreadtim=99<br \/>\n<\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">mreadtim=99<br \/>\n<\/span><\/p>\n<p><span style=\"color:blue; font-family:Courier New\">cpuspeed=4<br \/>\n<\/span><\/p>\n<p>\n\u00a0<\/p>\n<p><span style=\"font-family:Courier New\">PL\/SQL procedure successfully completed.<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"text-align: justify; margin-left: 50pt\">\uc704\uc758 \uacb0\uacfc\uc5d0\uc11c \ubcf4\ub294 \ubc14\uc640 \uac19\uc774 DBMS_STATS.SET_SYSTEM_STATS\uc744 \uc774\uc6a9\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \uac12\uc744 \ud655\uc778\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"margin-left: 116pt\">\n\u00a0<\/p>\n<p style=\"background: black\">\n\u00a0<\/p>\n<h3>\ud65c\uc6a9\uac00\uc774\ub4dc \ubc0f \uacb0\ub860<br \/>\n<\/h3>\n<p style=\"text-align: justify; margin-left: 6pt\">Oracle\uc5d0\uc11c\ub294 \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131 \uc2dc \uc0d8\ud50c \ud06c\uae30\ub97c \uc790\ub3d9\uc73c\ub85c \uc9c0\uc815\ud574 \uc8fc\ub294 \uae30\ub2a5, CPU\uc640 I\/O \ub4f1\uc758 \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \uae30\ub2a5 \ub4f1\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 6pt\">\uc790\ub3d9 \uc0d8\ud50c \ud06c\uae30 \uc124\uc815 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74, \uc0ac\uc6a9\uc790\uac00 \ub108\ubb34 \uc801\uc740 \uc591\uc758 \uc0d8\ud50c \ud06c\uae30\ub97c \uc124\uc815\ud558\uc5ec \ubd80\uc815\ud655\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc5bb\uac70\ub098, \uc0d8\ud50c \ud06c\uae30\ub97c \ub108\ubb34 \ud06c\uac8c \uc124\uc815\ud558\uc5ec \ud1b5\uacc4 \uc815\ubcf4\ub97c \uad6c\ud558\ub294\ub370 \ub9ce\uc740 \uc2dc\uac04\uc801, \uacf5\uac04\uc801 \ube44\uc6a9\uc744 \ub0ad\ube44\ud558\ub294 \uac83\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \uc801\uc808\ud55c \ud1b5\uacc4 \uc815\ubcf4\uc758 \uc815\ud655\uc131\uc744 \uc720\uc9c0\ud558\uba74\uc11c \ucd5c\ub300\uc758 \uc131\ub2a5 \uc0c1\uc758 \uc774\ub4dd\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<\/p>\n<p style=\"text-align: justify; margin-left: 6pt\">\ub610\ud55c, Oracle\uc5d0 \uc0c8\ub86d\uac8c \ucd94\uac00\ub41c \uc2dc\uc2a4\ud15c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\uc5ec \uc2dc\uc2a4\ud15c\uc758 I\/O \ubc0f CPU\uc758 \uc131\ub2a5\ub3c4 \uace0\ub824\ud558\uc5ec Optimizer\uac00 Plan\uc744 \uc791\uc131\ud558\uac8c \ud558\uc5ec \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uae30\ub300\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Enhanced Statistics Gathering Cost-Based Optimizer(CBO)\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud1b5\uacc4 \uc815\ubcf4\uc5d0 \uc758\uc874\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c, CBO\uac00 \uc815\ud655\ud55c \uc2e4\ud589 \uacc4\ud68d(Execution Plan)\uc744 \uc0dd\uc131\ud558\ub3c4\ub85d \ud558\ub824\uba74, \uc0ac\uc6a9\uc790\ub294 CBO\ub97c \uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 SQL \ubb38\uc5d0\uc11c \uc811\uadfc\ud558\ub294 \ubaa8\ub4e0 \ud14c\uc774\ube14, \uc778\ub371\uc2a4, \ud074\ub7ec\uc2a4\ud130 \ub4f1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0dd\uc131\ud574 \ub450\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub9cc\uc57d, \ud14c\uc774\ube14\uc758 \ud06c\uae30\ub098 \ub370\uc774\ud130 \ubd84\ud3ec\uac00 \uc790\uc8fc \ubcc0\uacbd\ub41c\ub2e4\uba74, \ud1b5\uacc4 \uc815\ubcf4\uc758 \uc815\ud655\uc131\uc744 \uc704\ud574 \uc0ac\uc6a9\uc790\ub294 \uc8fc\uae30\uc801\uc73c\ub85c \uad00\ub828 \uac1d\uccb4\uc5d0 \ub300\ud55c \ud1b5\uacc4 [&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":[134,162],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1603"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1603"}],"version-history":[{"count":1,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1603\/revisions"}],"predecessor-version":[{"id":1604,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1603\/revisions\/1604"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}