On 7/25/19 6:33 AM, Noveljic Nenad wrote:
Your conclusions look correct to me.
My questions are:
1. Are my conclusions correct?
2. How does a session makes a decision whether to allocate a chunk from the free memory or to wait on 'SGA: allocation forcing component growth'?Session doesn't make that decision. SGA component growth operation has higher priority than sessions allocating memory and sessions have to wait. Having said that, this looks like a serious bug in whatever version you're using. Please call support.