Home » Infrastructure » Linux » Kernel parameters for another instance (RHEL 5.6 and ORacle 11g )
Kernel parameters for another instance [message #533623] Wed, 30 November 2011 23:17 Go to next message
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
Re: Kernel parameters for another instance [message #533626 is a reply to message #533623] Wed, 30 November 2011 23:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The installation guide for your platform indicates the parameters you have to set.

Regards
Michel
Re: Kernel parameters for another instance [message #533627 is a reply to message #533623] Wed, 30 November 2011 23:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> show sga

Total System Global Area 1553305600 bytes
Fixed Size		    2213656 bytes
Variable Size		  905971944 bytes
Database Buffers	  637534208 bytes
Redo Buffers		    7585792 bytes
SQL> 

SUM of "Total System Global Area" values for all instance must be less than total RAM;
while leaving some RAM for the OS itself.
Re: Kernel parameters for another instance [message #533631 is a reply to message #533627] Wed, 30 November 2011 23:35 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

So its meanse i don't have to change kernel parameters in the file.

Sum of all instance SGA size is also very less then Total RAM.



Mem: 65996012k total, 33762468k used, 32233544k free, 516164k buffers




Thnaks

Pradeep
Re: Kernel parameters for another instance [message #533663 is a reply to message #533631] Thu, 01 December 2011 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some parameters depend on the number of instances (like number of semaphores), others not.
The documentation tells how to calculate each parameter.

Regards
Michel
Re: Kernel parameters for another instance [message #533665 is a reply to message #533663] Thu, 01 December 2011 01:31 Go to previous message
pradies
Messages: 250
Registered: May 2008
Senior Member


Hi Michal,

Thanks

Pradeep
Previous Topic: I am totally new to Oracle but MS SQL developer
Next Topic: trouble in sending mails from linux
Goto Forum:
  


Current Time: Thu Mar 28 19:43:55 CDT 2024