TCP Connection

[mikaufmann]

Hi i have the odac components V9.6.21
when i close a connection the tcp ip port are open until 5 min. in status wait.
i testing that with
pooled = false / true
Direct = true
threadsave = true / false

I have a application server with 500 client.
the client open a session over the application server write the the information to the oracle server and then close the session.
and that all 1 min.

the problem is
1) the handles of the application server 30000
2) the tcp connections (1000)
3) the oracle server is very slow and i see the connection (1000) in wait position

it is possible i disconnect and the tcp connection closed also in the same time? without a wait from 5 min.
best regards
Michael

[MaximG]

In ODAC, there are no settings related to the waiting time of TCP port on the Oracle server when closing the connection with the client. To clarify this behavior, you can contact Oracle Support.
Try using ODAC OCI Mode to check if the waiting time changes when the connection is closed in this case.