Re: PGA Memory in 9i versus 10g

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_at_yahoo.com> 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."

--
http://www.freelists.org/webpage/oracle-l