The extending of Temp TS works, but while the query works how do we confirm it is using that TS..
When I open another session while the analyze is going on another table of 30 million rows now, I check the dba_free_space and it is always 1GB, which is allocated for TEMP TS. Any other queries that are used in chking this.