index_name and job

1：有时候在tuning sql 查看执行计划的时候，特别需要查看表的索引，使用all_indexes /dba_indexes特别有用

2：查看正在运行的JOB;

select owner,table_name,index_name
from all_indexes
where owner='WILIAM'
AND TABLE_NAME LIKE'TB_SALE';

OWNER TABLE_NAME INDEX_NAME
------------------------------ ------------------------------ ----------------------

--------
WILIAM TB_SALE IDX2_TB_SALE
WILIAM TB_SALE IDX_TB_SALE
WILIAM TB_SALE PK_TB_SALE

DBA_INDEXES
区别：table_owner

select TABLE_owner,table_name,index_name
from DBA_indexes
where TABLE_owner='WILIAM'
AND TABLE_NAME ='TB_SALE';

查看正在运行的job
select sid,job from dba_jobs_running;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22934571/viewspace-1044920/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22934571/viewspace-1044920/