Quote Originally Posted by hitensharma View Post
They are in same subnet. I have written a procedure which upon login checks how many connections are made from particular terminal. If the connections exceeds limit, then it displays the message and raise the error.

But there is one problem in this case. If a user is connected from particular terminal and it is disconnected due to network problem, the user is still shown in v$session. So next time user tries to login, it shows error that the user is already connected so can not have more than 1 connection.

Somebody suggested to kill the sessions depending upon idle time but we kill idle sessions which are idle for more than 30 minutes.

Is there any way to find the sessions which are dead/disconnected ? Just looking at status and Idle time wont work.

Regards,
Hiten
You need to enable DCD(Dead Connection Detection). Refer Doc ID: 601605.1 in metalink