-
I want to find the sql cause lock,I use the sql
SELECT object_name,SESSION_ID,SERIAL#,machine,
osuser,S.PROCESS,e.sql_text
FROM V$LOCKED_OBJECT p, V$SESSION S , dba_objects B, v$sql e, v$lock l
WHERE p.SESSION_ID=S.SID and b.OBJECT_ID=p.OBJECT_ID and
l.addr=e.ADDRESS
and l.sid=s.sid;
but $lock 's addr and v$sql 's address is not equal?
or How can I find the sql cause lock ?
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
|