Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry

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