SESSION_PER_USER limit of the user profile and memory Oracle 11g
Hi,
I am new to oracle 11g.
My applications are facing some problem hosted over oracle 11g and this issue appearing because of there is not sufficient sessions available.
Here is current setting
CPU count 2
Parallel Thred per CPU 2
Resource Manager CPU allocation 2
Shared mamory address 0
Memory MAX target 6GB
Memory Target 6GB
Total Size of DB 75
Used Size of DB 55
Sessions -MAX 555
Processes-MAX 500
We want following settings
Total Size of DB 75
Used Size of DB 55
Sessions -MAX 1200
Processes-MAX 800
Here is my qurey
Is there any relationship between memory allocated to database and Sessions -MAX & Processes-MAX or CPU allocated .
and whats best setting we can get for Sessions -MAX & Processes-MAX for given configuration of CPU and memory ?
Thanks
Edited by: user13714831 on Jul 22, 2011 12:54 PM