Urgent: ora-04030 out of process memory when trying to allocate string bytes (string,string)

Urgent: ora-04030 out of process memory when trying to allocate string bytes (string,string)

 

  

Hi, freinds

I am continously getting this error .. when my batch running process is
going on..

my sga size is 480M and my pga_aggregate_target=50M and hash_area is
enabled.

I am using Oracle 9.0 on windows 2000 server. Is there any limitation for
oracle on windows 2000 for size of SGA AND pga_aggregate_target...

please let me know as early as possible...

It's too urgent and will be too much helpful for me..

Bhavin.....
----- Original Message -----
From: "Bhavin " <oracledba-ezmlmshield-x99004571.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 02, 2005 4:47 PM
Subject: ora-04030 out of process memory when trying to allocate string
bytes (string,string)


> Hi gurus,
>
> I got a error when batch running process is running..
>
> ora-04030 out of process memory when trying to allocate string bytes
(string,string)
>
> Pl. tell me cause and remedy to solve this error..
>
> My ram size is : 1G and my Pga_aggregate_target=50Mb
>
> Regards,
>
> Bhavin Shah
>
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page