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

"termoPilucco" wrote

> > 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...

Just for knowledgment this solution worked fine for me. I've added the entry
SQLNET.EXPIRE_TIME = 5
in sqlnet.ora server configuration file.

Anyway, it's not yet clear for me why, in case of client crash, Oracle server close correctly the session background process, but simply plugging off the client net cable for a few second, dead connection raise and still alive until timeout come.
The real problem for me is that, in a real environment, sometimes my customers temporary loose connection due to net inefficiency (token ring anyone?).

Thanks and sorry for my barbaric english. <x:termoPilucco> Received on Fri Nov 21 2003 - 04:49:30 CST