Re: Newbie Update Help

From: Dhimant Patel <dhimantp_at_puma.mt.att.com>
Date: Wed, 22 Mar 2000 14:35:34 -0500
Message-ID: <38D92086.E849B721@puma.mt.att.com>

To identify a blocking session you can use dba_blockers view which can be created by running catblock.sql in /rdbms/admin directory.

To actually identify a session you can use v$access view.

Once you know who is blocking you can kill it's session by first find sid and serial# from v$session.

select username,osuser,sid,serial# from v$session; Next use

Alter system kill session '<SID>, <serial#> ';

Hope this helps,
Dhimant.

plaiter_at_my-deja.com wrote:

> 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 22 2000 - 13:35:34 CST