#######################################################################
#
# analyze.sh
#
# Scripts to analyze schema/s , where schema name is
passed as argument
#
#########################################################################
for i in `echo $*`
do
echo " "
echo " "
echo "---------- Analyzing schema $i
-------------"
echo " "
echo " "
sqlplus -s /nolog <<EOF
conn / as sysdba
exec dbms_stats.gather_schema_stats('$i');
exit
EOF
done
Output :
$ ./analyze.sh scott test
---------- Analyzing schema scott -------------
PL/SQL procedure successfully completed.
---------- Analyzing schema test -------------
PL/SQL procedure successfully completed.
