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!

how to SGA_MAX_SIZE to 0 in 11gR2

AMAL_AFeb 13 2013 — edited Feb 14 2013

I am using AMM and i have define

Memory_target=2g
memory_max_target=2g
sga_target=0
pga_aggregate_target=0

tried setting sga_max_size =0

but when i start the database with spfile it get set up 60% of MT by itself

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2013

Added on Feb 13 2013

#11gr2, #general-database-discussions, #memory

5 comments

1,441 views