| Kernel parameters for another instance [message #533623] |
Wed, 30 November 2011 23:17  |
pradies
Messages: 250
Registered: May 2008
|
Senior Member |
|
|
Hi,
I have setup in which we have 64GB RAM and 12 instance already running on server. Enterprise Edition Release 11.2.0.2.0 - 64bit. all instance size is approx 600-700Mb right now.
Now I want to add another instance in this same setup and below is the instances information running on server and TOP command output and Kernel parameters.
I want to know How much we should increase the kernel.shmall and
kernel.shmmax parameters for another instance. or if any changes oracle expert feels in these parameters. then please tell me.
ps -ef |grep -i ora_pmon
db11g 5753 1 0 08:03 ? 00:00:00 ora_pmon_agshimla
db11g 6023 1 0 08:03 ? 00:00:00 ora_pmon_agnaga
db11g 6375 1 0 08:03 ? 00:00:00 ora_pmon_amguj
root 6916 2354 0 10:34 pts/7 00:00:00 grep -i ora_pmon
db11g 7332 1 0 08:04 ? 00:00:00 ora_pmon_bhuvfull
db11g 8414 1 0 08:04 ? 00:00:00 ora_pmon_hydvlc
db11g 8911 1 0 08:05 ? 00:00:00 ora_pmon_hydgpf
db11g 9287 1 0 08:05 ? 00:00:00 ora_pmon_access11
db11g 9499 1 0 08:05 ? 00:00:00 ora_pmon_agoripuvlc
db11g 9744 1 0 08:06 ? 00:00:00 ora_pmon_agorissa
db11g 10008 1 0 08:06 ? 00:00:00 ora_pmon_agoripugpf
db11g 10367 1 0 08:06 ? 00:00:00 ora_pmon_trivvlc
db11g 25876 1 0 09:30 ? 00:00:00 ora_pmon_rajkotgpf
------------------------------------------------
===TOP Command Output
Tasks: 767 total, 1 running, 765 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.7%us, 1.4%sy, 2.4%ni, 94.9%id, 0.6%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 65996012k total, 33762468k used, 32233544k free, 516164k buffers
Swap: 131074292k total, 0k used, 131074292k free, 24916740k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7955 root 15 0 1079m 60m 20m S 59.8 0.1 94:45.29 VirtualBox
5417 root 15 0 117m 14m 6944 S 7.3 0.0 11:05.35 Xorg
7138 oracle 15 0 125m 26m 17m S 0.7 0.0 0:00.09 frmweb
7201 root 15 0 13296 1648 824 R 0.7 0.0 0:00.05 top
2288 root 15 0 90164 3416 2668 S 0.3 0.0 0:00.05 sshd
2868 oracle 18 0 739m 119m 31m S 0.3 0.2 0:03.14 java
6069 db11g 18 0 830m 28m 24m S 0.3 0.0 0:08.23 oracle
6208 oracle 15 0 2149m 1.2g 42m S 0.3 2.0 3:00.95 java
7148 db11g 15 0 828m 23m 21m S 0.3 0.0 0:00.02 oracle
7465 root 15 0 311m 24m 17m S 0.3 0.0 0:27.78 VirtualBox
7550 root 15 0 195m 6604 4764 S 0.3 0.0 0:17.34 VBoxSVC
8030 oracle 18 0 745m 136m 28m S 0.3 0.2 0:11.56 java
8032 oracle 21 0 805m 134m 28m S 0.3 0.2 0:10.75 java
10062 db11g 18 0 828m 19m 17m S 0.3 0.0 0:02.60 oracle
10400 db11g -2 0 1029m 16m 14m S 0.3 0.0 0:01.19 oracle
11096 oracle 20 0 1487m 542m 36m S 0.3 0.8 1:00.36 java
21262 oracle 21 0 745m 139m 28m S 0.3 0.2 0:07.90 java
23674 oracle 18 0 742m 144m 34m S 0.3 0.2 0:07.25 java
1 root 15 0 10372 692 584 S 0.0 0.0 0:02.51 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.01 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root RT -5 0 0 0 S 0.0 0.0 0:00.01 migration/4
====== Sysctl.conf Parameter
Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
Thanks in advance
Pradeep
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
