只需要执行以下脚本:
set pages 999;
set heading off;
spool run_monitor.sql
select 'alter index '||owner||'.'||index_name||' monitoring usage;'
from
dba_indexes
where
owner not in ('SYS','SYSTEM','PERFSTAT');
spool off;
@run_monitor
又如:
set pages 999;
set heading off;
spool run_monitor.sql
SELECT 'GRANT SELECT ON '||TNAME||' TO SDGA;' FROM TAB;
spool off;
@run_monitor