Achal Bansal, February 20, 2018 - 7:24 am UTC
Thank you so much for the reply! The Update statement is not a direct path operation. Execution plan also don't has any step to gather stats.
Only thing that suggests stats gathering is used is following note at bottom of the plan:
"Global temporary table session private statistics used"
Any other thing that could have triggered Session private stats?
Also regarding following:
If the data is being loaded with direct load, then the standard collection of stats on load is performed like a normal table, eg
It means that regular stats (not session specific stats) would be gathered and value of GLOBAL_TEMP_TABLE_STATS parameter will not matter?
February 22, 2018 - 1:43 am UTC
In 12c, the *default* for global temp tables is session-specific stats.