Follwing is the script for manually gathering Stats using DBMS_STATS.
Execution will be like
./analyze_schema.ksh /oracle/app/oracle/oraprocs/ora_SID.env CIF
– Script Start
#!/usr/bin/ksh
########## Configuration #############
ENV_FILE=$1
SCHEMA_NAME=$2