tag:blogger.com,1999:blog-5242763796932817271.post5881032506824299011..comments2024-03-15T09:11:14.583-04:00Comments on Kane's Blog: 04031 and large pool, parallel and PX msg poolKane Zhanghttp://www.blogger.com/profile/10004641664457706458noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5242763796932817271.post-83982567068050000422012-12-12T08:25:07.927-05:002012-12-12T08:25:07.927-05:00Clearly this is what I call a delightful article! ...Clearly this is what I call a delightful article! Do you utilize this portal for your personal purposes exclusively or you still use it as an additional source of income?T. Darrhttp://gorgeouslifestyle.wordpress.com/noreply@blogger.comtag:blogger.com,1999:blog-5242763796932817271.post-42958071789934404392012-11-30T14:21:19.469-05:002012-11-30T14:21:19.469-05:00Nice article ...
1. a. If SGA has maxed out then ...Nice article ...<br /><br />1. a. If SGA has maxed out then we need to increase Max SGA size, but in that case would it be allocated to large pool guaranteed?<br /> b. Since the initial allocation is set via parameter and it grows as is required bounded by SGA max size or freed memory from other pools by ASMM, don't we need to bump up both in order to minimize occurrence of this error?<br /><br />2. While this allocation/de-allocation of memory is going on, performance of the statement which created this situation would worsen, any idea around that area what performance degradation we should expect?<br /><br />Thanks<br /><br />Vipen.Anonymoushttps://www.blogger.com/profile/17799456972271650483noreply@blogger.com