Solved

Clients session hang in database

Posted on 2009-04-06
1
388 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Have you ever had a hard drive that you can't boot into, but need to change the registry? Here is the solution! This article guides you through accessing and editing a registry of a non-primary drive. To read registry information on a non-prim…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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). …

828 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