Forum OpenACS Q&A: Re: Correct Configuration Parameters to use all Server Resources

Have you done your homework on the Oracle side? Please have a look here

Otherwise it looks like your server is running out of threads to handle requests. Clustering would help very quickly - isn't the clustering package in use in a few of the big .LRN sites?

(And fixing those long-running queries :)