Hi,
Recently,we migrated our Oracle database to a new machine.It's Windows server 2003 x86 ,oracle 10g before
Now the database is on Windows server 2003 x64,still 10g.
In new machine:
sga_max_size is set to 3000MB,sga_target is set to 3000MB
pga_aggregate_target is set to 500MB
and sga+pga is 3500MB,
but when the database is running,the memory consumption keeps increasing,
In windows' taskmanger,i can see the process "oracle" cost about 7000MB first.and a few days later,it increased to about 9000MB now.
sga plus pga is just 3500MB,how could oracle cost 9000MB mem?
i queried "total PGA allocated" from v$pgastat,The value is nearly 500MB,so the pga is normal
and the count of sessions is about 150,in normal range.
So,how can i find these extra memory cost in where?and how to solve the problem.
If the memory cost keeps increasing,a few days later the machine's physical memory will be used up.