Database DataWarehousing (MOSC)

MOSC Banner

PGA_AGGREGATE_TARGET : All about pga?

edited Aug 20, 2015 12:06PM in Database DataWarehousing (MOSC) 10 commentsAnswered ✓

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+

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center