-
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.
Kindly help
Pratibha Malhotra
-
select * from dictionary where table_name like '%LOCK%';
I'm stmontgo and I approve of this message
-
Re: using v$Locked_objects
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.
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.
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|