DBMS_STATS package

[Thomasps]

I'm computing stats. TEMP is 20GB. Isn't that too much already?

I dont' think you need to COMPUTE statistics for a large table rather use ESTIMATE with 10% - 20%. See the syntax from Tamil, how to ESTIMATE Statistics. I felt 20GB Temp space is something pretty big.