Re: PL/SQL Error

Thanks for your contributions

I will check out for the MetaLink Note:233869.1 document! thanks~

On 2¿ù2ÀÏ, ¿ÀÈÄ9½Ã37ºÐ, "MTNorman" <mtnor..._at_duke-energy.com> wrote:
> 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 Sun Feb 04 2007 - 20:53:32 CST