Solved

Clients session hang in database

Posted on 2009-04-06
1
390 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 78

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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

The way I use Experts Exchange to assist me in analyzing and diagnosing a problem is I first enter a Verbose Question at Experts Exchange like: Office 2007 will hang when opening and saving files I then launch WordPad (any text editor will do) an…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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). …

717 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