Re: 4030

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 25 Apr 2005 14:57:36 +0100
Message-ID: <7765c8970504250657119968b@mail.gmail.com>

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_at_gmail.com> 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_at_labor.state.ny.us> wrote:
> > Ummmm... Did you look the error up in the documentation?
> >=3D20
> > -----Original Message-----
> > From: Ranko Mosic [mailto:ranko.mosic_at_gmail.com]
> > Sent: Monday, April 25, 2005 8:47 AM
> > To: oracle-l_at_freelists.org
> > 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.
> > --
> > http://www.freelists.org/webpage/oracle-l
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 25 2005 - 10:01:52 CDT