5 Database Administration

Increasing the Shared Pool Size

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.

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 223