Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Server-side TCP KeepAlive

724186Oct 20 2009 — edited Oct 20 2009
Hello,

does anybody know how to activate TCP KeepAlive on the Oracle 9i R2 Server?

On the client it can be done easylie by adding (ENABLE=BROKEN). This enables the client to detect when the DB is not available anymore and a half-open connection remained behind.

In oposite to that, I want the DB to detect when a client is not more available in order to be able to clean up the remained connection. I know there is the EXPIRE_TIME Parameter. As far as I know this operation is on application-level and is not using TCP KeepAlives.

So is there any real TCP KeepAlive-Option for the Server?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2009
Added on Oct 20 2009
#general-database-discussions
1 comment
716 views