Solved

Clients session hang in database

Posted on 2009-04-06
1
385 Views
Last Modified: 2012-05-06
We have a problem in the database, the sessions hang for some situations like client disconnected from the network and reconnect again.
I searched and found it is a bug will be solved in the next release of the oracle database version.But for now there is a solution can be made upon the operating system.
The database OS is Windows 2003 R2 64bit version.
The attached file contains Oracle comments about this bug.
I want to know how can I configure TCP keepalive to the required timeouts at OS level.

Thanks


Bug-6918493.doc
0
Comment
Question by:ahfaris
1 Comment
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 24082957
TCp settings are in the registry. There are different tools TCPOptimizer might be such a tool.

The following might be useful as well.
http://support.microsoft.com/kb/324270
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now