Re: How to unlock objects?

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

commit or rollback the current transaction will release the locks which will
be created by the current transaction.

>
> Besides v$session is showing a lot of openned session. How do you clean
> up all this ?

by terminating the session....logoff the users who created the session with login...

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------