Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Error

Re: PL/SQL Error

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Feb 2007 16:34:03 -0800
Message-ID: <1170462843.828822@bubbleator.drizzle.com>


cspang97_at_gmail.com wrote:
> After running pl/sql package about 2~3 hours, "ORA-04030: out of
> process memory when trying to allocate 52456 bytes (pga heap, ksm
> stack)" ERROR occurred. This problem drove me crazy past two weeks.
> Compiling the package was successfully executed. And everything seems
> fine. But
> Whenever I did the executing of the packages. i finally got to meet
> the conflict.
>
> Please! Help me~~

No version number.
No operating system.
No memory related pfile parameters.

Follow Joel's advice and if it doesn't help post something we can use to help you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Feb 02 2007 - 18:34:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US