{"id":301,"date":"2013-01-12T16:33:54","date_gmt":"2013-01-12T08:33:54","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=301"},"modified":"2013-01-12T21:05:09","modified_gmt":"2013-01-12T13:05:09","slug":"%e9%87%8d%e5%bb%ba%e7%b4%a2%e5%bc%95%e5%90%8e%e6%98%af%e5%90%a6%e8%87%aa%e5%8a%a8%e5%88%86%e6%9e%90%e8%a1%a8%e5%92%8c%e7%b4%a2%e5%bc%959i10g11g","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=301","title":{"rendered":"\u91cd\u5efa\u7d22\u5f15\u540e\u662f\u5426\u81ea\u52a8\u5206\u6790\u8868\u548c\u7d22\u5f15(9i+10g+11g)"},"content":{"rendered":"

\u91cd\u5efa\u7d22\u5f15\u540e\u662f\u5426\u81ea\u52a8\u5206\u6790\u8868\u548c\u7d22\u5f15(9i+10g+11g)<\/p>\n

--9i\u5e93
\nSQL> select * from v$version where rownum<5;<\/p>\n

BANNER
\n----------------------------------------------------------------
\nOracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
\nPL\/SQL Release 9.2.0.6.0 - Production
\nCORE 9.2.0.6.0 Production
\nTNS for HPUX: Version 9.2.0.6.0 - Production<\/p>\n

--\u5efa\u6d4b\u8bd5\u8868
\nSQL> create table test1(id number,name varchar2(10));<\/p>\n

Table created.<\/p>\n

Elapsed: 00:00:00.00
\nSQL> insert into test1 values (1,'yallonking');<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

Commit complete.<\/p>\n

--\u5efa\u7d22\u5f15
\nSQL> create index idx_test on test1(id);<\/p>\n

Index created.
\n--\u8868\u548c\u7d22\u5f15\u7684\u5747\u6ca1\u6709\u5206\u6790
\nSQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------<\/p>\n

--\u6536\u96c6\u8868\u4fe1\u606f
\nSQL> analyze table test1 compute statistics;<\/p>\n

Table analyzed.<\/p>\n

--\u8868\u548c\u7d22\u5f15\u4fe1\u606f\u5df2\u5b58\u5728
\nSQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:17:44<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:17:44<\/p>\n

--\u8bb0\u5f55\u5f53\u524d\u65f6\u95f4
\nSQL> select sysdate from dual;<\/p>\n

SYSDATE
\n-------------------
\n2012\/09\/08 11:18:23<\/p>\n

--\u91cd\u5efa\u7d22\u5f15
\nSQL> alter index idx_test rebuild;<\/p>\n

Index altered.<\/p>\n

SQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:17:44<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:17:44<\/p>\n

--\u5728\u7ebf\u91cd\u5efa\u7d22\u5f15
\nSQL> alter index idx_test rebuild online;<\/p>\n

Index altered.<\/p>\n

Elapsed: 00:00:00.18<\/p>\n

--\u67e5\u770b\u8868\u548c\u7d22\u5f15\u5206\u6790\u65f6\u95f4\uff08\u672a\u53d8\uff09
\nSQL> alter index idx_test rebuild online;<\/p>\n

Index altered.<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:17:44<\/p>\n

SQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:17:44<\/p>\n

--10g\u5e93
\nSQL> select * from v$version where rownum<5;<\/p>\n

BANNER
\n----------------------------------------------------------------
\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
\nPL\/SQL Release 10.2.0.4.0 - Production
\nCORE 10.2.0.4.0 Production
\nTNS for IBM\/AIX RISC System\/6000: Version 10.2.0.4.0 - Productio<\/p>\n

--\u5efa\u6d4b\u8bd5\u8868
\nSQL> create table test1(id number,name varchar2(10));<\/p>\n

Table created.<\/p>\n

SQL> insert into test1 values (1,'yallonking');<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

Commit complete.<\/p>\n

--\u5efa\u7d22\u5f15
\nSQL> create index idx_test on test1(id);<\/p>\n

Index created.<\/p>\n

--\u8868\u6ca1\u6709\u5206\u6790\u4f46\u662f\u6b64\u65f6\u7d22\u5f15\u7684\u5374\u8fdb\u884c\u4e86\u5206\u6790\uff08\u548c9i\u4e0d\u540c\uff09
\nSQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:44:13<\/p>\n

--\u6536\u96c6\u8868\u4fe1\u606f
\nSQL> analyze table test1 compute statistics;<\/p>\n

Table analyzed.<\/p>\n

--\u8868\u548c\u7d22\u5f15\u4fe1\u606f\u5df2\u5b58\u5728
\nSQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:44:38<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:44:38<\/p>\n

--\u8bb0\u5f55\u5f53\u524d\u65f6\u95f4
\nSQL> select sysdate from dual;<\/p>\n

SYSDATE
\n-------------------
\n2012\/09\/08 11:45:10<\/p>\n

--\u91cd\u5efa\u7d22\u5f15
\nSQL> alter index idx_test rebuild;<\/p>\n

Index altered.<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:45:34<\/p>\n

SQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:44:38<\/p>\n

--\u5728\u7ebf\u91cd\u5efa\u7d22\u5f15
\nSQL> alter index idx_test rebuild online;<\/p>\n

Index altered.<\/p>\n

SQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:44:38<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:46:05<\/p>\n

--11g\u5e93
\nSQL> select * from v$version where rownum<5;<\/p>\n

BANNER
\n--------------------------------------------------------------------------------
\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
\nPL\/SQL Release 11.2.0.1.0 - Production
\nCORE 11.2.0.1.0 Production
\nTNS for Linux: Version 11.2.0.1.0 - Production<\/p>\n

--\u5efa\u6d4b\u8bd5\u8868
\nSQL> create table test1(id number,name varchar2(10));<\/p>\n

Table created.<\/p>\n

SQL> insert into test1 values (1,'yallonking');<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

Commit complete.<\/p>\n

--\u5efa\u7d22\u5f15
\nSQL> create index idx_test on test1(id);<\/p>\n

Index created.
\n--\u8868\u548c\u7d22\u5f15\u7684\u5747\u6ca1\u6709\u5206\u6790
\nSQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:10:45<\/p>\n

--\u6536\u96c6\u8868\u4fe1\u606f
\nSQL> analyze table test1 compute statistics;<\/p>\n

Table analyzed.<\/p>\n

--\u8868\u548c\u7d22\u5f15\u4fe1\u606f\u5df2\u5b58\u5728
\nSQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:11:12<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:11:12<\/p>\n

--\u8bb0\u5f55\u5f53\u524d\u65f6\u95f4
\nSQL> select sysdate from dual;<\/p>\n

SYSDATE
\n-------------------
\n2012\/09\/08 11:11:37<\/p>\n

--\u91cd\u5efa\u7d22\u5f15
\nSQL> alter index idx_test rebuild;<\/p>\n

Index altered.<\/p>\n

SQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:11:12<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:11:51<\/p>\n

--\u5728\u7ebf\u91cd\u5efa\u7d22\u5f15
\nSQL> alter index idx_test rebuild online;<\/p>\n

Index altered.<\/p>\n

SQL> select LAST_ANALYZED from user_tables where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:11:12<\/p>\n

SQL> select LAST_ANALYZED from user_indexes where table_name='TEST1';<\/p>\n

LAST_ANALYZED
\n-------------------
\n2012\/09\/08 11:12:16<\/p>\n

\u7ed3\u8bba\uff1a\u5173\u4e8e\u7d22\u5f15\u662f\u5426\u5206\u6790\u89c1\u4e0b\u7b80\u8868
\n\u5e93\u7248\u672c 9i\u5e93 10g\u5e93 11g\u5e93
\n\u521b\u5efa\u65f6\u662f\u5426\u5206\u6790 \u5426 \u662f \u662f
\n\u975e\u5728\u7ebf\u91cd\u5efa\u7d22\u5f15\u662f\u5426\u5206\u6790 \u5426 \u662f \u662f
\n\u5728\u7ebf\u91cd\u5efa\u662f\u5426\u5206\u6790 \u5426 \u662f \u662f<\/p>\n

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

\u91cd\u5efa\u7d22\u5f15\u540e\u662f\u5426\u81ea\u52a8\u5206\u6790\u8868\u548c\u7d22\u5f15(9i+10g+11g) –9i\u5e93 SQL> select * from […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,37],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/301"}],"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=301"}],"version-history":[{"count":4,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":487,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions\/487"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}