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
Last revisionBoth sides next revision
database:oracle:session-locking-package [2019/10/26 18:39] – [Check details about the locking session] odeftadatabase:oracle:session-locking-package [2019/10/26 18:40] – [Check details about the locking session] odefta
Line 42: Line 42:
 </code> </code>
  
-The above code may return no results 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 55: Line 55:
 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.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1