Re: Issue ORA-04030

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Mon, 19 Jan 2009 13:53:38 -0200
Message-ID: <90b7e6bd0901190753q109e5a1bg6ccfd4167a408454_at_mail.gmail.com>



Alex,

The OS is Windows Vista, 32 bits.
4gb ram

I just need to know why the Oracle Spatial does not release the memory and takes the process to the memory leak.

I found that I need to close and open a new session as workaround.

I am testing it now.

Regards
Eriovaldo

On Mon, Jan 19, 2009 at 12:47 AM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:

> That's OS related thing. Might be one of your ulimits or simply asking
> too much :-)
>
> What's your OS?
>
> Also, check v$sesstat for max pga memory allocation for your spatial
> session -- what's the number there?
>
> > Is there anything wrong ?
>
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
> http://www.linkedin.com/in/alexfatkulin
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 19 2009 - 09:53:38 CST

Original text of this message