1. Check MEM Usage in the performance tab in Task Manager
2. Increase SGA/PGA
3. On Microsoft Windows OS, Oracle processes are implemented as threads
in one process and the limit is 2Gb (including stack, PGA, SGA). Run
this query
select sum(bytes)/1024/1024 TotalSizeInMB from
(select bytes from v$sgastat
union
select value bytes from
v$sesstat s,
v$statname n
where
n.STATISTIC# = s.STATISTIC# and
n.name = 'session pga memory'
);
HTH,
>
> 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>
>
>
> --------
> 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