Re: "snapshot too old" and undo_retention

From: Yechiel Adar <adar76@xxxxxxxxxxxx>
Date: Fri, 30 Sep 2005 08:53:10 +0200

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

References:

RE: "snapshot too old" and undo_retention
From: Roger Xu

Re: "snapshot too old" and undo_retention
From: Jared Still

Re: "snapshot too old" and undo_retention

Other related posts: