[Q] analyze-command, speeding up, sort_area_size?

Hi,
SHORT VERSION:
Is there a way to speed up the analyze command!

When recreating indexes i use a special version of initxx.ora with sort_area_size set to 64000000. This helps a lot.

I figured, that sinze the analyze command uses the temp-area, it could perhaps benefit from a large sort_area_size.

Any knowledge/experience concerning this matter would be a great help.

LONGER VERSION:
I need to analyze about 2GB of data (+ 2GB of indexes) using the command   analyze table xxx estimate statistics sample 10 percent.

I would like to do it tonight, but my window for the operation is only 3 hours. I tried analyzing one of my large tables with a sample of just 1 percent. It took 4 minutes, so I hope I can find a way to speed things up.

TIA Regards
Jens Wartenberg

WARTENBERG                      |     People
Industri Data  -  Denmark       |     that make a difference
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
IBM RS/6000 - IBM AIX - Oracle  |     For industrial needs


-------------------------------------------------------------