HP R4.2 User Manual

Page 260

Advertising
background image

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

Advertising