Based on the information here, I expected the statistics to be automatically collected during an Insert-Select operation on a new table in Oracle. However, I don't see any table-level statistics gathered after an insert-select operation.
I have set the parameter _optimizer_gather_stats_on_load to TRUE.
As per requirement (this only works for new tables), I created a new table. There are no rows prior to insert-select and 500 rows post insert-select operation.
Is there something else I am missing?