Hi All.
We are struggling to track down a recurring problem in exceeding the
maximum open cursors threshold within Oracle. This problem seems to
creep up over a period of time. We've seen it rear its ugly head about
3 times in the past month, and it brings the portal to a screeching
halt. We steadily increased the threshold in Oracle, but now we are
above the recommended value (500 - 1000), and we are not having a lot of
luck tracking down the root cause.
Our portal implementation is very basic at the moment. We have a
controlled audience, and we do not currently allow user customizations
in the environment in question. A lot of the documentation and chat on
this issue talks about ensuring that all cursors and result sets are
closed when finished, but there is some speculation over how actively
that has to be managed. Additionally, we have looked into the
implications of connection pooling, and that seems to push the solutions
into a more shadowy area.
If anyone has any advise on where to look or what to look for, it would
be greatly appreciated. I hate to call people out, but I did see Mr.
Petro's name on some of the DBCPDataSourceFactory code comments. I hope
he has a notion to comment (Andrew?), because I may have some additional
questions on that piece of the puzzle as well.
Thanks a bunch everybody...
Tim
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions: The
Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
