Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with kernel parameters to install oracle 10g

arijit dey
Occasional Contributor

Need help with kernel parameters to install oracle 10g

Hello!

We intend to install oracle 10g database on hpux l2000.We have only 2GB RAM.

Please help me tuning the kernel parameters:

If anyone can give the suggested kernel parameters.

cheers,
6 REPLIES
Peter Godron
Honored Contributor

Re: Need help with kernel parameters to install oracle 10g

Hi,
lots of prvious threads:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1037434
and
http://forums1.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=1043965

Best place to start is with the parameter chnages as specified in Oracle Install Guide and then slowly adapt to your application.
arijit dey
Occasional Contributor

Re: Need help with kernel parameters to install oracle 10g

Shall I post the kernel parameters which I have found appropriate..

I would be very glad if you give me feedback on this.
Peter Godron
Honored Contributor

Re: Need help with kernel parameters to install oracle 10g

Hi,
I have a 10g instance running on an L1000 with 512Mb, so the default values will certainly work on your machine.
arijit dey
Occasional Contributor

Re: Need help with kernel parameters to install oracle 10g

First Of all, Thank you so much for such an instant response!

I am planning to Run SPECjAppServer2004 benchmark, So the load will be high, and I am living with only 2GB RAM and 8GB swap memory.

I have hpux with hardware model: 9000/800/L2000-44.

The following are the parameters that I found can be set!please look at this once.

bufpages 0
create_fastlinks 1
dbc_max_pct 10
dbc_min_pct 10
default_disk_ir 1
fs_async 1
maxuprc (NPROC*9/10)
maxvgs 10
msgmap msgtql+2
msgtql nproc
msgmnb 65535
msgmax 32768
msgseg 32767
msgssz 32
nbuf 0
nswapdev 10
nproc 4200
nkthread ((nproc*2)+16) or 8416
npty 60
nstrpty 60
ncsize (ninode+1024)
nfile (15*nproc+2048)
nflocks (nproc)
ninode (8*nproc+2048)
o_sync_is_o_dsync 1
STRMSGSZ 65535
semmni (nproc)
semmns (semmni*2)
semmnu (nproc-4)
semvmx 32767
shmmax The size of physical memory
shmmni 512
shmseg 120


cheers,
Peter Godron
Honored Contributor

Re: Need help with kernel parameters to install oracle 10g

Arijit,
a copy of the parameters:
acctresume 4
acctsuspend 2
allocate_fs_swapmap 0
bufpages 6553
create_fastlinks 0
dbc_max_pct 50
dbc_min_pct 5
default_disk_ir 0
dskless_node 0
eisa_io_estimate 768
eqmemsize 17
file_pad 10
fs_async 0
hpux_aes_override 0
maxdsiz 262144
maxdsiz_64bit 524288
maxfiles 60
maxfiles_lim 1024
maxssiz 32768
maxssiz_64bit 262144
maxswapchunks 16384
maxtsiz 16384
maxtsiz_64bit 262144
maxuprc 3686
maxvgs 10
msgmap 4095
nbuf 7650
ncallout 7200
ncdnode 150
ndilbuffers 30
netisr_priority -1
netmemmax 0
nfile 7032
nflocks 4096
ninode 4296
no_lvm_disks 0
nproc 4096
npty 60
nstrpty 60
nswapdev 10
nswapfs 10
public_shlibs 1
remote_nfs_swap 0
rtsched_numpri 32
sema 0
semmap 4095
shmem 0
shmmni 512
streampipes 0
swapmem_on 1
swchunk 2048
timeslice 10
unlockable_mem 16584
Steven E. Protter
Exalted Contributor

Re: Need help with kernel parameters to install oracle 10g

Shalom,

Critical issues:

dbc_max_pct
dbc_min_pct

Set them low, set them equal or very close numbers.

Reasoning:
1) This effects system buffer. The memory is more effecive if allocated to the SGA
2) If the system frequently changes the buffer amount with a wide min/max range it is very bad for system performance.

I use 7/5 or 5/3 on most entry level systems.

You are on the low end range of memory for effectively running Oracle.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com