"snapshot too old " and undo_retention 2005-09-30 - By Yechiel Adar
Moving to dbms_stats will also cause the gathering of stats to be done
in the default parallel of the table.
That will speed it up very much compare to analyze.
You can use the degree parameter to override the parallel parameter of
the table.
So, if you have do not have parallel, or your parallel is low, because
many users are accessing it at the same time, you can run with degree=>X
for the analyze.
Adar Yechiel
Rechovot, Israel
Jared Still wrote:
>begin
> dbms_stats.gather_table_stats('SAPR3',tabname=>'BSIS',estimate_percent=>1,
>block_sample=>true, cascade=>true);
>end;
>
>
--
http://www.freelists.org/webpage/oracle-l
|
|
