database:oracle:session-locking-package
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
database:oracle:session-locking-package [2019/10/26 18:25] – [Check details about the locking session] odefta | database:oracle:session-locking-package [2019/10/26 18:29] – [Check details about the locking session] odefta | ||
---|---|---|---|
Line 13: | Line 13: | ||
| | ||
WHERE s.sid = l.session_id | WHERE s.sid = l.session_id | ||
- | AND UPPER(l.lock_id1) LIKE ' | + | AND UPPER(l.lock_id1) LIKE ' |
AND l.lock_type = 'Body Definition Lock' | AND l.lock_type = 'Body Definition Lock' | ||
</ | </ | ||
Line 39: | Line 39: | ||
AND s.paddr = p.addr | AND s.paddr = p.addr | ||
AND s.sid = 164 | AND s.sid = 164 | ||
- | AND t.piece = 0 -- optional to list just the first line | ||
ORDER BY s.sid, t.hash_value, | ORDER BY s.sid, t.hash_value, | ||
</ | </ | ||
database/oracle/session-locking-package.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1