Whether the Oracle Monitoring index is enabled

Creating an Oracle Index: CREATE INDEX DEFECT_SUBMIT_DATE_IDX on DEFECT (submit_date);
Create INDEX Defect_dbid_submit_date_idx on DEFECT (DBID, submit_date); Delete indexes: Drop index DEFECT_SUBMIT_DATE_IDX; Set monitoring index: ALTER index DEFECT_SUBMIT_DATE_IDX monitoring Usage;alter index DEFECT_DBID_SUBMIT_DATE_IDX monitoring usage; Display monitoring results: Select INDEX_NAME, TABLE_NAME, monitoring, used from v$object_usage; Show Oracle Index: Select Index_name, Index_type, uniqueness from user_indexes where table_name= ' DEFECT ';