| OraInf |
Posted: May 20, 2003 10:32: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
|
|
|
 udaseen_laxmi |
| Posted: May 20, 2003 08:09:00 PM |  |
|
Total Post: 17
Joined: Jan, 2003
|
Looks like you are allocating 4GB shared memory to oracle. see the shmmax value.
If you want to reduce the memory taken by oracle processes then redure the shared memory parameter. But this value is good for oracle on sun.
Regards,
Anil
|
|
|
|
|
| lmtsui |
| Posted: Jul 04, 2003 10:00:00 AM | |
|
Total Post: 1
Joined: Jan, 2003
|
The maximum size of a single shared memory segment is specified by the HP-UX
parameter SHMMAX. The recommended value for SHMMAX is 1GB regardless of the
actual memory installed on the system.
--------------------
Milind B. Rane
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
