- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- more kernel tuning
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
тАО08-26-2003 12:07 PM
тАО08-26-2003 12:07 PM
more kernel tuning
I've changed some of the basic params as recommended on this forum, but am looking for something to change to address a specific problem.
We have one customer with 16,000 locations. Our next biggest is around 2,000.
When we went past the 10K mark, performance for anyone that accesses that account sees a huge perfomance hit.
Oracle tells us to split the account into 2, but Finace folk are balking at that.
Is there a kernel limit I might be hitting once I start using such large tables? Are there other params. I need to address? ( attached is stand/system)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-26-2003 12:12 PM
тАО08-26-2003 12:12 PM
Re: more kernel tuning
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+1061928645238+28353475&searchCrit=allwords
Written by one of HP's crack oracle tuners.
You also might want to look at the glance system tables graph to see if you are hitting any limits.
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
тАО08-26-2003 12:33 PM
тАО08-26-2003 12:33 PM
Re: more kernel tuning
Your real answer is to analyze the SQL code and find where the queries are killing you. Many, many times I have found that adding just one index exceeded by an order of magnitude all the improvents made with new hardware and tuning.
The real tipoff is that you seem to be fine as long as you are under 2K rows.
This would be my approach to solving this (past displaying the database query plan):
Gather some data that correlates number of location vs. query times and plot the logarithm of the number of locations vs. query time. The slope of that line gives the order of the equation.
e.g slope ~ -1 --> linear, not bad
slope -2; quadratic, bad usually indicates an outer join using sequential access
slope worse that that -3,-4, disaster; serious improvements are needed. (e.g you might have an outer join inside an outer join and all the access is sequential.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-26-2003 02:09 PM
тАО08-26-2003 02:09 PM
Re: more kernel tuning
The params that Glance reports show that I'm not even close on any of them ( except buff pages)
Doing explain plans and repairing queries has become the story of my life, a constant battle.
I posted this looking to see if there were more obscure params that I was skipping. I remember in a previous life with System V params forgetting to raise callout table if I increased nproc, or forgetting to make file hash table a non prime value. It seems so simple today, that I thought I might be missing some dependency.
Thanks for the help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-26-2003 08:00 PM
тАО08-26-2003 08:00 PM
Re: more kernel tuning
Refer to the attached document for some Unix kernel parameters that should be monitored with changes to the oracle parameters in the init.ora file.