memory used by a query result set in Oracle 11g There is something not very clear in my mind and that I wanted to know when performing queries that retrieve large result sets: 

Is a result set entirely loaded into memory and send to the client or only a part of it is loaded, send and then the memory is reused to load the next part until all data has been processed to fulfill the query ?

I suppose that for some queries that require a sort operation or use an analytical function it has to be fully loaded but what for basic queries that would only involve one table ? Like for instance:

select * from mytable where id between 1 and 1000000;


Will the one million records be loaded entirely into the memory allocated for my query or only a part of it ?

Thanks for your help,
Usually it's in the PGA (Program Global Area). But it will depend on a number of things. For more info, take a look at: https://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm#CNCPT007