oracle 腳本 索引,Oracle的分析表和索引腳本

Oracle的分析表和索引腳本[@more@]

#!/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

!