GATHER_STATS_JOB - GRANULARITY AUTO for Partitions and Subpartitions
Hi,
we have a few tables with partitions and subpartitions and use the "auto optimizer stats collection" to collect the stats.
My question is about the "GRANULARITY" parameter:
SELECT DBMS_STATS.get_prefs ('GRANULARITY') GRANULARITY FROM DUAL;
GRANULARITY
------------------------------
AUTO
The documentations says: "determines the granularity based on the partitioning type. This is the default value." What does "AUTO" mean, does oracle the stats collection for global, partition and subpartition if they exist?
See my other parameter:
SELECT DBMS_STATS.get_prefs ('cascade') CASCADE FROM DUAL;
CASCADE
------------------------------
DBMS_STATS.AUTO_CASCADE
SELECT DBMS_STATS.get_prefs ('estimate_percent') ESTIMATE_PESQL> RCENT FROM DUAL;
0