Re: How to release acquired locks

ctripath_at_ucs.att.com (ctripath_at_ucs.att.com) wrote:
> 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.

See the v$session view; that would still have entries for those jobs. Use the ALTER SYSTEM KILL command to get rid of them.

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************