Monthly Archives: October 2016

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