Urgent!!!How to check if my table is locked??

[see_one]

Hey,

This is urgent. One of my table is locked by something and I can't update records in it, it just hangs up on me but I can insert a new record though. Can you tell me if there is a way to find out if my table is locked? I have used V$locked_object command. I don't know much more. A reply would be appriciated. Thanks.

Also, how to find what is locking my table?

[marist89]

1. start your update
2. in another window, select * from dba_waiters. This will give you the sid of the blocker.

[see_one]

dba_waiter does not exist in sql plus.

[see_one]

I am using 8i by the way. I restarted the server but can you please explain why dba_waiters object does not exist? I'll appreciate it. Thanks.

[marist89]

as sys, run ?/rdbms/admin/catblock.sql to create

[pando]

You have some concepts problem, what do you mean a view doesnt exist in sqlplus? sqlplus is not the database, it's a tool

[reydp]

Originally posted by see_one
Hey,

This is urgent. One of my table is locked by something and I can't update records in it, it just hangs up on me but I can insert a new record though. Can you tell me if there is a way to find out if my table is locked? I have used V$locked_object command. I don't know much more. A reply would be appriciated. Thanks.

Also, how to find what is locking my table?

try use the v$LOCKED_OBJECT, it will also show who the blocker is:
SELECT LPAD(' ',DECODE(l.xidusn,0,3,0)) || l.oracle_username "User Name",
o.owner, o.object_name, o.object_type
FROM v$locked_object l, dba_objects o
WHERE l.object_id = o.object_id
ORDER BY o.object_id, 1 desc
/

[abhaysk]

start RTM - Concepts

[bhattnirav]

you can use following query


SELECT a.sid,a.serial#, a.username,c.os_user_name,a.terminal,
b.object_id,substr(b.object_name,1,40) object_name
from v$session a, dba_objects b, v$locked_object c
where a.sid = c.session_id
and b.object_id = c.object_id

[hacketta1]

Don't forget the utllockt script in $ORACLE_HOME/rdbms/admin. Running this gives you a nice tree-like report of who's waiting and who's blocking.