5 Database Administration

Decreasing the Database Storage Size

The following is a sample croncdh file:

# Start the ORACLE DBMS

VSUTIL=/vs/bin/util

ORACLE_SID=A;export ORACLE_SID

ORACLE_HOME=‘/usr/lbin/dbhome $ORACLE_SID‘ PATH=$PATH:$ORACLE_HOME/bin;export PATH ulimit 2113674

if /usr/lbin/orastat -s >/dev/null

then

:

else

ulimit 2113674; ior w fi

# perform the cron jobs

$VSUTIL/cdhsum $VSUTIL/cdhdel $VSUTIL/ccasum $VSUTIL/ccadel

#cleanout the unwanted ORACLE log files $VSUTIL/logdel

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 221