{"id":408,"date":"2015-08-24T04:55:00","date_gmt":"2015-08-24T04:55:00","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=408"},"modified":"2018-02-05T20:25:43","modified_gmt":"2018-02-05T11:25:43","slug":"dictionary-statistics-%ed%86%b5%ea%b3%84-%ec%83%9d%ec%84%b1%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=408","title":{"rendered":"Dictionary Statistics \ud1b5\uacc4 \uc0dd\uc131\ubc29\ubc95"},"content":{"rendered":"

<\/a>Simplify Statistics<\/h2>\n

<\/a>\ud1b5\uacc4\uce58 \uc218\uc9d1 \ubc29\ubc95<\/h3>\n

 <\/p>\n

Oracle Database 10g\ubd80\ud130\ub294 \ucd5c\uc0c1\uc758 \uc131\ub2a5\uc744 \uc5bb\uae30 \uc704\ud574\uc11c, fixed \ud14c\uc774\ube14\uacfc dictionary \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud1b5\uacc4\uce58\ub97c \uc218\uc9d1\ud574\uc57c \ud55c\ub2e4.\u00a0 fixed \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc218\uc9d1\uc740 \uc804\ud615\uc801\uc778 \uc2dc\uc2a4\ud15c \ubd80\ud558(workload) \uc0c1\ud0dc\uc5d0\uc11c \ud55c\ubc88\ub9cc \ud558\uba74 \ub41c\ub2e4.<\/p>\n

 <\/p>\n

<\/a>Dictionary \ud14c\uc774\ube14<\/h4>\n

DBMS_STATS.GATHER_{SCHEMA|DATABASE}_STATS \ub85c \uc218\uc9d1\ud55c\ub2e4.<\/p>\n

\ub610\ud55c DBMS_STATS.GATHER_DICTIONARY_STATS\ub85c\ub3c4 \ud1b5\uacc4\uc790\ub8cc\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\ub2e4. \uc774 procedure\ub97c \uc218\ud589\ud558\uae30 \uc704\ud574\uc11c\ub294 ANALYZE ANY DICTIONARY\uad8c\ud55c\uc774 \uc8fc\uc5b4\uc838\uc57c \ud55c\ub2e4.<\/p>\n

 <\/p>\n

<\/a>Fixed \ud14c\uc774\ube14<\/h4>\n

DBMS_STATS.GATHER_FIXED_OBJECTS_STATS \ub85c \uc218\uc9d1\ud55c\ub2e4. \uc774 procedure\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ud30c\ub77c\ubbf8\ud130\ub4e4\uc774 \uc788\ub2e4.<\/p>\n

STATTAB : \ud604\uc7ac \ud1b5\uacc4 \uc790\ub8cc\ub97c \uc5b4\ub514\uc5d0 \uc800\uc7a5\ud560\uc9c0\ub97c \uc54c\ub824\uc8fc\ub294 \ud30c\ub77c\ubbf8\ud130.<\/p>\n

STATID : STATTAB\uc640 \uad00\uacc4\ub41c optional identifier.<\/p>\n

STATOWN : STATTAB\ub97c \ud3ec\ud568\ud558\ub294 \uc2a4\ud0a4\ub9c8.<\/p>\n

NO_INVALIDATE : TRUE\ub85c setting\ud560 \uacbd\uc6b0 \uc885\uc18d\uc801\uc778 cursor\ub97c invalidate\uc2dc\ud0a4\uc9c0 \uc54a\ub294 \ud30c\ub77c\ubbf8\ud130<\/p>\n

\uc774\ub807\uac8c \uc218\uc9d1\ub41c \ud1b5\uacc4\uc790\ub8cc\ub294 DELETE_FIXED_OBJECTS_STATS\ub85c \uc5c6\uc568 \uc218 \uc788\ub2e4.<\/p>\n

\ub610\ud55c EXPORT_FIXED_OBJECTS_STATS\uc640 IMPORT_FIXED_OBJECTS_STATS \ub97c \ud1b5\ud574 export\uc640 import\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc790\ub8cc\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\ub2e4.<\/p>\n

Oracle Databse 10g\ubd80\ud130\ub294 STATISTICS_LEVEL \ud30c\ub77c\ubbf8\ud130\uac00 \uae00\ub85c\ubc8c \uc2a4\uc704\uce58\ub85c \ubc14\ub00c\uc5c8\ub2e4. \uadf8\ub798\uc11c {ALTER|CREATE} [NO]MONITORING \ubb38\uc774 \ub354 \uc774\uc0c1 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n

\n

\n

Dictionary Statistics \ud1b5\uacc4 \uc0dd\uc131\ubc29\ubc95<\/span><\/p>\n

\u00a0<\/b><\/p>\n

\u00a01) Dictionary \ud1b5\uacc4\uc815\ubcf4\ub97c \uc800\uc7a5 & \uad00\ub9ac\ud560 table\uc744 \uc0dd\uc131\ud55c\ub2e4.<\/span><\/p>\n

\u00a0<\/b><\/p>\n

\u00a0exec dbms_stats.create_stat_table(‘SYSTEM’,’mystats’);<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/b><\/p>\n

\u00a02) Dictionary \ud1b5\uacc4\ub97c \uc218\uc9d1\ud55c\ub2e4.<\/span><\/p>\n

\u00a0<\/b><\/p>\n

\u00a0exec dbms_stats.gather_dictionary_stats(stattab=>’mystats’,statid=>’DAY’,statown=>’SYSTEM’);<\/span><\/p>\n

\u00a0<\/b><\/p>\n

\n

\u00a03) Dictionary \ud1b5\uacc4\uc815\ubcf4\ub97c load\ud55c\ub2e4.<\/span><\/p>\n

\u00a0<\/b><\/p>\n

\u00a0exec dbms_stats.import_dictionary_stats(stattab=>’mystats’,statid=>’DAY’);<\/span><\/p>\n

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

Simplify Statistics \ud1b5\uacc4\uce58 \uc218\uc9d1 \ubc29\ubc95   Oracle Database 10g\ubd80\ud130\ub294 \ucd5c\uc0c1\uc758 \uc131\ub2a5\uc744 \uc5bb\uae30 \uc704\ud574\uc11c, fixed \ud14c\uc774\ube14\uacfc dictionary \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud1b5\uacc4\uce58\ub97c \uc218\uc9d1\ud574\uc57c \ud55c\ub2e4.\u00a0 fixed \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud1b5\uacc4\uc218\uc9d1\uc740 \uc804\ud615\uc801\uc778 \uc2dc\uc2a4\ud15c \ubd80\ud558(workload) \uc0c1\ud0dc\uc5d0\uc11c \ud55c\ubc88\ub9cc \ud558\uba74 \ub41c\ub2e4.   Dictionary \ud14c\uc774\ube14 DBMS_STATS.GATHER_{SCHEMA|DATABASE}_STATS \ub85c \uc218\uc9d1\ud55c\ub2e4. \ub610\ud55c DBMS_STATS.GATHER_DICTIONARY_STATS\ub85c\ub3c4 \ud1b5\uacc4\uc790\ub8cc\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\ub2e4. \uc774 procedure\ub97c \uc218\ud589\ud558\uae30 \uc704\ud574\uc11c\ub294 ANALYZE ANY DICTIONARY\uad8c\ud55c\uc774 \uc8fc\uc5b4\uc838\uc57c \ud55c\ub2e4.   Fixed […]<\/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":[3],"tags":[133,134,135],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/408"}],"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=408"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions"}],"predecessor-version":[{"id":3587,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions\/3587"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}