Differences

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

--- database:oracle:session-locking-package [2019/10/26 15:27] – odefta
+++ database:oracle:session-locking-package [2023/07/04 16:36] (current) – external edit 127.0.0.1
@@ Line 39: / Line 39: @@
 AND    s.paddr = p.addr
 AND    s.sid = 164
-AND    t.piece = 0 -- optional to list just the first line
 ORDER BY s.sid, t.hash_value, t.piece
 </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>