I was mot specifying the buffer size , so
the system was using the default.

Can someone recommand a better buffer size

How does COMMIT parameter going to affect the
performance.

Also can someone suggest a beter SORT_AREA_SIZE.
Presently the value for sort area & retian size
is 264000.