Re: PL/SQL Error

From: MTNorman <mtnorman_at_duke-energy.com>
Date: 2 Feb 2007 04:37:27 -0800
Message-ID: <1170419847.314338.203060@v45g2000cwv.googlegroups.com>

On Feb 2, 7:13 am, "cspan..._at_gmail.com" <cspan..._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~~

Have you checked out MetaLink Note:233869.1?

The first step is to identify if your system is really out of memory or if some parameter setting is not allowing all the available memory to be used.

What version of oracle?
What server platform?
How much RAM? for how many users?
What does the package do for "2-3 hours"? Are you using explicit cursors?
Are you using varrays or nested table collections? Received on Fri Feb 02 2007 - 06:37:27 CST