- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: kernel recommended parameters
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
тАО06-21-2003 10:17 PM
тАО06-21-2003 10:17 PM
kernel recommended parameters
I am installing Oracle Applications 11i(11.5.8) on HP-UX (11.11)
I face problems in creating the database that seem to be due to kernel parameters,
I assigned the minimum required values for kernel parameters as they are in installation manual.
can you give the recommended values for the kernel parameters for this installation.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2003 10:42 PM
тАО06-21-2003 10:42 PM
Re: kernel recommended parameters
http://docs.oracle.com
http://docs.oracle.com/DOCS_DOT_PDF_Storage/a86566.pdf
Here is what we use on our only oracle server which is being used for data warehouse. These were the recommendations from oracle themselves. You may need to make changes to your buffer cache settings depending on the amount of RAM you have. (dbc_min_pct & dbc_max_pct)
* Configurable Parameters
STRMSGSZ 65535
dump lvol
dbc_max_pct 10
dbc_min_pct 2
ksi_alloc_max (NPROC*8)
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
nstrpty 1024
nstrtel 1024
npty 1024
semmap (SEMMNI+2)
semmni 4096
semmns (SEMMNI*2)
semmnu (NPROC-4)
semvmx 32768
shmmax 4294967295
shmmni 512
shmseg 32
st_ats_enabled 0
vps_ceiling 64
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2003 10:53 PM
тАО06-21-2003 10:53 PM
Re: kernel recommended parameters
Did you install all the patches are required?
Attached the "Installation Update Notes"
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2003 02:12 AM
тАО06-22-2003 02:12 AM
Re: kernel recommended parameters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2003 02:36 AM
тАО06-22-2003 02:36 AM
Re: kernel recommended parameters
HP-UX Operating system running Oracle 8.X & 9.X Enterprise Edition. Hope it can help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2003 05:31 AM
тАО06-22-2003 05:31 AM
Re: kernel recommended parameters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2003 03:46 PM
тАО07-13-2003 03:46 PM
Re: kernel recommended parameters
init.ora PROCESSES: this controls how many processes one instance may run. While NPROC and MAXUPROC obviously limit this, each instance will also allocate this many semaphores on startup whether or not it starts this many processes. So SEMMNI and SEMMNS must be set high enough for all instances on the system. Using shared servers so that each client does not need a dedicated process can reduce the amount of processes each instance needs.
kernel NFLOCKS: Each oracle instance acquires a file lock on all of the database files, so the NFLOCKS parameter must be high enough for all datafiles in all running instances on the system.
kernel NFILE: Similar to above, but each Oracle process will open every datafile.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2003 06:21 PM
тАО07-13-2003 06:21 PM
Re: kernel recommended parameters
http://www2.itrc.hp.com/service/cki/search.do?category=c0&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchString=UPERFKBAN00000726&search.y=8&search.x=28&mode=id&admit=-1335382922+1058149042333+28353475&searchCrit=allwords
A document which is updated every six months by one of HP's top Oracle performance experts.
I'm also attaching my data collection scripts. These are useful for spotting bottlenecks after the applicaiton is up and running.
Further, note that shmmax should never be set to more than 25% of system memory. This is defined as physical memory plus swap.
If you have 2 GB of RAM and 2.0 GB of swap then shmmax will ignore any setting greater than 1 GB anyway.
My current favorite on swap setting for Oracle is as follows:
On smaller primary swap area equal to half of physical memory, priority one.
A second larger swap area equal to 1.5 times physical memory priority 2.
The system really flies when its running light or medium loads and not using the second swap area.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com