http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FTable%2FTable_StatisticsOracle PL/SQL/Table/Table Statistics - История изменений2026-04-04T17:26:36ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=Oracle_PL/SQL/Table/Table_Statistics&diff=1044&oldid=prev в 13:45, 26 мая 20102010-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/Table/Table_Statistics&diff=1045&oldid=prevAdmin: 1 версия2010-05-26T09:54:52Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Get table statistics==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
create table t as select * from all_objects where rownum < 60;<br />
exec dbms_stats.gather_table_stats( user, "T" );<br />
alter session set workarea_size_policy=manual;<br />
alter session set sort_area_size = 65536;<br />
set termout off<br />
select * from t order by 1, 2, 3, 4;<br />
set termout on<br />
alter session set sort_area_size=1048576;<br />
set termout off<br />
select * from t order by 1, 2, 3, 4;<br />
set termout on<br />
alter session set sort_area_size=1073741820;<br />
set termout off<br />
select * from t order by 1, 2, 3, 4;<br />
set termout on<br />
drop table t;<br />
<br />
<br />
</source></div>Admin