-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
Hey PAVB,
the /3G resolution is sadly no way in my eyes.
Is there a option to limit something?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|