I have a cursor in pl/sql block which opens 2 million record at a time.
The size of the data could be 200MB. I would like to know where this data will be stored until the pl/sql block successfully completed.
I believe PGA, is it right or temp tablespace. The cursor query has order by clause.