- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to tune kernel for Oracle 9i on HP Ux
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
тАО05-11-2004 04:51 PM
тАО05-11-2004 04:51 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2004 05:03 PM
тАО05-11-2004 05:03 PM
Re: How to tune kernel for Oracle 9i on HP Ux
Good luck,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2004 05:33 PM
тАО05-11-2004 05:33 PM
Solutiondo you happen to have access to Oracle Metalink? if so, refer to Document ID: 169706.1
if not, an extract of the kernel parameters for HP-UX 11.11 running 9.2.0 are :
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
regards.
(p.s. some points would be appreciated.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2004 05:43 PM
тАО05-11-2004 05:43 PM
Re: How to tune kernel for Oracle 9i on HP Ux
You probably want to have between 3 and 4 gb of swap to allow you to maximize shared memory.
shmmax can go up to 25% of memory which is defined as RAM plus swap
If you do an itrc search you'll see i've posted my working kernels as well. Mine also take ias and ias 10G into account. If this thread is still current, I'll upload one in the a.m.
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
тАО05-12-2004 01:55 PM
тАО05-12-2004 01:55 PM
Re: How to tune kernel for Oracle 9i on HP Ux
try:
dbc_max_pct 10
dbc_min_pct 5
or even less. That way u will have more mem to allocate the databases.
Also use glance to see if your sys tables are big enough.
enjoy, Isaac
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2004 12:53 AM
тАО05-13-2004 12:53 AM
Re: How to tune kernel for Oracle 9i on HP Ux
APPENDIX E - Kernel Parameters
Parameter Value Description
MAXVG 256 Maximum number of volume groups
MAXFILES 2048 Soft limit on how many files a single process can have opened or locked at any given time.
NFILE 4096 Maximum number of files that can be open simultaneously on the system at any given time.
NINODE 20000 Maximum number of open inodes that can be in memory.
MSGSEG 4096 Maximum number of message segments that can exist on the system.
NPROC 1024 Defines the maximum number of processes that can be running simultaneously on the entire system, including remote execution processes initiated by other systems via remsh or other networking commands.
SHMMAX 1073741824 Maximum allowable shared memory segment size (in bytes).
SHMMNI 100 Maximum number of shared memory segments allowed on the system at any given time.
SEMMNS 500 Maximum number of individual IPC semaphores available to system users, system-wide.
SHMSEG 10 Maximum number of shared memory segments that can be attached simultaneously to any given process.
DBC_MAX_PCT 10 Maximum percentage of memory for dynamic buffer cache (should be between 350 and 600 MB)
NPTY 256 Pseudo terminals
NSTRPTY 256 Max Number of Streams-Based PTYs
MAX_THREAD_PROC 256
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2004 06:27 AM
тАО05-14-2004 06:27 AM
Re: How to tune kernel for Oracle 9i on HP Ux
E.