Re: How to unlock objects?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 17 Mar 2000 23:24:44 +0100
Message-ID: <953332746.29814.0.pluto.d4ee154e@news.demon.nl>

Unlock by COMMIT or ROLLBACK only.
The only way to cleanup defunct sessions is to enable sqlnet dead connection detection.
Include
sqlnet.expire_time = 10
in the sqlnet.ora on the server. The unites is minutes. This will poll every 10 minutes whether all those session still exist.

Hth,

Sybrand Bakker, Oracle DBA

Alain Kreienbuhl <akreienb_at_fisystem.fr> wrote in message news:38D2A873.490FF0AF_at_fisystem.fr...
> Hello,
>
> Sorry for such basic question but how do you release locks on a objets?
> select * from v$access is showing locks on some tables.
> Besides v$session is showing a lot of openned session. How do you clean
> up all this ?
>
>
>
> Thanks a lot for help.
>
> Alain.
>
Received on Fri Mar 17 2000 - 16:24:44 CST