Re: PGA memory per user
- From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx>
- To: peterdixon001@xxxxxxxxxxx
- Date: Mon, 13 Mar 2006 15:31:25 -0500
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
Other related posts:
