increase shared pool size

On Thu, 2005-03-03 at 05:54, Bhavin wrote:
> 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
> >
> >
>
>
>
>
> --------
> 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