http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FV_instance 2026-05-26T10:42:33Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_instance&diff=2192&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_instance&diff=2193&oldid=prev 2010-05-26T10:01:10Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==select Active_State from V$INSTANCE==<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;<br /> SQL&gt; select Active_State from V$INSTANCE;<br /> <br /> ACTIVE_ST<br /> ---------<br /> NORMAL<br /> <br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> <br /> <br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==select Database_Status from V$INSTANCE==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt; select Database_Status from V$INSTANCE;<br /> <br /> DATABASE_STATUS<br /> -----------------<br /> ACTIVE<br /> <br /> <br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==v$instance.instance_name==<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;<br /> SQL&gt; select c.value || &quot;/&quot; || d.instance_name ||<br /> 2 &quot;_ora_&quot; || a.spid || &quot;.trc&quot; trace<br /> 3 from v$process a, v$session b, v$parameter c, v$instance d<br /> 4 where a.addr = b.paddr<br /> 5 and b.audsid = userenv(&quot;sessionid&quot;)<br /> 6 and c.name = &quot;user_dump_dest&quot;<br /> 7 /<br /> TRACE<br /> --------------------------------------------------------------------------------<br /> C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP/xe_ora_264.trc<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> <br /> <br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==V$INSTANCE view provides one row of statistics for each Oracle instance running against 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; select instance_name, host_name, version,<br /> 2 startup_time, round(sysdate-startup_time) &quot;Days Up&quot;,<br /> 3 status from v$instance;<br /> INSTANCE_NAME<br /> ----------------<br /> HOST_NAME<br /> ----------------------------------------------------------------<br /> VERSION STARTUP_T Days Up STATUS<br /> ----------------- --------- ---------- ------------<br /> xe<br /> UBC-1<br /> 10.2.0.1.0 26-OCT-09 0 OPEN<br /> <br /> SQL&gt;<br /> <br /> <br /> <br /> &lt;/source&gt;</div>

Admin