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

What is the best Kernel Parameter on oracle 8.1.7.2?

SOLVED
Go to solution
Lee Joon Moon
Occasional Advisor

What is the best Kernel Parameter on oracle 8.1.7.2?

Hello Everyone
I'm testing oracle performance on HP rp5470-4.
OS is HPUX 11.0(Patch 2001.12.
But, I'm supprise the output of test.
Because the speed is slower than old equipment.
Also, I separate the log, OS, DB engine and data.
So, I'm very curious about kernel value.

My kernel value,which I changed, following below

* Tunable parameters

STRMSGSZ65535
max_thread_proc 256
maxdsiz0X0000000040000000
maxdsiz_64bit0X0000000040000000
maxssiz0X005000000
maxssiz_64bit0X005000000
maxswapchunks 512
maxusers 256
nstrpty 60
semmni 70
semmns 200
shmmax 0X40000000
shmseg 30
lotsfree 131072
minfree 8192
desfree 32768

If you have oppion about my kernel value, please let me know.
This test is very import to beat IBM server.

Thank youl.
Have a nice day
6 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: What is the best Kernel Parameter on oracle 8.1.7.2?

Oracle has an opinion or two about your setup.

Kernel

KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

Patches
er HP Bug (Doc ID: KBRC00003627) The default 64bit OS installation does not create a few required X library symbolic links. The following symbolic links need to be created:
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl

HP-UX 11.0(64 bit) Operating System Patches:
Sept 2001 Quality Pack
PHCO_23792 s/b PHCO_26960
PHCO_24148 s/b PHCO_25707 s/b PHCO_27608
PHKL_24268 s/b PHKL_27178 (has been recalled by HP may destroy logical volumes on PVGs - more info
PHKL_24729
PHKL_25475 s/b PHKL_27510
PHKL_25525 s/b PHKL_27364
PHNE_24715 s/b PHNE_26771
PHSS_23670 s/b PHSS_26138
PHSS_24301 s/b PHSS_26273 (only needed for C++ compiler and Pro*C++)
PHSS_24303 s/b PHSS_26559
PHSS_24627
PHSS_22868 (only needed for C++ compiler and Pro*C++)

HP-UX 11i (64 Bit) Operating System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later
JDK 1.3.1.02
PHNE_27745 (For RAC systems)
PHNE_28568
PHKL_25506
PHSS_26560
PHSS_26946
PHSS_28849 (For ServiceGuard systems)
PHCO_28427
PHCO_24402

HP-UX 11.22 (IA64) Operating System Patches:
PHSS_27284 s/b PHSS_28977
PHSS_27285 s/b PHSS_28970
PHSS_27286 s/b PHSS_28978
PHSS_27287 s/b PHSS_29652
PHSS_27288 s/b PHSS_28971
PHSS_27289 s/b PHSS_29653
PHSS_27290 s/b PHSS_28973
PHSS_27291 s/b PHSS_28969
PHSS_27292 s/b PHSS_29654
PHSS_27293 s/b PHSS_28975
PHKL_28465

These are minimums.

The best course of action is to collect data and find out where the bottlenecks are.

If you need them, I'll post up my kmtune from fast production servers in the morning(US).

See attachment

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
Michael Tully
Honored Contributor

Re: What is the best Kernel Parameter on oracle 8.1.7.2?

Try these:

STRMSGSZ 65535
nstrpty 60
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxssiz 134217728
maxssiz_64bit 1073741824
maxswapchunks 16384
maxuprc ((NPROC*9)/10)
msgmap (MSGTQL+2)
msgmni NPROC
msgseg 32767
msgtql NPROC
ncallout (NPROC+16)
ncsize ((8*NPROC+2048)+VX_NCSIZE)
nfile (15*NPROC+2048)
nflocks 4096
ninode (8*NPROC+2048)
nkthread (((NPROC*7)/4)+16)
nproc 4096
semmap (SEMMNI+2)
semmni 4096
semmns (SEMMNI+2)
semmnu (NPROC-4)
semvmx 32768
shmmax 4294967296
shmmni 512
shmseg 32
st_ats_enabled 0
vps_ceiling 64

You probably also need to look at dbc_min_pct and dbc_max_pct (buffer cache)
The maximum should be somewhere in between 300-500Mb. Also make sure you have sufficient swap space.
Anyone for a Mutiny ?
Lee Joon Moon
Occasional Advisor

Re: What is the best Kernel Parameter on oracle 8.1.7.2?

To Steven E Protter

Thank your reply.
Your Kernel value may help my problem.
Do you have any idea of correlation between async parameter and performance?
According to another UNIX(Tru64) experience,
there is a correlation.
I read the Tunable Kernel Parameters
HP-UX Release 11i Version 1.6 but, I don't recognize exactly about the item.
If you have any idea of Async I/O Subsystem,
would you rely me?

Have a nice day!!!!!
Also thanks Michael Tully.

From South Korea, Lee Joon Moon
Yogeeraj_1
Honored Contributor

Re: What is the best Kernel Parameter on oracle 8.1.7.2?

hi,

i would also consider the latest patchset 8.1.7.4.

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Geoff Wild
Honored Contributor

Re: What is the best Kernel Parameter on oracle 8.1.7.2?

Here's some guidelines we follow...

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Steven E. Protter
Exalted Contributor

Re: What is the best Kernel Parameter on oracle 8.1.7.2?

The December 2000 or December 2001 patch set for 11.00 did cause problems with Asynchronous I/O

This is fixed the the following configuration file:

/etc/privgroup

Mine has:

dba MLOCK
sag MLOCK

This allows the groups dba and sag, both database apps requireing ansynchronous access to properly lock memory. Oracle may have other recommendations on this topic as well.

Attaching a close to current kmtune output file

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