Re: PGA Memory in 9i versus 10g
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: essawit@xxxxxxxxx
- Date: Tue, 17 Apr 2007 09:10:47 +0300
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
--
http://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."
- References:
- PGA Memory in 9i versus 10g
- From: Tarik Richard Essawi
Other related posts:
- » PGA Memory in 9i versus 10g
- » Re: PGA Memory in 9i versus 10g
- » Re: PGA Memory in 9i versus 10g
- » Re: PGA Memory in 9i versus 10g
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 -- http://www.freelists.org/webpage/oracle-l
- PGA Memory in 9i versus 10g
- From: Tarik Richard Essawi