- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Tuned Kernel Parameter Sets and 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
тАО10-20-2000 04:38 AM
тАО10-20-2000 04:38 AM
I am currently trying to install Oracle 8.1.6 on a K380
running HP-UX 11 (64 bit).
The default kernel parameters are not enough...
My target host will be a RDBMs running two database instances with 50
simultaneous users and a total of 1000Gb:
Available Tuned Kernel Parameter Sets are:
* General OLTP/Database Client System
* General OLTP/Database Monolithic System
* General OLTP/Database Server System
What is the meaning of these sets (eg. difference between Client, Monolithic and
Server System).
Thanks in advance for your help,
Kind Regards,
Rui.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2000 04:48 AM
тАО10-20-2000 04:48 AM
Re: Tuned Kernel Parameter Sets and Oracle 8
Start with the 'server' template, just as a guide. If you have Glance, monitor your general performance. If you don't have Glance, get it, it's worth its weight in gold.
This thread is a good starting point for your tuning efforts:
http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xeb737e990647d4118fee0090279cd0f9,00.html
For general kernel tuning, see:
http://docs.hp.com/hpux/onlinedocs/os/KCparams.OverviewAll.html
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2000 04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2000 05:01 AM
тАО10-20-2000 05:01 AM
Re: Tuned Kernel Parameter Sets and Oracle 8
General OLTP/Database Server System is a good start to configuring a database server system but it has some limitations that you ought to correct:-
1) it assumes that you will be using raw I/O and consequently configures a small fixed size buffer cache. Set bufpages back to 0 and adjust dbc_min_pct and dbc_max_pct to appropriate values.
2) it disables pseudo-swap. Set swapmem_on back to 1.
3) it changes the CPU timeslice from 10 to 1ms, put it back to 10.
You may want to adjust some other parameters such as maxusers.
What I do is to compare the 'current' and 'pending' values of all the parameters and investigate those that have changed.
Hope this helps,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2000 05:04 AM
тАО10-20-2000 05:04 AM
Re: Tuned Kernel Parameter Sets and Oracle 8
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2000 11:42 PM
тАО10-24-2000 11:42 PM
Re: Tuned Kernel Parameter Sets and Oracle 8
I normaly uses:
General OLTP/Database Monolithic System
This works fine for several instances on the same machine, but if you install Oracle 8.1.6 64 bit you have to increase maxdsize to 200 Mb to relink oracle.
God luck