Re: Issue ORA-04030

see -- on windows 32 the entire thing (SGA + PGA) can not go beyond 2GB-3GB (user space process limit, Vista should have /3gb switch but I'm not 100% sure, don't run Vista myself) as Oracle is being run as a single process.

most likely spatial is not leaking anything -- it just tries to allocate more memory than OS can give, look at v$sesstat for it and see what exactly is being allocated (uga/pga and how much)

first thing you can try is reduce your SGA and see if process will still fail and if it does -- it should do it later as more memory should be available

On Mon, Jan 19, 2009 at 10:53 AM, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:
> 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
>
>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l