-
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
-
It is very difficult to analyze a table that has 15M rows.
Why don't you analyze 5% of the data initially, then slowly increase the %.
Query from V$SORT_SEGMENT for usage of the TEMP tablespace.
-
Thanks Tamil: How should I do it in parts vs increase in the % and do a full 100%.. Pl.explain.
-
Estimate the statistics instead of computing them
-
analyze table EMP estimate statistics for all columns sample 10 percent;
