Oracle Database Discussions

hi all,

I am having a rac of 7 nodes with oracle 10.2.0.4.
recently i see the query response too slow on certain nodes. sometimes it takes too long to just query some simple statements.

I haven't seen any thing that could causes the problem but now when I do a "ps aux" command on those nodes that is too slow i noticed that there are a couple ora_j001 processes that are using up to 30% of the total system memory each (60% total). And I also noticed that there are a couple ora_dbw* processes that is using 10% of the total memory each.

why are those processes using too much memory. The system shows only about 500MB of free memory.

There are 8GB total on each node and the SGA_target is set to 4GB and PGA is set to 0.8GB.

Right now there is only one node that is having this problem.

but i see there is a couple other nodes that seem to be eating up the memory as well.

I have applied this patch 6749617:Frequently memory leaks to all the nodes


Thanks in advance!
Chau