DBMS_STATS.GATHER_SCHEMA_STATS method is not gathering statistics of all the tables of a given schem
Hi,
In our database I observed that DBMS_STATS.GATHER_SCHEMA_STATS method is not gathering statistics of all the tables of the given schema.
We are gathering statistics with below script.
==========================================================================================
exec dbms_Stats.gather_schema_stats(ownname=>'SCHEMA_NAME',cascade=>TRUE,estimate_percent=>40);
==========================================================================================
Also these tables are not temporary tables. I want to know what is happening because of which all the tables are not getting analyzed.
Please help to understand this.
In our database I observed that DBMS_STATS.GATHER_SCHEMA_STATS method is not gathering statistics of all the tables of the given schema.
We are gathering statistics with below script.
==========================================================================================
exec dbms_Stats.gather_schema_stats(ownname=>'SCHEMA_NAME',cascade=>TRUE,estimate_percent=>40);
==========================================================================================
Also these tables are not temporary tables. I want to know what is happening because of which all the tables are not getting analyzed.
Please help to understand this.
0