????4????????????

????a?????????????

-->???????
scott@CNMMBO> select * from v$version where rownum<2;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production

-->?????????
scott@CNMMBO> create table tb_emp as select * from emp;

-->?????????????
scott@CNMMBO> create index i_tb_emp_empno on tb_emp(empno);

-->?????????
scott@CNMMBO> exec dbms_stats.gather_table_stats('SCOTT'??'TB_EMP'??cascade=>true);

-->?????????
scott@CNMMBO> @idx_info
Enter value for owner: scott
Enter value for table_name: tb_emp

Table Name                INDEX_NAME                     CL_NAM               CL_POS STATUS   IDX_TYP         DSCD
------------------------- ------------------------------ -------------------- ------ -------- --------------- ----
TB_EMP                    I_TB_EMP_EMPNO                 EMPNO                     1 VALID    NORMAL          ASC

-->????????????
-->???use???NO??????????δ??????
scott@CNMMBO> @idx_usage_tb            
Enter value for 1: tb_emp
Enter value for 2: all
Enter value for 2: all

Table Name                INDEX_NAME                     USE START_MONITORING    END_MONITORING
------------------------- ------------------------------ --- ------------------- -------------------
TB_EMP                    I_TB_EMP_EMPNO                 NO  03/19/2013 17:43:49

-->????????
scott@CNMMBO> select empno??ename??job from tb_emp where empno=7788;

     EMPNO ENAME      JOB
---------- ---------- ---------
      7788 SCOTT      ANALYST

-->??β??USE??????YES
scott@CNMMBO> @idx_usage_tb
Enter value for 1: tb_emp
Enter value for 2: all
Enter value for 2: all

Table Name                INDEX_NAME                     USE START_MONITORING    END_MONITORING
------------------------- ------------------------------ --- ------------------- -------------------
TB_EMP                    I_TB_EMP_EMPNO                 YES 03/19/2013 17:43:49

-->???????????
scott@CNMMBO> alter index I_TB_EMP_EMPNO nomonitoring usage;

Index altered.

????b??schema????????????

-->?л???????????????cnbo1
scott@CNMMBO> conn goex_admin/xxxxx@cnbo1
Connected.

-->?????????????б???????????
goex_admin@CNBO1> @idx_usage;

no rows selected

-->???????????
goex_admin@CNBO1> @idx_monitor_on

INDEX_NAME                     MON USE START_MONITORING    END_MONITORING
------------------------------ --- --- ------------------- -------------------
PK_AAH                         YES NO  03/19/2013 17:48:32
IDX_GOAAE1                     YES NO  03/19/2013 17:48:32
PK_GOAAT                       YES NO  03/19/2013 17:48:32
PK_GOAACTL                     YES NO  03/19/2013 17:48:32
.......                            ................

-->??????????
goex_admin@CNBO1> @idx_monitor_off
INDEX_NAME                     MON USE START_MONITORING    END_MONITORING
------------------------------ --- --- ------------------- -------------------
PK_GOARL                       NO  NO  03/19/2013 17:48:30 03/19/2013 17:50:02
IDX_GOAQU1                     NO  NO  03/19/2013 17:48:30 03/19/2013 17:50:02
IDX_GOAQU2                     NO  NO  03/19/2013 17:48:30 03/19/2013 17:50:02

-->??????????db??????????????????????????
goex_admin@CNBO1> conn scott/tiger@cnmmbo

Connected.

goex_admin@CNMMBO> @idx_usage
Enter value for input_owner: GOEX_ADMIN
Enter value for input_owner: GOEX_ADMIN

OWNER           INDEX_NAME                     Table Name                MON USE START_MONITORING    END_MONITORING
--------------- ------------------------------ ------------------------- --- --- ------------------- ----------------
SCOTT           I_TB_EMP_EMPNO                 TB_EMP                    NO  YES 03/19/2013 17:43:49 03/19/2013 17:46:04
GOEX_ADMIN      ACC_GRP_EXT_INFO_TBL_LOG_PK    ACC_GRP_EXT_INFO_TBL_LOG  YES YES 02/22/2013 15:58:42
GOEX_ADMIN      IDX_TDCL_CONTRACT_NUM          TRADE_CLIENT_TBL          YES YES 02/22/2013 15:58:42
GOEX_ADMIN      IDX_TDCL_SETTLED_DATE          TRADE_CLIENT_TBL          YES YES 02/22/2013 15:58:42
GOEX_ADMIN      IDX_TDCL_ACC_NUM               TRADE_CLIENT_TBL          YES YES 02/22/2013 15:58:41
GOEX_ADMIN      IDX_TDCL_INSTRU_ID             TRADE_CLIENT_TBL          YES YES 02/22/2013 15:58:42

????5?????????????????

????a???????????????????????????????????y?????????????ж???????????

????b??????????????????μ?????ж?????????????????????

????c???????????????????????????????????????????????????????????????

????d??????????????????????????????????????????δ??????????????????b?????????????????