To kill a users session you need their serial # and sid which can be
obtained from the v$session VPT (you need the appropriate privelages to do
this). To find which session is holding the lock you run CATBLOCK.SQL and
the UTLLOCKT.SQL, in Oracle 8 that is.
<plaiter_at_my-deja.com> wrote in message news:89jcif$o1t$1_at_nnrp1.deja.com...
> Hope this is the right place to post this
> Recently I tried to do an insert into a database. But when I executed
> the block
> Oracle hung.
>
> I think that maybe someone was holding the
> table or locked.
>
> But I had no idea how to check this
> or how to end the users session.
>
> Could someone please help ?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 01 2000 - 00:00:00 CST
