Re: question on ASM spfile settings

Posted by ErmanArslansOracleBlog on Sep 12, 2018; 7:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/question-on-ASM-spfile-settings-tp6690p6701.html

Please read and understand what memory_target does and what sga_target, sga_max_size paramaters do.
With the release of Oracle 11g, the MEMORY_TARGET parameter defines the total amount of memory that Oracle can use, which incorporates both SGA and PGA areas.

I recommend you to use "only memory_target" or "only sga_target/sga_max_size."

This current conf is not leaving any space to pga. So it is not good.