RE: Analyze a table results in huge num_rows count

On Fri, 30 Sep 2005 10:31:13 -0400, "Arnon, Yuval"
<Yuval.Arnon@xxxxxxxxxxxxxx> said:
> All,
> Just to let you know I've figured what the problem is. This table is
> being audited using FGA for one of the columns and that is what causes
> the huge discrepancy. Once I drop the policy (using execute
> dbms_fga.drop_policy), the gather_table_stats works ok.
> I am going to open a TAR wih Oracle.
> Thanks for the input.
> Yuval.

Other related posts: