Have you done your homework on the Oracle side? Please have a look here
https://openacs.org/doc/current/maint-performance.htmlOtherwise 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 :)