{"id":2848,"date":"2018-02-03T14:56:58","date_gmt":"2018-02-03T05:56:58","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2848"},"modified":"2018-02-03T15:41:31","modified_gmt":"2018-02-03T06:41:31","slug":"%ed%8c%8c%ed%8b%b0%ec%85%98-%ed%86%b5%ea%b3%84%ec%a0%95%eb%b3%b4-%ec%9d%bc%ec%b9%98-%ec%9e%91%ec%97%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2848","title":{"rendered":"\ud30c\ud2f0\uc158 \ud1b5\uacc4\uc815\ubcf4 \uc77c\uce58 \uc791\uc5c5"},"content":{"rendered":"

 <\/p>\n

\ud30c\ud2f0\uc158 \ud1b5\uacc4\uc815\ubcf4 \uc77c\uce58 \uc791\uc5c5\r\n\r\n\r\n\uc0ac\uc804\uc5d0 \ud55c\ubc88\uc740 ALL \ub610\ub294 \uae30\uc900\uc774 \ub418\ub294 \ud2b9\uc815 \ud30c\ud2f0\uc158 \ud1b5\uacc4\uc815\ubcf4\ub97c \ub5a0\ub194\uc57c \ud568.\r\n\r\n\r\n-- \ud30c\ud2f0\uc158\ubcc4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub9cc\ub4dc\ub294 SQL\r\n\r\n\r\npart_stat_equal.sql \ub0b4\uc6a9     ( \ubbf8\ub9ac \ub9cc\ub4e4\uc5b4\uc838 \uc788\uc5b4\uc57c \ud568 )\r\n\r\ndefine table_owner = &1\r\ndefine table_name = &2\r\ndefine src_partition_name = &3\r\n\r\n\r\nselect 'exec DBMS_STATS.COPY_TABLE_STATS( '''||'&&table_owner'||''' , '''||'&&table_name'||''', '''||'&&src_partition_name'||''', '''||PARTITION_NAME||''' ,  FORCE=>TRUE); '   as scripts from dba_tab_partitions where TABLE_OWNER = '&&table_owner' and table_name='&&table_name'  ;\r\n\r\n\r\n\uc774\uac78 \uc2e4\ud589 \r\n\r\nset head off\r\nset feedback off\r\nset echo off\r\nset time off\r\nset timing off\r\nset verify off\r\n\r\n\r\n\uc608\uc2dc) \uc720\uc800\uba85 TMALL\r\n\r\n@part_stat_equal \uc720\uc800\uba85 \ud14c\uc774\ube14\uba85 \uae30\uc900\ud30c\ud2f0\uc158\uba85\r\n\r\n@part_stat_equal TMALL  TR_ORD_CLM_DELVPLACE    P_200909\r\n@part_stat_equal TMALL  TR_ORD_CLM_DELVPLACE_HIST       P_200909\r\n@part_stat_equal TMALL  TR_ORD_STL_RFND P_200909\r\n@part_stat_equal TMALL  TR_ORD_STLMNT_DTLS      P_200909\r\n@part_stat_equal TMALL  TR_ORD_PRD_STAT_HIST    P_200909\r\n@part_stat_equal TMALL  TR_SLCT_PRD_OPT P_200909\r\n@part_stat_equal TMALL  TR_DLV_INFO_DTLS_IF     P_200909\r\n@part_stat_equal TMALL  TR_ORD_CLM_DLV_DTLS     P_200909\r\n\r\n\r\n\uc704\uc5d0 \ub9cc\ub4e0 \uacb0\uacfc\uc5d0 \ub530\ub978 \uacb0\uacfc\r\n\r\nexec DBMS_STATS.COPY_TABLE_STATS( 'TMALL' , 'TR_ORD_CLM_DELVPLACE', 'P_200909', 'P_200801' ,  FORCE=>TRUE);                                                                                                      \r\n                                                                                                                                                                                                                 \r\n....\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
  \ud30c\ud2f0\uc158 \ud1b5\uacc4\uc815\ubcf4 \uc77c\uce58 \uc791\uc5c5 \uc0ac\uc804\uc5d0 \ud55c\ubc88\uc740 ALL \ub610\ub294 \uae30\uc900\uc774 \ub418\ub294 \ud2b9\uc815 \ud30c\ud2f0\uc158 \ud1b5\uacc4\uc815\ubcf4\ub97c \ub5a0\ub194\uc57c \ud568. — \ud30c\ud2f0\uc158\ubcc4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ub9cc\ub4dc\ub294 SQL part_stat_equal.sql \ub0b4\uc6a9 ( \ubbf8\ub9ac \ub9cc\ub4e4\uc5b4\uc838 \uc788\uc5b4\uc57c \ud568 ) define table_owner = &1 define table_name = &2 define src_partition_name = &3 select ‘exec DBMS_STATS.COPY_TABLE_STATS( ”’||’&&table_owner’||”’ , ”’||’&&table_name’||”’, ”’||’&&src_partition_name’||”’, ”’||PARTITION_NAME||”’ , FORCE=>TRUE); ‘ as scripts from […]<\/p>\n","protected":false},"author":1,"featured_media":2859,"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":[134,162,940,938,939],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/OracleCloudSolutions.jpg?fit=749%2C525","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2848"}],"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=2848"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2848\/revisions"}],"predecessor-version":[{"id":2849,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2848\/revisions\/2849"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2859"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2848"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}