A SERVICE OF

logo

5 Database Administration Increasing the Shared Pool Size
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 223
if /usr/lbin/orastat -s >/dev/null
then
:
else
ulimit 2113674; ior w
fi
# perform the cron jobs
$VSUTIL/cdhsum
$VSUTIL/cdhdel -2
$VSUTIL/ccasum
$VSUTIL/ccadel -4
# cleanout the unwanted ORACLE files
$VSUTIL/logdel
/vs/bin/util/dbcheck -w 15,20
Increasing the Shared Pool Size
Perform this procedure to allocate additional memory resources for ORACLE.
You may need to do this if the system is trying to write to several database
tables at once and you receive the ORACLE error message number ORA-
04031 in the message log.
Note: This procedure increases the amount of main memory that
ORACLE uses.