Oracle Database Discussions

I'm sporadically seeing oracle return ORA-00942 error message when making a database call with the confines of my continuous integration system.

To setup some context, I am working with an automated build system to build and test our app. When the load is light, e.g., I am testing a few instanaces of the application, this problem does not appear.
However, if many instances of the app are being tested at once this error will periodically appear.

We have one oracle instance and each app being tested has its own table space. I've increased the number of processes and sessions. Processes count is now at 400.

Can process count (running out) cause this error? I'm not specifically out of process errors anymore.


I'm looking for some advice on how better to diagnose this issue or a point in the right direction. I know my problem is load related I just don't know where to go from here.

Thanks!
Ruel Loehr