How do you measure this increase? Why does it bother you ? If you have pga_aggregate_target set correctly for your machine, then this would simply mean that Oracle is using the memory as opposed to leaving it wasted as "free memory". -- Christo Kutrovsky Senior Database/System Administrator The Pythian Group On 3/13/06, Peter Dixon <peterdixon001@xxxxxxxxxxx> wrote: > 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 > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Christo Kutrovsky Senior Database/System Administrator The Pythian Group -- //www.freelists.org/webpage/oracle-l