Database Memory & 4030/4031 (MOSC)

MOSC Banner

AMM & PGA_AGGREGATE_TARGET

edited Oct 8, 2014 1:51AM in Database Memory & 4030/4031 (MOSC) 7 commentsAnswered

SQL> show parameter target

memory_max_target                    big integer 3488M

memory_target                        big integer 2880M

pga_aggregate_target                 big integer 64M

SQL> select value, unit from v$pgastat where name='maximum PGA allocated';

     VALUE UNIT

---------- ------------

884808704 bytes

Please suggest if I change pga_aggregate_target to 844MB? (884808704/1024/1024)?

Do I make pga_aggregate_target 0 and let oracle decide on it dynamically?

Sicere thanks in advance.

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