Home » RDBMS Server » Server Administration » ORA-04030 during stress testing (Oracle 10G on Solaris 10)
ORA-04030 during stress testing [message #322293] Fri, 23 May 2008 00:41 Go to next message
Messages: 1
Registered: May 2008
Location: Pune
Junior Member
We are doing longitivity testing with our application. ( we want to run it for 6 days)
We have one application which is simultaneously connecting to Oracle database
With 30 connections (can be set even more) and executes set of Complex
SELECT statements in round-robin fashion.
However after running for 5-6 hours we are getting following error:

ORA-04030: out of process memory when trying to allocate 123416 bytes

Has some one case across this scenario, Could you please provide us recommended setting at database side.
We are running oracle 10g (SGA_TARGET=2GB) on Solaris ( 4 GB RAM)

We do not use bing variables in our application. Basically we are doing some kind of stress testing on database side and do not wanted to tune application.
Is there any setting with the help of which I can keep it running ( we are not looking for performance in this stage)
Re: ORA-04030 during stress testing [message #322295 is a reply to message #322293] Fri, 23 May 2008 00:44 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ 4030 is OS process memory error, no relation with SGA. Check ulimit.
2/ If you don't want to use bind variables, whatever you do at instance side is useless. You're just wasting your time.

Previous Topic: SCN
Next Topic: which character set is suitable for Euro
Goto Forum:

Current Time: Mon Oct 24 15:58:57 CDT 2016

Total time taken to generate the page: 0.09580 seconds