Re: 4030

On 04/25/2005 08:46:45 AM, Ranko Mosic wrote:
> Got this ( windows )

>=20
> ORA-04030: out of process memory when trying to allocate 16396 bytes (koh=
-k=3D
> ghu
> call ,pl/sql: adt/record)

>=20
> What should I do ?=3D20

First thing to do is to take a look at V$SGASTAT where lower(name) like '%= free%'.
If your SGA is too small, increase it (shared pool). Second thing is to set=  event
4030 trace name errorstack forever, level 10. That will give you the exact = location
and dump of the ailing process. See what can you read from the trace file. = Open a TAR
if necessary.

--=20
Mladen Gogala
Oracle DBA

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