Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PGA memory per user

PGA memory per user

From: Peter Dixon <peterdixon001_at_hotmail.com>
Date: Mon, 13 Mar 2006 14:32:00 +0000
Message-ID: <BAY101-F995DB84CFA2B97B81F671FCE00@phx.gbl>


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
Received on Mon Mar 13 2006 - 08:32:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US