hi;
A Full-Tablsscan does not affect the PGA/SGA memory.
But
*a sort can do depending on SORT_AREA_SIZE
*intensive us of packages with a lot of packag-data
*many open cursors
*batchprograms often use mor memory

Orca