Differences

This shows you the differences between two versions of the page.

--- database:oracle:session-locking-package [2019/10/26 18:29] – [Check details about the locking session] odefta
+++ database:oracle:session-locking-package [2019/10/26 18:40] – [Check details about the locking session] odefta
@@ Line 42: / Line 42: @@
 </code>
+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,
+       NVL(s.username, 'ORACLE PROC') username,
+       s.osuser,
+       p.spid os_pid,
+       s.program
+FROM   v$session s,
+       v$process p
+WHERE  s.sid = 164
+AND    s.paddr = p.addr
+</code>