WARNING: Granules of pga_aggregate_target

Today I seen this error into the alert.log from a database;

WARNING: Granules of pga_aggregate_target 497 cannot be more than memory_target (506) – sga_target (0) or min_sga (15)

This warning message is raised because the MEMORY_TARGET/MEMORY_MAX_TARGET and SGA_MAX_SIZE/SGA_TARGET parameters are set the same.

Ensure that the MEMORY_TARGET/MEMORY_MAX_TARGET parameter settings are set alone. If you set SGA or PGA (like a minimum) them must be minor (sum all together) than MEMORY_TARGET/MEMORY_MAX_TARGET.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s