Re: Oracle 7 locking

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/19
Message-ID: <958691418.28964.0.pluto.d4ee154e@news.demon.nl>#1/1

You need to enable dead connection detection in sqlnet. You can do that by changing sqlnet.ora *on the server* and add
sqlnet.expire_time = <n> where <n> is in minutes. Now the server will poll all clients every <n> minutes to check whether they still exist.

Hth,

Sybrand Bakker, Oracle DBA

Michael VanTyne <mvt_at_xmission.com> schreef in berichtnieuws 39247406.F9692306_at_xmission.com...
> I've got an Oracle 7.3.4.4 database running on a Sun E450 with a 3rd
> party Forms app. When users encounter an O/S error and have to reboot,
> their session is not killed and it keeps record and table locks within
> the database. When the user logs back in under a new session, the
> records from the previous session are still locked.
>
> If I kill their original session myself, the server does a fine job of
> releasing the locked resources. My question is: what can I do to have
> PMON recognize and kill the dead session more quickly and
> automatically? Thanks in advance for any input.
>
>
> Regards,
> Michael VanTyne
>
Received on Fri May 19 2000 - 00:00:00 CDT