Tag Archives: Dynamic statistics

Should we gather stats on Global Temporary Table within any Stats Job?

Global Temporary table(GTT) are meant to store data specific to a session and it only persist’s till session lifetime. Most of Stats gathering job, also gather underlying stats on global temp table. Pre Oracle 12c, Underlying gathered statistics on Global … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | Leave a comment

Dynamic Statistics in Oracle 12c

Dynamic statistics allow the optimizer to augment existing statistics to get more accurate cardinality estimates for not only single table accesses but also for joins and group-by predicates. The results of the dynamic sampling queries will be persisted in the … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , , , | Leave a comment