database:oracle:session-locking-package
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| database:oracle:session-locking-package [2019/10/26 15:37] – [Check details about the locking session] odefta | database:oracle:session-locking-package [2023/07/04 16:36] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 42: | Line 42: | ||
| </ | </ | ||
| - | The above code may return no results | + | The above code may return no results if the sqltext |
| 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 | ||
| </ | </ | ||
database/oracle/session-locking-package.1572104247.txt.gz · Last modified: (external edit)