An other point, I think It's important :
mesures display above are for instance number 2, I don't have any problem with instance number 1.
So, why Oracle RAC don't balancing workload between memories of tow instances?
I explain more: if it not exist much memory in instance 2 so it should be work in instance 1, but advisories of PGA and SGA for instance number 1 are very good!
Any one have encounter same problem, thank you to help me!
Measures below are from my server:
root@PROD_SERV:~# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 191772
max locked memory (kbytes, -l) 64
max memory size (kbytes,-m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
So, any relation between ORA-04030 and this configuration for server?
the cause of problem is deficiency of PGA memory, we need more than 600Mo according to oracle advisory (we need 3.5Go)
I keep cursor for application, to wait to add RAM memory for our server.
Have a nice day