- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: What is the best Kernel Parameter on oracle 8....
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2004 03:54 PM
тАО03-01-2004 03:54 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2004 04:10 PM
тАО03-01-2004 04:10 PM
SolutionKernel
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2004 04:11 PM
тАО03-01-2004 04:11 PM
Re: What is the best Kernel Parameter on oracle 8.1.7.2?
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2004 05:08 PM
тАО03-01-2004 05:08 PM
Re: What is the best Kernel Parameter on oracle 8.1.7.2?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2004 05:09 PM
тАО03-01-2004 05:09 PM
Re: What is the best Kernel Parameter on oracle 8.1.7.2?
i would also consider the latest patchset 8.1.7.4.
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2004 01:35 AM
тАО03-02-2004 01:35 AM
Re: What is the best Kernel Parameter on oracle 8.1.7.2?
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2004 01:45 AM
тАО03-02-2004 01:45 AM
Re: What is the best Kernel Parameter on oracle 8.1.7.2?
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com