Database Tuning (MOSC)

MOSC Banner

Question on memory_target:11g

edited May 13, 2013 3:34AM in Database Tuning (MOSC) 2 commentsAnswered
Hi,
Alert log of my 11.2.0.3 DB has following entries.

WARNING: Granules of pga_aggregate_target 300 cannot be more than memory_target (302) - sga_target (0) or min_sga (11)

Here are my memory settings

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 0


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer 19328M
memory_target                        big integer 19328M

Could some one throw some light and what action needs to be taken here?

Regards
Rajeev

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