Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Analyze a table results in huge num_rows count
Appreciated.
On Fri, 30 Sep 2005 10:31:13 -0400, "Arnon, Yuval"
<Yuval.Arnon_at_webloyalty.com> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 30 2005 - 09:37:16 CDT
![]() |
![]() |