| OraInf |
Posted: May 20, 2003 10:30:00 AM |
Total Post: 22
Joined: Jan, 2003
|
When Oracle 8i was installed the optimum semaphore values were selected and installed.But each oracle process takes up to 1043Mb which is very high.Normally oracle processes take upto 256Mb .Can anyone suggest any method to reduce the RAM space taken up by the oracle processes.
the values in the etc/system file is given below
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=160
set semsys:seminfo_semmns=310
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
|
|
|
 shritesh |
| Posted: May 20, 2003 09:54:00 PM |  |
|
Total Post: 3
Joined: Jan, 2003
|
Same thread is running in Oracle on Unix/Linux section.
Please check it at http://www.dbapool.com/cgi-bin/cutecast/cutecast.pl?forum=8&thread=112
Thanks for using dbapool discussion forum.
Regards,
Web Admin
|
|
|
|
|
| Jovih |
| Posted: Jul 17, 2003 06:29:00 AM | |
|
Total Post: 5
Joined: Jan, 2003
|
Please check the Processes parameter in the INIT file and also check the SEMMNS parameter in the Kernal Parameters. SEMMNS can be calculated based on this formala..
ORACLE_SID=A, PROCESSES=100
ORACLE_SID=B, PROCESSES=100
ORACLE_SID=C, PROCESSES=200
The value of SEMMNS is calculated as follows:
SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) + ((# of instances=3) * 10) = 630
:)
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
