Oracle的分析表和索引脚本
#!/bin/ksh
# analyze.ksh
ORACE_SID=XXX
export ORACLE_SID
ORACLE_HOME=`cat /var/opt/oracle/oratab|grep ^$ORACLE_SID: |cut -f2 -d':'``
export ORACLE_HOME
PATH = $ORACLE_HOME/bin:$PATH
export PATH
$ORACLE_HOME/bin/sqlplus /<
set page 999
set heading off
set echo off
set feedback off
connect internal;
spool /export/home/oracle/analyze.sql;
select
'analyze table '||owner||'.'||table_name||' estimate statistics sample 5000 rows;'
from
dba_tables
where
owner not in ('SYS','SYSTEM','PERFSTAT');
select
'analyze index '||owner||'.'||index_name||' estimate statistics sample 5000 rows;'
from
dba_indexes
where
owner not in ('SYS','SYSTEM','PERFSTAT');
spool off;
set echo on
set feedback on
@/export/home/oracle/analyze.sql;
exit
!
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/640706/viewspace-1043403/ ，如需转载，请注明出处，否则将追究法律责任。
