Re: "For Update no Wait" and Database Sessions.

"Mark D Powell" wrote

> Termo, what you are talking about is dead session detection.
> Oracle session background processes that no longer have a
> foreground process.

Ok, thanks for explanation.

> There is a sqlnet [net8, Oranet] parameter that may be of interest
> to detect dead sessions: SQLNET.EXPIRE_TIME which
> "Determines time interval to send a probe to verify the session
> is alive...

Ok, i will test what occur on my applications and server varying this parameter.

> You can also write scripts to join v$transaction to v$session
> that finds transactions whose matching session has a status of
> inactive and that have a large value in last_call_et
> (time of last command).
> Rows returned from such a query would be candidates for being dead
> sessions.

This also sound interesting. Anyway i'hope your first suggestion works for me.

<x:termoPilucco> Received on Thu Nov 20 2003 - 09:12:25 CST