PGA_AGGREGATE_TARGET : All about pga?
How can I tell how much more pga is needed for a 20 TB DW ? How can i find the queries using higher values of PGA ? What internal operations use the pga ?
I see that direct reads/writes use pga ? How can i find those operations in the DB? Currently the sga is 120GB+ and pga is 18GB+