. $HOME/.profile
partname=TERM_TRAN_LOG_TBL_`date +%Y%m`
export ORACLE_SID=hzbk
echo $$ > /hzbkbackup/today.spid
sqlplus -S "/as sysdba" <<EOF >>/hzbkbackup/stat/stats_term_tran_log_tblnew.log
host date
set timing on
exec dbms_stats.gather_table_stats(ownname => 'busbike',tabname => 'term_tran_log_tbl',partname=> '$partname',estimate_percent=>10,degree =>6,cascade => true,method_opt => 'for all columns size repeat');
exit
EOF




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件