using v$Locked_objects

Apart from using v$Locked_objects do we have any other table/view etc that can tell us whether a table has locks on it or not.

I am currently using following query

select a.owner, a.object_name, b.locked_mode, b.session_id from dba_objects a, v$locked_object b where a.object_id = b.object_id

Please tell how expensive is it to run above query often.:rolleyes:

Kindly help

Pratibha Malhotra

select * from dictionary where table_name like '%LOCK%';

Quote:

---

Originally posted by pratibha.malhot
Apart from using v$Locked_objects do we have any other table/view etc that can tell us whether a table has locks on it or not.

I am currently using following query

select a.owner, a.object_name, b.locked_mode, b.session_id from dba_objects a, v$locked_object b where a.object_id = b.object_id

Please tell how expensive is it to run above query often.:rolleyes:

Kindly help

Pratibha Malhotra

---

It depends on how big is your dictionary and SGA. Bigger SGA and obj$ may take sometime. But, it should not be more than 1~2 minutes in any case.