oracle收集统计信息

date=`date +%Y%m%d -d "-740 days"`
date1=`date +%Y%m%d -d "-1 days"`
sqlplus -s '/ as sysdba' <<EOF
set feed off
set linesize 100
set pagesize 200
exec dbms_stats.gather_schema_stats(ownname => user',options => 'GATHER AUTO', estimate_percent => dbms_stats.auto_sample_size,method_opt =>'for all columns size auto',cascade=> TRUE);
exec dbms_stats.gather_table_stats(ownname => 'user',tabname=>'RAW_VEH_PACKAGE$date1',estimate_percent => dbms_stats.auto_sample_size,method_opt =>'for all columns size auto',cascade=> TRUE);
EOF
exit