| ORA-04030 during stress testing [message #322293] |
Fri, 23 May 2008 00:41  |
pgb710
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
