memory used by a query result set in Oracle 11g
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