How to release acquired locks

Hi,

   Is there any simple way of releasing the row locks assosiated with a table without shutting down and then restarting the database. Is there any DBA utility provided by oracle or SQL statements that can achieve it with the database online.

We have encountered this problem as some jobs running to update the database have to abnormally be terminated, and they hold the locks, which prevents further action on these tables.

Thanks
Chinmoy Received on Mon Sep 18 1995 - 00:00:00 CEST