Originally posted by MMCP
This query, without Order by, of a table with only "7 records ... is using the Temporary TS, with 111 extents and 2775 blocks of 8K (consuming almost "22 MB"). Too much bytes for only 7 records!
How did you discover that THIS query needed 22MB of Temporary segment? I believe you used a wrong method.