Friends,
OS: RHEL AS 3
DB: 9iR2
Currently...
Processes=150
sessions=170
now i want to increase to
Processes=250
sessions=280
my current sysctl.conf is.....
# Oracle 9i kernel parameters
#
kernel.sem = 250 32000 100 150
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmseg = 4096
kernel.shmall = 3279547
fs.file-max = 327679
kernel.msgmni = 2878
kernel.msgmnb = 65536
net.ipv4.ip_local_port_range = 1024 65536
#
# End of parameters
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size 452164
Variable Size 268435456
Database Buffers 369098752
Redo Buffers 667648
and our server's ram is 2GB.
is the above values are sufficient to increase the processes and sessions to 250 and 280?
what are limitations for increasing the processes and sessions?
Also, i think long back i have asked the same question. but i searched here its not here. after upgrading this forum that thread was deleted.
thanks