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 ?