Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection are not reused

vijay kkJan 23 2025

I have situation wherein middleware connection pool getting ora-session_per_user exceeded .

while checking at db level last_call_et ,seconds_in_wait says 90% of connections are idle for more than 7 days.

questions .

a. why connection pool trying to create new connection while existing is idle ? any issue at middleware level

or bug at oracle level or program not releasing it properly for reuse ?

Comments
Post Details
Added on Jan 23 2025
0 comments
102 views