Oracle index statement sorting

Oracle index statement sorting 1. create an index www.2cto.com create [unique] index index_name on table_name (col_1, col_2 ,...) tablespace tabspace_name; 2. alter index index_name pctfree 30 storage (initial 200 k next 200 k); 3. manually assign an index with the alter index index_name allocate extent (size 200 k datafile '$ ORACLE/oradata /.. '); 4. release useless space in the index alter index index_name deallocate unused; 5. index reconstruction alter index index_name rebuild tablespace tablespace_name; 6. alter index index_name rebuild tablespace tablespace_name reverse; 7. when the index is re-built, the alter index index_name rebuild online table is not locked; 8. alter index index_name COALESCE; 9. analyze index index_name validate structure; desc index_state; drop index index_name; www.2cto.com 10. monitor whether the index is used by alter index index_name monitoring usage; 11. cancel monitoring alter index index_name nomonitoring usage; 12. select * from dba_indexes/dba_ind_columns/user_indexes/user_ind_columns/dbs_ind _
EXPressions/v $ object_usage;