|| at Apr 17, 2007 at 1:50 am
we do not use AIX but we did 9i->10GR2 upgrades on Linux, HP-UX and Solaris.
We noticed only one significant PGA memory management change - shared
servers can now use pga_aggreagte_target (however this can lead to a
situation where INACTIVE session can "steal" the shared server process
if that session touches the auto managed PGA memory without closing
the relevant cursor). So if you have shared servers and
pga_aggreagte_target set - you will experience different memory
Apart from that everything else worked fine with the 9i PGA related
settings. You can also refer to 10G Upgrade Guide on the general "what
need to be changed" topic.
On 4/14/07, Tarik Richard Essawi wrote:
Does anyone know how memory usage in 10g differs from 9i in AIX 5.3. We are beginning the upgrade process and do not know if the memory needs will change between versions.
I am most concerned with PGA memory, we found a memory leak in 126.96.36.199 that caused some issues and we want to make sure we have adequate memory in 10g
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection aroundhttp://mail.yahoo.com