Re: using v$Locked_objects
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.
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: