统计信息定期收集

#/bin/sh

DB_HOST=localhost
DB_NAME=OSRDB
DB_USR=SYSDBA
DB_PASSWD=szoscar55
DB_PORT=2003


if [ -n "$1" ]
then
  DB_HOST="$1"
fi

if [ -n "$2" ]
then
  DB_NAME=$2
fi

if [ -n "$3" ]
then
  DB_USR=$3
fi

if [ -n "$4" ]
then
  DB_PASSWD=$4
fi

if [ -n "$5" ]
then
  DB_PORT=$5
fi

service oscardb_${DB_NAME}d status
srv_status=$?
if [ $srv_status -eq 0 ]
then
if [ `ps -ef | grep oscar | grep -i -w ${DB_NAME} | grep -v grep | wc -l` -ne 0 ]
then

service oscaragentd start

eval sed -i 's/JOB_ENABLE=FALSE/JOB_ENABLE=TRUE/' $SZ_OSCAR_HOME/agent/agent.conf
eval sed -i 's/JOB_DBNAME=OSRDB/JOB_DBNAME=$DB_NAME/' $SZ_OSCAR_HOME/agent/agent.conf
eval sed -i 's/JOB_USERNAME=sysdba/JOB_USERNAME=$DB_USR/' $SZ_OSCAR_HOME/agent/agent.conf
eval sed -i 's/JOB_PASSWORD=szoscar55/JOB_PASSWORD=$DB_PASSWD/' $SZ_OSCAR_HOME/agent/agent.conf
eval sed -i 's/JOB_DBPORT=2003/JOB_DBPORT=$DB_PORT/' $SZ_OSCAR_HOME/agent/agent.conf

$SZ_OSCAR_HOME/bin/isql -h "$DB_HOST" -d $DB_NAME -U$DB_USR/$DB_PASSWD -p $DB_PORT <<EOF
EXEC dbms_job.isubmit(1314,'DBMS_UTILITY.ANALYZE_DATABASE(''COMPUTE'');',TRUNC(CURTIMESTAMP()+1),'CURTIMESTAMP+1');
EXEC dbms_job.run(1314);
EOF

service oscaragentd restart

fi
fi