Hi

It would be stored in the SGA database buffer cache offcourse..but not your 2 million rows..the answer would deepnd on the array size of the calling program ..whaether it oci ,sqlplus,java or etc..and for sorting the sort would be split into sort runs..

regards
Hrishy