database:oracle:session-locking-package
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
database:oracle:session-locking-package [2019/10/26 18:12] – created odefta | database:oracle:session-locking-package [2023/07/04 19:36] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 9: | Line 9: | ||
| | ||
| | ||
- | ' | + | ' |
FROM | FROM | ||
| | ||
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 20: | Line 20: | ||
^ SID ^ LOCK_TYPE | ^ SID ^ LOCK_TYPE | ||
- | | 164 | Body Definition Lock | Null | None | USER1.PACKAGE_NAME | alter system kill session ' | + | | 164 | Body Definition Lock | Null | None | USER1.PACKAGE_NAME | alter system kill session ' |
+ | |||
+ | ====== Check details about the locking session ====== | ||
+ | |||
+ | Replace 164 with the actual sid: | ||
+ | |||
+ | <code sql> | ||
+ | SELECT s.sid, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | FROM | ||
+ | | ||
+ | | ||
+ | WHERE s.sql_hash_value = t.hash_value | ||
+ | AND s.paddr = p.addr | ||
+ | AND s.sid = 164 | ||
+ | ORDER BY s.sid, t.hash_value, | ||
+ | </ | ||
+ | |||
+ | The above code may return no results if the sqltext cannot be matched. \\ | ||
+ | In this case, try with the following query: | ||
+ | |||
+ | <code sql> | ||
+ | SELECT s.sid, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | FROM | ||
+ | | ||
+ | WHERE s.sid = 164 | ||
+ | AND s.paddr = p.addr | ||
+ | </ | ||
database/oracle/session-locking-package.1572102760.txt.gz · Last modified: 2023/07/04 19:36 (external edit)