Increasing the shared pool size – HP R4.2 User Manual

Page 262

Advertising
background image

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.

Advertising