Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

PGA memory per user

Peter Dixon

2006-03-13

Replies:

At present we are upgrading our database to 10.2.0.1 from 8i, and we are
experiencing issues regarding memory used by each user session connected to
the database. The memory used per process has increased by over 60%. Is this
common , we are using pga_arregate_target are there any other parameters we
can use to decrease the amount of memory is used and not effect performance?

Peter Dixon


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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.