http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FV_SESSION 2026-04-06T05:15:44Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_SESSION&diff=2300&oldid=prev 2010-05-26T13:45:19Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_SESSION&diff=2301&oldid=prev 2010-05-26T10:01:19Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Blocked-session details==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt; select sid, blocking_session, username, blocking_session_status,<br /> 2 program, event, seconds_in_wait<br /> 3 from v$session<br /> 4 where blocking_session_status = &quot;VALID&quot;;<br /> no rows selected<br /> SQL&gt;<br /> <br /> <br /> <br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt; select sid, serial#, username, program from v$session<br /> 2 where username = &quot;HR&quot;;<br /> no rows selected<br /> <br /> <br /> <br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Select the default value from V$SESSION.CLIENT_INFO.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt; SELECT USERENV(&quot;CLIENT_INFO&quot;)<br /> 2 FROM dual;<br /> USERENV(&quot;CLIENT_INFO&quot;)<br /> ----------------------------------------------------------------<br /> 1<br /> 1 row selected.<br /> SQL&gt;<br /> SQL&gt;<br /> <br /> <br /> <br /> <br /> &lt;/source&gt;</div>

Admin