How abt killing the session holding the locks?

I ever encounter such deadlocks..

I just go to the Management COnsole and kill the session
----- Original Message -----
From: "r" <oracledba-ezmlmshield-x76064797.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, July 29, 2006 04:42 PM
Subject: How to unlock a table in oracle?


> Hello,
>
> I have 3 locks caused by a user on 2 tables. How can I free7unlock these
> tables?
>
> Thanks
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page