HPE GreenLake Administration
- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: OLTP tuned parameter sets for 11i
Operating System - HP-UX
1833861
Members
2001
Online
110063
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- 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-18-2004 04:41 AM
03-18-2004 04:41 AM
We are currently setting up an rp7410, running 11i, for a database application. Our current servers are all running 11.00. When I went to SAM to apply the OLTP Tuned Parameter Set as had been done on the previous systems, the OLTP sets were not listed. I compared /usr/sam/lib/kc/tuned and found the oltp_*.tun files do not exist on the 11i box, only the eng workstation .tun files are there.
I am considering the following options:
1) Can the missing *.tun files be loaded from the install CD or found somewhere else?
2) Could I use the *.tun files from an 11.00 install?
3) Would a template created from our 11.00 box work on the 11i kernel?
Any suggestions would be greatly appreciated.
Dan
I am considering the following options:
1) Can the missing *.tun files be loaded from the install CD or found somewhere else?
2) Could I use the *.tun files from an 11.00 install?
3) Would a template created from our 11.00 box work on the 11i kernel?
Any suggestions would be greatly appreciated.
Dan
...skid in sideways, chocolate in one hand, martini in the other, totally worn out and screaming, "WOO HOO what a ride!"
Solved! Go to Solution.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2004 04:55 AM
03-18-2004 04:55 AM
Solution
Avoid those OLTP Tuned Parameter Sets like the plague. Everyone of those (which were intentionally omitted from 11.11) set timeslice to 1 (rather than 10). As the machine begins to load, the box will do context switching and very little else.
I've always found that you can do much better on your own than these things.
I've always found that you can do much better on your own than these things.
If it ain't broke, I can fix that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2004 05:41 AM
03-18-2004 05:41 AM
Re: OLTP tuned parameter sets for 11i
Clay -
I am aware that there are some settings that will need to be changed from the tuning set default, just wanted to get "in the ballpark" and tune from there. Can the current parms from our 11.00 box be used as a SAM "template", or am I best off just printing the current parms and adjusting each manually?
Thnx,
Dan
I am aware that there are some settings that will need to be changed from the tuning set default, just wanted to get "in the ballpark" and tune from there. Can the current parms from our 11.00 box be used as a SAM "template", or am I best off just printing the current parms and adjusting each manually?
Thnx,
Dan
...skid in sideways, chocolate in one hand, martini in the other, totally worn out and screaming, "WOO HOO what a ride!"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2004 06:00 AM
03-18-2004 06:00 AM
Re: OLTP tuned parameter sets for 11i
Because the workstation TUN's compare very closely between 11.0 and 11.11, I strongly suspect that you could copy them over; however, if this were me, I would do a kmtune on a good 11.0 box and manually change the 11.11 to closely. In many cases, I blow away most of the formulae and enter values directly.
Above all, leave timeslice VERY NEAR 10.
Above all, leave timeslice VERY NEAR 10.
If it ain't broke, I can fix that.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
Company
Events and news
Customer resources
© Copyright 2025 Hewlett Packard Enterprise Development LP