|
-
Thanks to all for your support.
Finally adding SQLNET.EXPIRE_TIME=3 in sqlnet did the trick. It killed all disconnected sessions. Further another script which executes after 35 minutes, kill users which are connected and inactive but idle for more than 30 mins.
But I am still wondering if there is any way to check DCD connections from v$session or some other table.
Regards,
Hiten
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|