Re: Weird database hanging

I would strongly suggest that the initial and maximum number of connections for the pool be set to the same. The common paradigm is that max is set to significantly more than initial, the db slows, the mid-tier starts more connections because of connection response time, and now you have a "paddles ... clear!" database on your hands and the only solution is to restart the entire stack. Probably the worst thing to do to a slow/distressed database is throw a connection storm at it.

If you think you are experiencing logon issues, AWR reports will show you the logon rate in the "Load Profile" section.

On 9/19/07, Don Seiler <don_at_seiler.us> wrote:
> We are using JBOSS 4.0.5GA. Does anyone have handy any configuration
> options I should look at in terms of these connection pool issues?

Regards,

Greg Rahn
http://structureddata.org

--
http://www.freelists.org/webpage/oracle-l