All apps dba Blog is the blog contributed by Doyensys Employees, With the view to share the knowledge out of their experience.
Doyensys Is a Fast Growing Oracle Technology Based Solutions Company Located in the US And Offshore Delivery Centers in India. With rich experience In Oracle E-Business, Oracle Database, Oracle Application Express (APEX), Oracle J Developer, Oracle OBIEE and E-Business Suite

DOYENSYS Knowledge Portal

Saturday, October 3, 2015

How to gather stats for single table using shell script

#usage S_ACT_EMP_stats.ksh <DBPASSWD>
. /home/oracle/ora_PROD.env

export MAILEE="xyz@doyensys.com"

$ORACLE_HOME/bin/sqlplus -s $CONNECT_DBA << EOF > /home/oracle/siebel_stats_gathering/S_ACT_EMP.log
set head off
set pagesize 0
set linesize 100
set feed off
set trimspool off
set time on
set timing on