Advertisement

11.08.2007 at 05:18AM PST, ID: 22947177
[x]
Attachment Details

Oracle Sessions Versus Disconnected Clientes due Network Problems

Asked by regisdaniel in Oracle 10.x, Oracle Database, Oracle 9.x

Tags: oracle, session, disconnect

Hi Experts

I noticed that when a user is connected to a Oracle Database and it's connection is unexpectedly dropped (as happen, by example, when there is some network problem), the server keeps the session, don't releasing it.

If the user was on a transaction, updating a registry when the problem occurred, when he reconnects and try to do the same operation again, the user experience a row lock  due the last session that is already present.

How Oracle decides when is the time to kill these sessions? Is there any way to release this session short after the user disconnecting due a network problem?

Thanks!Start Free Trial
 
Keywords: Oracle Sessions Versus Disconnected…
Title
1 Oracle - Kill a running request.
2 How To Kill Oracle Processes
3 Oracle Vs SQL2000
4 Kill Rollback?
5 Deadlock on an Oracle Database
6 Oracle
 
Loading Advertisement...
 
[+][-]11.08.2007 at 05:37AM PST, ID: 20240983

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.08.2007 at 05:52AM PST, ID: 20241108

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.08.2007 at 06:10AM PST, ID: 20241243

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.08.2007 at 06:12AM PST, ID: 20241255

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Oracle Database, Oracle 9.x
Tags: oracle, session, disconnect
Sign Up Now!
Solution Provided By: schwertner
Participating Experts: 3
Solution Grade: A
 
 
[+][-]11.08.2007 at 10:11AM PST, ID: 20243509

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.08.2007 at 11:58PM PST, ID: 20248019

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628