Determining granulary for gathering stats on partitioned tables
I am referencing the following Oracle Documentation:
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)
Part Number E25788-04
I keep seeing the following:
But cannot find an explanation anywhere as to how Oracle determines the granularity based on the partitioning type. I have tables with List/Hash partition/subpartitions s and just Hash partitions. Can anyone point me to where I can find this?
Also, we have very large tables (8-23 gig) and I am trying to determine if I should change the Stale Percentage of 10%. Is there a rule of thumb for determining if this standard is adequate for our tables?
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)
Part Number E25788-04
I keep seeing the following:
'AUTO'- Determines the granularity based on the partitioning type. This is the default value.But cannot find an explanation anywhere as to how Oracle determines the granularity based on the partitioning type. I have tables with List/Hash partition/subpartitions s and just Hash partitions. Can anyone point me to where I can find this?
Also, we have very large tables (8-23 gig) and I am trying to determine if I should change the Stale Percentage of 10%. Is there a rule of thumb for determining if this standard is adequate for our tables?
0