Ora-04030

Hi,
i have a problem with my 10.2.0.1 Database on Windows 2003 Server SP1.

nested exception is java.sql.SQLException: ORA-04030: Zu wenig Prozessspeicher für Versuch xxxxx Bytes zuzuweisen (QERHJ hash-joi,kllcqas:kllsltba)

What is the best solution method?

Thanks

have you conducted a search on this forum looking for "ORA-04030"?

There are 49 threads about it.

yes i searched in the forum and confused about it.
i only found 19 threads

"change parameter SGA and/or PGA" or ....

I do not want to change blindly any parameters
can you post me the link to the entry?

Metalink Note #233869.1 -Diagnosing and Resolving ORA-4030 errors

for testing i changed the pga_aggregate_target on the init.ora file on a refference machine/DB to 10 MB.
(orginal was 450 MB)

I am wrong or should get I not then also an error there?!

aggregate PGA target was 10 MB, but "total PGA inuse" and "total PGA allocated" was over 10MB :confused:

Hey PAVB,
the /3G resolution is sadly no way in my eyes.
Is there a option to limit something?

Thanks