- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle /HP-UX tuning question.
Operating System - HP-UX
1752682
Members
5535
Online
108789
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
Discussions
Discussions
Forums
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
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
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
тАО08-29-2003 11:17 AM
тАО08-29-2003 11:17 AM
Re: Oracle /HP-UX tuning question.
Hi,
from my experience, you will have a much easier job to make users happy by tuning oracle than by tuning OS (HP-UX or else).
Reason: With OP-Sys tuning, you are only able to fix "general" problems, but you will never be able to fix "special" problems, and there are tons of them caused by application design or data-modell. Beside a truly bad kernel misconfiguration (which should never happen if one reads the fine manual upon installation) you will never have the opportunity to speed up a business process by a factor of 10000 (plus/minus one or two zeros) with the parameters the operating system gives you.
But by optimizing bad queries with indexes you easyly can do this and there are lot's of them out there.
So be happy, to get a multiplexed admin/dba job, which I always find to be a thrilling job due to it's complexness. The disadvantage is, you will not be able to dive too deep into it if you are specialized with only one of these topics. I am a SAP consultant. I know a part of the op-sys, part of database and part of the application SAP. This gives me a good chance to optimize an application process with in the first 30%-60% (and if it comes to exchange a full table scan with a direct index-access it can not be measured in percent any more :-)
That is the part I like most !
But I have to admit: If you are finished with basics (or averages after a couple of years), I envy the true specialists that have the deep knowledge of their special area. I had the glory opportunity at the beginning of the year to watch some real Oracle-Tuning-Gurus at work and that was an amazing thing.
But this just occurs in 5% of my environment, so I am happy with the other setup an yell for help in this rare cases :-)
Be happy with your new and expanded tasks
Volker
from my experience, you will have a much easier job to make users happy by tuning oracle than by tuning OS (HP-UX or else).
Reason: With OP-Sys tuning, you are only able to fix "general" problems, but you will never be able to fix "special" problems, and there are tons of them caused by application design or data-modell. Beside a truly bad kernel misconfiguration (which should never happen if one reads the fine manual upon installation) you will never have the opportunity to speed up a business process by a factor of 10000 (plus/minus one or two zeros) with the parameters the operating system gives you.
But by optimizing bad queries with indexes you easyly can do this and there are lot's of them out there.
So be happy, to get a multiplexed admin/dba job, which I always find to be a thrilling job due to it's complexness. The disadvantage is, you will not be able to dive too deep into it if you are specialized with only one of these topics. I am a SAP consultant. I know a part of the op-sys, part of database and part of the application SAP. This gives me a good chance to optimize an application process with in the first 30%-60% (and if it comes to exchange a full table scan with a direct index-access it can not be measured in percent any more :-)
That is the part I like most !
But I have to admit: If you are finished with basics (or averages after a couple of years), I envy the true specialists that have the deep knowledge of their special area. I had the glory opportunity at the beginning of the year to watch some real Oracle-Tuning-Gurus at work and that was an amazing thing.
But this just occurs in 5% of my environment, so I am happy with the other setup an yell for help in this rare cases :-)
Be happy with your new and expanded tasks
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 11:31 AM
тАО08-29-2003 11:31 AM
Re: Oracle /HP-UX tuning question.
I strongly urge you to take an Oracle database administration class and you may need the kindergarten SQL class as well if you are not familiar/proficient with SQLPlus.
In the vast majority of cases, the performance problems lie in the SQL but unless you have some level of proficiency in Oracle, you are not going to have the credibility to assert that claim or really know how to discern the Oracle from the OS problems.
In the vast majority of cases, the performance problems lie in the SQL but unless you have some level of proficiency in Oracle, you are not going to have the credibility to assert that claim or really know how to discern the Oracle from the OS problems.
If it ain't broke, I can fix that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 09:29 PM
тАО08-29-2003 09:29 PM
Re: Oracle /HP-UX tuning question.
Hi Ben
As most of the others have said, the HP-UX side is pretty straight forward in the sense that it involves tuning a few kernel parameters, tuning the system for general performance & being aware of a few mount options available with Online JFS that can sometimes improve Oracle performance.
One thing I'd advise is becoming very familiar with your system performance & to keep historic performance data (eg through MWA or sar?).
The majority of Oracle performance issues are resolved on the Oracle side ( eg a change to the SQL code, change an SGA parameter(s) etc). You need to be able to eliminate pretty quickly any OS issues such as CPU, Memory, Disk or Network bottlenecks.
To me Oracle Tuning is one of the more advanced areas of Oracle DBA work. I'd certainly advise getting some good basic knowledge of Oracle so that you can confidently talk with the DBA's about their SGA configurations & be able to reliably tell them the performance issue is not OS related.
One last issue if you're running 32bit Oracle is to become familiar with Shared memory operations with HP-UX as this is often a limiting factor in SGA size etc.
Good luck, sounds like a fun & challenging job.
Cheers
Con
As most of the others have said, the HP-UX side is pretty straight forward in the sense that it involves tuning a few kernel parameters, tuning the system for general performance & being aware of a few mount options available with Online JFS that can sometimes improve Oracle performance.
One thing I'd advise is becoming very familiar with your system performance & to keep historic performance data (eg through MWA or sar?).
The majority of Oracle performance issues are resolved on the Oracle side ( eg a change to the SQL code, change an SGA parameter(s) etc). You need to be able to eliminate pretty quickly any OS issues such as CPU, Memory, Disk or Network bottlenecks.
To me Oracle Tuning is one of the more advanced areas of Oracle DBA work. I'd certainly advise getting some good basic knowledge of Oracle so that you can confidently talk with the DBA's about their SGA configurations & be able to reliably tell them the performance issue is not OS related.
One last issue if you're running 32bit Oracle is to become familiar with Shared memory operations with HP-UX as this is often a limiting factor in SGA size etc.
Good luck, sounds like a fun & challenging job.
Cheers
Con
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 10:23 PM
тАО08-29-2003 10:23 PM
Re: Oracle /HP-UX tuning question.
Hi,
Ben, The best way to learn Oracle is to work with Oracle. The most important aspects in Oracle are installing, tuning and recovery from backups. Also, reading on otn.oracle.com will help. Take a course in Oracle 9i DBA if you can, very helpful.
Get RedHat 9 and download Oracle 9i from oracle.com and play with it.
You may be interested in these sites also:
http://www.orafaq.net/
http://searchoracle.techtarget.com/
- « Previous
-
- 1
- 2
- Next »
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.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP