{"id":258,"date":"2013-01-12T15:35:38","date_gmt":"2013-01-12T07:35:38","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=258"},"modified":"2013-01-12T23:35:23","modified_gmt":"2013-01-12T15:35:23","slug":"oracle%e5%85%b3%e4%ba%8e%e8%a1%a8%e4%b8%8a%e7%bb%9f%e8%ae%a1%e4%bf%a1%e6%81%af%e7%9a%84%e5%a4%87%e4%bb%bd%e4%b8%8e%e6%81%a2%e5%a4%8d","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=258","title":{"rendered":"ORACLE\u5173\u4e8e\u8868\u4e0a\u7edf\u8ba1\u4fe1\u606f\u7684\u5907\u4efd\u4e0e\u6062\u590d"},"content":{"rendered":"

\u5907\u4efd\u6062\u590d\u8868\u7edf\u8ba1\u4fe1\u606f
\n\u5728oracle\u4e2d\uff0c\u7edf\u8ba1\u4fe1\u606f\u662f\u5341\u5206\u91cd\u8981\u7684\uff0c\u5c24\u5176\u572810g\u4ee5\u540esql\u6267\u884c\u8ba1\u5212\u91c7\u7528CBO\u540e\uff0c\u8868\u4e0a\u7684\u7edf\u8ba1\u4fe1\u606f\u5c06\u76f4\u63a5\u5f71\u54cdCBO\u505a\u51fa\u6b63\u786e\u7684\u6267\u884c\u8ba1\u5212\u3002\u6240\u4ee5\uff0c\u6211\u4eec\u5bf9\u90a3\u4e9b\u6570\u636e\u91cf\u8f83\u5927\uff0c\u4e14\u5176\u4e2d\u7684\u6570\u636e\u5b58\u5728\u6279\u91cf\u52a0\u8f7d\u548c\u5220\u9664\u7684\u60c5\u5f62\uff0c\u6211\u4eec\u4e00\u822c\u5efa\u8bae\u5728\u5bf9\u8be5\u7c7b\u8868\u505a\u5b8c\u6570\u636e\u6279\u91cf\u52a0\u8f7d\u6216\u5220\u9664\u4e4b\u540e\uff0c\u53ca\u65f6\u5bf9\u5176\u8fdb\u884c\u7edf\u8ba1\u4fe1\u606f\u7684\u6536\u96c6\uff0c\u6b64\u523b\uff0c\u6211\u4eec\u4fbf\u53ef\u91c7\u7528\u5148\u5c06\u8be5\u7c7b\u8868\u4e4b\u524d\u7684\u7edf\u8ba1\u4fe1\u606f\u5907\u4efd\u4e4b\u540e\u518d\u6b21\u5bf9\u5176\u7edf\u8ba1\u4fe1\u606f\u7684\u6536\u96c6\uff0c\u8fd9\u6837\u4e00\u6765\uff0c\u5373\u4f7f\u65b0\u7684\u7edf\u8ba1\u4fe1\u606f\u5b58\u5728\u95ee\u9898\uff0c\u6211\u4eec\u4e5f\u53ef\u5c06\u4e4b\u524d\u7684\u65e7\u7684\u7edf\u8ba1\u4fe1\u606f\u6062\u590d\u8fc7\u53bb\uff0c\u4ee5\u4e0d\u81f3\u4e8e\u9020\u6210\u8868\u4e0a\u6ca1\u6709\u7edf\u8ba1\u4fe1\u606f\u7684\u95ee\u9898\u53d1\u751f\u3002\u4e0b\u8fb9\uff0c\u5c31\u662f\u4e00\u4e2a\u8868\u4e0a\u7edf\u8ba1\u4fe1\u606f\u7684\u5907\u4efd\u548c\u6062\u590d\u7684\u5b9e\u4f8b\uff1a<\/p>\n

SQL> desc test.test
\nName Null? Type
\n----------------------------------------- -------- ----------------------------
\nID NUMBER
\nNAME VARCHAR2(10)<\/p>\n

\u67e5\u770b\u8868\u5206\u6790\u65f6\u95f4
\nSQL> select to_char(last_analyzed,'yyyy\/mm\/dd hh24:mi:ss') from dba_tables where table_name='TEST' AND OWNER='TEST';<\/p>\n

TO_CHAR(LAST_ANALYZ
\n-------------------
\n2012\/08\/21 00:32:23<\/p>\n

--\u67e5\u770b\u5f53\u524d\u65f6\u95f4
\nSQL> select to_char(sysdate,'yyyy\/mm\/dd hh24:mi:ss') from dual;<\/p>\n

TO_CHAR(SYSDATE,'YY
\n-------------------
\n2012\/09\/28 08:21:58<\/p>\n

\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u5b58\u50a8\u8868\uff0c\u6536\u96c6\u8868\u7edf\u8ba1\u4fe1\u606f\u5e76\u5c06\u7edf\u8ba1\u4fe1\u606f\u5b58\u50a8\u5230\u5b58\u50a8\u8868
\nSQL> BEGIN
\n2 DBMS_STATS.CREATE_STAT_TABLE ('test', 'savestats');
\n3 DBMS_STATS.GATHER_TABLE_STATS ('test', 'test', stattab => 'savestats');
\n4 END;
\n5 \/
\nBEGIN
\n*
\nERROR at line 1:
\nORA-20002: Unable to create table SAVESTATS: already exists
\nORA-06512: at \"SYS.DBMS_STATS\", line 7060
\nORA-06512: at line 2<\/p>\n

\u5220\u9664\u7edf\u8ba1\u4fe1\u606f\u5b58\u50a8\u8868
\nSQL> BEGIN
\n2 DBMS_STATS.DROP_STAT_TABLE ('test', 'savestats');
\n3 END;
\n4 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u521b\u5efa\u7edf\u8ba1\u4fe1\u606f\u5b58\u50a8\u8868\uff0c\u6536\u96c6\u8868\u7edf\u8ba1\u4fe1\u606f\u5e76\u5c06\u7edf\u8ba1\u4fe1\u606f\u5b58\u50a8\u5230\u5b58\u50a8\u8868
\nSQL> BEGIN
\n2 DBMS_STATS.CREATE_STAT_TABLE ('test', 'savestats');
\n3 DBMS_STATS.GATHER_TABLE_STATS ('test', 'test', stattab => 'savestats');
\n4 END;
\n5 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u67e5\u770b\u8868\u5206\u6790\u65f6\u95f4
\nSQL> select to_char(last_analyzed,'yyyy\/mm\/dd hh24:mi:ss') from dba_tables where table_name='TEST' AND OWNER='TEST';<\/p>\n

TO_CHAR(LAST_ANALYZ
\n-------------------
\n2012\/09\/28 08:25:33<\/p>\n

\u67e5\u770b\u5f53\u524d\u65f6\u95f4
\nSQL> select to_char(sysdate,'yyyy\/mm\/dd hh24:mi:ss') from dual;<\/p>\n

TO_CHAR(SYSDATE,'YY
\n-------------------
\n2012\/09\/28 08:26:20<\/p>\n

\u5220\u9664\u5f53\u524d\u8868\u7edf\u8ba1\u4fe1\u606f\uff0c\u5c06\u8868\u65e7\u7edf\u8ba1\u4fe1\u606f\u4ece\u5b58\u50a8\u8868\u8fd8\u539f
\nSQL> BEGIN
\n2 DBMS_STATS.DELETE_TABLE_STATS ('test', 'test');
\n3 DBMS_STATS.IMPORT_TABLE_STATS ('test', 'test', stattab => 'savestats');
\n4 END;
\n5 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u67e5\u770b\u8868\u5206\u6790\u65f6\u95f4
\nSQL> select to_char(last_analyzed,'yyyy\/mm\/dd hh24:mi:ss') from dba_tables where table_name='TEST' AND OWNER='TEST';<\/p>\n

TO_CHAR(LAST_ANALYZ
\n-------------------
\n2012\/08\/21 00:32:23<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5907\u4efd\u6062\u590d\u8868\u7edf\u8ba1\u4fe1\u606f \u5728oracle\u4e2d\uff0c\u7edf\u8ba1\u4fe1\u606f\u662f\u5341\u5206\u91cd\u8981\u7684\uff0c\u5c24\u5176\u572810g\u4ee5\u540esql\u6267\u884c\u8ba1\u5212\u91c7\u7528CBO\u540e\uff0c\u8868\u4e0a\u7684 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,32],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/258"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=258"}],"version-history":[{"count":13,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/258\/revisions"}],"predecessor-version":[{"id":546,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/258\/revisions\/546"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=258"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}