4030 2005-04-25 - By Niall Litchfield
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@(protected)> 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@(protected)> wrote:
> > Ummmm... Did you look the error up in the documentation?
> >=3D20
> > -- --Original Message-- --
> > From: Ranko Mosic [mailto:ranko.mosic@(protected)]
> > Sent: Monday, April 25, 2005 8:47 AM
> > To: oracle-l@(protected)
> > Subject: 4030
> >=3D20
> > Got this ( windows )
> >=3D20
> > ORA-04030 (See ORA-04030.ora-code.com): 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
|
|
