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
--
//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."

Other related posts: