Re: EXPort memory problem

From: Chris Hamilton <chrish_at_cmprime.att.com>
Date: 1997/02/21
Message-ID: <01bc2033$0c945580$2d89b687@chrish-pc.cis.att.com>#1/1

Brett Cunningham wrote...

> I have a 7.1.4.1.1 system on which I am receiving the following errors
> while performing an EXPort:
>
> ORA-04030: out of process memory while trying to allocate 1624 bytes
> ORA-07324: smpall: malloc error while allocating pga
>
> This is a Digital Unix box. I know the problem is system-related, but
> is there a way I can alter the export parameters in order to require
 fewer
> OS resources ? (I took the default buffer size) The table in question is
 

> over a gig in size and contains a long raw field.

This is due to a lack of CONTIGUOUS shared memory in the SGA and is a known bug. You can alleviate it by doing an 'ALTER SYSTEM FLUSH SHARED_POOL' periodically.

I think the bug was fixed in 7.2, definitely in 7.3.

Chris

---

Chris Hamilton -- chrish_at_cmprime.att.com DBA, AT&T WorldNet Service - Lincroft, NJ http://www.serve.com/cowpb/chamilton.html Received on Fri Feb 21 1997 - 00:00:00 CST