-- 查看索引的状态、所有者、类型、表名、表类型、索引类型、表空间、是否日志归档、最后分析时间
spool e:\qin_daily\索引状态监控_script005
set wrap off
set linesize 1000
set pagesize 40
col owner for a8
col index_type for a10
col table_owner for a11
col table_name for a25
col LAST_ANALYZED for a13
select OWNER,
INDEX_NAME,
INDEX_TYPE,
STATUS,
TABLE_NAME,
TABLE_TYPE,
UNIQUENESS,
TABLESPACE_NAME,
LOGGING,
NUM_ROWS,
LAST_ANALYZED
from dba_indexes
where wner = 'ITSPF'
order by status desc;
spool off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12330444/viewspace-434591/ ，如需转载，请注明出处，否则将追究法律责任。
