查看索引是否失效

检查Oracle索引是否有效

col owner for a10
col table_name for a30
col index_name for a30
col status for a15
col tablespace_name for a15
set linesize 300 pagesize 300
select owner, table_name, tablespace_name, index_name, index_type, status
  from dba_indexes
 where index_name like '%LIS_REQMAIN%';