Med Java

User Tools

Site Tools

Trace:
database:oracle:session-locking-package

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
database:oracle:session-locking-package [2019/10/26 15:37] – [Check details about the locking session] odeftadatabase:oracle:session-locking-package [2023/07/04 16:36] (current) – external edit 127.0.0.1
Line 42: Line 42:
 </code> </code>
  
-The above code may return no results if there if the sqltext is empty.+The above code may return no results if the sqltext cannot be matched. \\
 In this case, try with the following query: In this case, try with the following query:
  
Line 53: Line 53:
 FROM   v$session s, FROM   v$session s,
        v$process p        v$process p
-WHERE  s.sid=164+WHERE  s.sid = 164
 AND    s.paddr = p.addr AND    s.paddr = p.addr
-ORDER BY s.sid 
 </code> </code>
  
database/oracle/session-locking-package.1572104233.txt.gz · Last modified: (external edit)