Tag Archives: oracle 11g

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

Histogram Statistics on Function based Index hidden column.

In one of previous post, had discussed on METHOD_OPT Params for different histogram stats setup. Current post is just an extension of previous post. If need more information on same, please check these out METHOD OPT Param for Stats in … Continue reading

Rate this:

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