-
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
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
|