{"id":2850,"date":"2018-02-03T15:00:06","date_gmt":"2018-02-03T06:00:06","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2850"},"modified":"2018-02-03T15:39:23","modified_gmt":"2018-02-03T06:39:23","slug":"dictionary-table-statistics-%ed%86%b5%ea%b3%84-%ec%a0%95%eb%b3%b4-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2850","title":{"rendered":"dictionary table statistics \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131"},"content":{"rendered":"<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true \">  1) Dictionary \ud1b5\uacc4\uc815\ubcf4\ub97c \uc800\uc7a5 &amp; \uad00\ub9ac\ud560 table\uc744 \uc0dd\uc131\ud55c\ub2e4.\r\n\r\n  exec dbms_stats.create_stat_table('SYSTEM','mystats');\r\n\r\n  \r\n\r\n  2) Dictionary \ud1b5\uacc4\ub97c \uc218\uc9d1\ud55c\ub2e4.\r\n\r\n  exec dbms_stats.gather_dictionary_stats(stattab=&gt;'mystats',statid=&gt;'DAY',statown=&gt;'SYSTEM');\r\n\r\n \r\n\r\n  3) Dictionary \ud1b5\uacc4\uc815\ubcf4\ub97c load\ud55c\ub2e4.\r\n\r\n  exec dbms_stats.import_dictionary_stats(stattab=&gt;'mystats',statid=&gt;'DAY');\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; 1) Dictionary \ud1b5\uacc4\uc815\ubcf4\ub97c \uc800\uc7a5 &amp; \uad00\ub9ac\ud560 table\uc744 \uc0dd\uc131\ud55c\ub2e4. exec dbms_stats.create_stat_table(&#8216;SYSTEM&#8217;,&#8217;mystats&#8217;); 2) Dictionary \ud1b5\uacc4\ub97c \uc218\uc9d1\ud55c\ub2e4. exec dbms_stats.gather_dictionary_stats(stattab=&gt;&#8217;mystats&#8217;,statid=&gt;&#8217;DAY&#8217;,statown=&gt;&#8217;SYSTEM&#8217;); 3) Dictionary \ud1b5\uacc4\uc815\ubcf4\ub97c load\ud55c\ub2e4. exec dbms_stats.import_dictionary_stats(stattab=&gt;&#8217;mystats&#8217;,statid=&gt;&#8217;DAY&#8217;);<\/p>\n","protected":false},"author":1,"featured_media":2862,"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":[3],"tags":[941,942,133,162],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/managed-services2.jpg?fit=1200%2C386","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2850"}],"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=2850"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2850\/revisions"}],"predecessor-version":[{"id":2863,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2850\/revisions\/2863"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2862"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2850"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}