Re: Out of Process Memory with PL/SQL 8.04

From: <twod_at_not.valid>
Date: 29 Jun 1998 06:28:02 GMT
Message-ID: <6n7c5i$n8b$1@vnetnews.value.net>

: > We are running into an "out of process memory" error while trying to execute
: > a PL/SQL package procedure using SQLPLUS on a DEC Alpha 4100 Digital Unix
: > server with 512MB RAM. Our SGA is about 15MB and our DB buffers are about
: > 20MB. The swap size is 1,300MB. Taking away the memory used by SGAs of the
: > databases, approximately 400MB is available for any process. We are running
: > Oracle and PL/SQL 8.04, and our Digital UNIX is version 4.0b.

If you have not already done so, looking at patching to 8.0.4.1. I just installed 8.0.4.0 on a 4.0d machine with 4Gb of RAM and was getting a lot of memory related errors until I patched - not least the ability to get a decent sized SGA due to a mtprotect() error/bug in OSF.

The patch set, approx 25Mb, is available from Oracle's support web pages.

IAP Received on Mon Jun 29 1998 - 01:28:02 CDT