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!

Inactive session and waiting?

Jch10Jul 3 2018 — edited Jul 4 2018

Hi, I have a question about this behavior:

I've too many sessions working with a JDBC THIN CLIENT (around 101 sessions) I guess is a "JDBC Pool"  but right now all of them are with "INACTIVE" status.

I can see all sessions despite being INACTIVE  they've waiting events. for example one of them has the event "SQL*NET message from client" its state is "waiting" and "seconds in wait" are still increasing.

Its description says:

Waiting for SQL*Net message from client - waited 234446 seconds, so far

How can I avoid or tunning that behavior.

Thanks for your help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2018
Added on Jul 3 2018
6 comments
4,283 views