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_at_hotmail.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 13 2006 - 14:31:25 CST
