Re: 4030
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: ranko.mosic@xxxxxxxxx
- Date: Mon, 25 Apr 2005 14:57:36 +0100
The limit for process memory on 32bit windows is circa 1.7gb. So yes
you'll need to reduce one or both of the parameter values.
a 1.5gb sga *sounds* high to me for a windows database, but you'll
know how and why you've allocated that much ram.
On 4/25/05, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:
> This is on Windows 2000. SGA is 1.5G. Plenty of OS (physical memory).
> PGA_AGGREGATE_TARGET =3D3D 500M.=3D20
> Probably hitting Win 2G limit for Oracle process.=3D20
> Would lowering SGA, incresing PGA_AGGR... help ?=3D20
> This is multiple simultaneous processes.=3D20
> rm=3D20
>=20
> On 4/25/05, Mercadante, Thomas F (LABOR)
> <thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> > Ummmm... Did you look the error up in the documentation?
> >=3D20
> > -----Original Message-----
> > From: Ranko Mosic [mailto:ranko.mosic@xxxxxxxxx]
> > Sent: Monday, April 25, 2005 8:47 AM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: 4030
> >=3D20
> > Got this ( windows )
> >=3D20
> > ORA-04030: out of process memory when trying to allocate 16396 bytes (k=
oh=3D
> -k=3D3D
> > ghu
> > call ,pl/sql: adt/record)
> >=3D20
> > What should I do ?=3D3D20
> >=3D20
> > Thanks, Ranko.
> > --
> > //www.freelists.org/webpage/oracle-l
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
