Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASMM enabled when memory_target>0 but sga/pga_target=0 ?

907116Mar 25 2013 — edited Mar 26 2013

If MEMORY_TARGET is set but sga_target and pga_aggregate_target are not set (zero) then is ASMM (Automatic Shared Memory Management) enabled ?
Meaning does it dynamically redistribute memory between the internal componets of the sga (db cache, shared pool, large pool) and pga (sort area,..) as needed ? Or does it require sga_target and pga_aggregate_target to be > 0 for that to happen ?

This post has been answered by JohnWatson on Mar 25 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2013

Added on Mar 25 2013

#general-database-discussions

5 comments

373 views