查看是否还在使用特定的索引或者sql

select index_name,monitoring,used,start_monitoring,end_monitoring from v$object_usage;

alter index IDX_AUCFEED_RATED nomonitoring usage;

获取share pool中的sql
select sql_text from v$sql where lower(sql_text) like '%xx%' and last_active_time > sysdate - 1;