When Analyze is going on, I guess Temp TS is working right. Is there anyway to see that if the analyze is currently working. The reason being, I have run analyze query on a table that has about 15 million rows and its response is hanging till it finishes.. (sine 30 minutes)
I queried the dba_free_space for the temp tablespace and all 500mb is free.. confirmed with dba_data_files (bytes)
By the way, I dont have to worry if my TS are locally managed with autoextend ON right.. I mean, if not, I want to extend my Temp TS with another 500M..
Please confirm. thanks