Re: 4030
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: ranko.mosic@xxxxxxxxx
- Date: Mon, 25 Apr 2005 13:03:27 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
