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


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 patch set.


On 4/13/07, Tarik Richard Essawi <essawit@xxxxxxxxx> 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 
caused some issues and we want to make sure we have adequate memory in


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around

Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
"Winners don't do different things. They do things differently."

Other related posts: