https://ittichaicham.com/wiki/index.php?title=Alter_system_kill_session&feed=atom&action=history
Alter system kill session - Revision history
2024-03-29T14:07:44Z
Revision history for this page on the wiki
MediaWiki 1.34.2
https://ittichaicham.com/wiki/index.php?title=Alter_system_kill_session&diff=1268&oldid=prev
Ittichai at 14:49, 15 August 2020
2020-08-15T14:49:05Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 14:49, 15 August 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l8" >Line 8:</td>
<td colspan="2" class="diff-lineno">Line 8:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category: SQL <del class="diffchange diffchange-inline">Scriopts</del>]]</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category: SQL <ins class="diffchange diffchange-inline">and PL/SQL</ins>]]</div></td></tr>
</table>
Ittichai
https://ittichaicham.com/wiki/index.php?title=Alter_system_kill_session&diff=1267&oldid=prev
Ittichai: Created page with "<pre> set pagesize 0 select 'alter system kill session ''' || SID || ',' || serial# || ''';' from v$session where username like 'EZ%'; </pre> Category: SQL Scriopts"
2020-08-15T14:42:37Z
<p>Created page with "<pre> set pagesize 0 select 'alter system kill session ''' || SID || ',' || serial# || ''';' from v$session where username like 'EZ%'; </pre> <a href="/wiki/index.php?title=Category:SQL_Scriopts&action=edit&redlink=1" class="new" title="Category:SQL Scriopts (page does not exist)">Category: SQL Scriopts</a>"</p>
<p><b>New page</b></p><div><pre><br />
set pagesize 0<br />
select 'alter system kill session ''' || SID || ',' || serial# || ''';' <br />
from v$session where username like 'EZ%';<br />
<br />
<br />
<br />
</pre><br />
<br />
[[Category: SQL Scriopts]]</div>
Ittichai