A SERVICE OF

logo

5 Database Administration Decreasing the Database Storage Size
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 221
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