Tarik, Some time backup, we have upgraded one of our busiest OLTP database (410 transaction per second) from 9i to 10gR2 on AIX 5.3. We don't see any strange behaviour in PGA of after upgrade. However, our 9i databases with 9.2.0.5 patch set. Jaffar On 4/13/07, Tarik Richard Essawi <essawit@xxxxxxxxx> wrote:
All, 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 9.2.0.6that caused some issues and we want to make sure we have adequate memory in 10g Tarik __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l
-- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."