- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle /HP-UX tuning question.
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-29-2003 05:01 AM
тАО08-29-2003 05:01 AM
Oracle /HP-UX tuning question.
I am currently working on hp-ux 11.o environment and quite familiar with all aspects of system administrationn and trouble shooting skills with about 5 years experience. Now i have got a change of Job and looks like in the new Job they require HP-UX with oracle tuning experience. Can someone throw more light on this subject? I mean what exactly would this mean and what are the new things i might have to be familiar with. This is a System Admin Job.
Thanks
Ben.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 05:09 AM
тАО08-29-2003 05:09 AM
Re: Oracle /HP-UX tuning question.
The Oracle part means particular to running Oracle on HP-UX. You will have to ask DBAs about this: Is the SGA large enough, are the oracle file systems layed out properly (indices and the tables on different disks, etc.).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 05:09 AM
тАО08-29-2003 05:09 AM
Re: Oracle /HP-UX tuning question.
I think your best source of information on oracle tuning can be had right here with a simple search on oracle and tuning. The funny thing is that once the DB is set up and the machine "tuned", then there isn't a lot to do but sit back and monitor the system. Now if you are going to get into tuning SQL, that's another story for which SQLLAB is a good thing to know how to use.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 05:15 AM
тАО08-29-2003 05:15 AM
Re: Oracle /HP-UX tuning question.
Oracle8i and 9i are all pretuned, you no need to tune as we did in oarcle 7x. New job requires a person who is well versed with HP-UX admin and Oracle DBA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 05:16 AM
тАО08-29-2003 05:16 AM
Re: Oracle /HP-UX tuning question.
Upper management (and many DBAs too) think that if the Oracle code produces correct answers then all is well and the SysAdmin for HP-UX must improve performance. That is almost never the case. Instead, the SysAdmin must point out to the DBA when massive disk I/O is being generated by Oracle and work on reducing I/O with better memory usage opr eliminating needless I/O through the use of indexes and SGA-based sort areas.
There are numerous examples of fine tuning Oracle and HP-UX here in the forums. Look for keywords like: oracle shared memory sga sql performance
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 05:23 AM
тАО08-29-2003 05:23 AM
Re: Oracle /HP-UX tuning question.
I suppose i you come for sysadmin , you would need to understand the oracle architecture & installation, impact on kernel parameters, memory usage , IO spread,...
Will you be working with a DBA ?
Will you be trained ???
in the mean time , a few web sites :
http://www.ixora.com.au/tips/
http://www.dbasupport.com/oracle/scripts/Performance_Tuning/Memory_Tuning/
Rgds,
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 05:50 AM
тАО08-29-2003 05:50 AM
Re: Oracle /HP-UX tuning question.
With respect to OS tuning, there's not so much to do, as noted. Monitoring and diagnosing is the key activity for the sysadmin on an Oracle box, mainly i/o activity and memory usage. In particular, we've recently come to understand that Oracle Applications (e.g. Financials) fragments memory in ways that will seriously degrade performance without being visible using standard memory monitoring. Search on "fragmentation" here for scripts to help with spotting that.
What I'd like to see happening more is for sysadmins to undertake to understand the Oracle SGA and its parameters better, well enough to recommend or implement tuning measures within the Oracle configuration. This is traditionally a DBA activity, but the DBA is more and more absorbed with application function issues, like writing and troubleshooting PL-SQL code for triggers, packages, etc., and less and less oriented to systems issues. The application duties were one of the reasons I walked away from being a DBA a few years ago.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 06:43 AM
тАО08-29-2003 06:43 AM
Re: Oracle /HP-UX tuning question.
As far as the OS goes, this doc is a great start.
http://www1.itrc.hp.com/service/cki/search.do?category=c0&mode=id&searchString=UPERFKBAN00000726&search.x=28&search.y=8&searchCrit=allwords&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty
DOC ID
UPERFKBAN00000726
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-29-2003 06:59 AM
тАО08-29-2003 06:59 AM
Re: Oracle /HP-UX tuning question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2003 07:06 AM
тАО08-29-2003 07:06 AM