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

<p>1 версия</p> <p><b>Новая страница</b></p><div>==determine if flashback query is enabled on your system==<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 value from v$parameter where name = &quot;undo_management&quot;;<br /> VALUE<br /> ------------------------------------------------------------------------------------------------------------------------------------------------------<br /> AUTO<br /> 1 row selected.<br /> SQL&gt;<br /> SQL&gt; --<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Obtain retention parm==<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 value from v$parameter where name = &quot;undo_retention&quot;;<br /> VALUE<br /> ------------------------------------------------------------------------------------------------------------------------------------------------------<br /> 900<br /> 1 row selected.<br /> SQL&gt;<br /> SQL&gt; --<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==--Query v$parameter table for &quot;optimizer_mode&quot;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SELECT name, value<br /> FROM v$parameter<br /> WHERE name = &quot;optimizer_mode&quot;;<br /> <br /> --<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==show parameters block==<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;<br /> SQL&gt; select name name_col_plus_show_param,<br /> 2 decode(type,1,&quot;boolean&quot;,2,&quot;string&quot;,<br /> 3 3,&quot;integer&quot;,4,&quot;file&quot;,<br /> 4 6,&quot;big integer&quot;,&quot;unknown&quot;) type,<br /> 5 value value_col_plus_show_param<br /> 6 from v$parameter<br /> 7 where upper(name) like upper(&quot;%block%&quot;)<br /> 8 order by name_col_plus_show_param,rownum<br /> 9 /<br /> NAME TYPE VALUE<br /> ------------------------------------ ----------- ------------------------------<br /> db_block_buffers integer 0<br /> db_block_checking string FALSE<br /> db_block_checksum string TRUE<br /> db_block_size integer 8192<br /> db_file_multiblock_read_count integer 128<br /> SQL&gt;<br /> SQL&gt;<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==show parameter type and value from v$parameter==<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 name name_col_plus_show_param,<br /> 2 decode(type,1,&quot;boolean&quot;,2,&quot;string&quot;,<br /> 3 3,&quot;integer&quot;,4,&quot;file&quot;,<br /> 4 6,&quot;big integer&quot;,&quot;unknown&quot;) type,<br /> 5 value value_col_plus_show_param<br /> 6 from v$parameter<br /> 7 where upper(name) like upper(&quot;%block%&quot;)<br /> 8 order by name_col_plus_show_param,rownum;<br /> NAME TYPE VALUE<br /> ------------------------------------ ----------- ------------------------------<br /> db_block_buffers integer 0<br /> db_block_checking string FALSE<br /> db_block_checksum string TRUE<br /> db_block_size integer 8192<br /> db_file_multiblock_read_count integer 128<br /> SQL&gt;<br /> SQL&gt;<br /> &lt;/source&gt;</div>

Admin