Re: "snapshot too old" and undo_retention

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