Which Is Correct? Sorting Will Take Place In Pga Or Temp Tablespace?

1.	Which Is Correct? Sorting Will Take Place In Pga Or Temp Tablespace?
Answer» Both. If the data which to be sorted is more than SORT area SIZE of PGA, then temp tablespace will be used. Both. If the data which to be sorted is more than sort area size of PGA, then temp tablespace will be used.

Answer»

Both. If the data which to be sorted is more than SORT area SIZE of PGA, then temp tablespace will be used.

Both. If the data which to be sorted is more than sort area size of PGA, then temp tablespace will be used.

Discussion