- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle fundamentals of a HPUX SA
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
тАО05-19-2001 06:37 AM
тАО05-19-2001 06:37 AM
Oracle fundamentals of a HPUX SA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2001 06:51 AM
тАО05-19-2001 06:51 AM
Re: Oracle fundamentals of a HPUX SA
In your Oracle documentation, they will always give you tunable parameters that they recommend you change. Some of these are of course common sense, others are a bit more obscure.
Other things, I think are common sysadmin things that help performance. I.E. How much RAM, creating swap over many disks with the same priority to ensure syncronous activity, removing all unnecessary services, HFS file system for /tmp for faster access, good cleanup procedures, etc...
Quite frankly, I keep a lot of my own notes for different types of servers including file system minimums, kernel minimums and formulas, etc... Mainly because FEA compute servers have many different needs than an Oracle DB server....
Regards,
Shannon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2001 03:39 PM
тАО05-19-2001 03:39 PM
Re: Oracle fundamentals of a HPUX SA
There used to be a cource taught jointly by HP and Oracle 'Managing Oracle on HP-UX'. When I took it, it was 'Managing Oracle7 on HP-UX 10.x'. It dealt with exactly the parameters you are interested in. Unfortunely I don't see it listed anymore. You might contact HP or ORACLE Education and see if the class is still available. The best feature of the course was that we students trusted nothing the guys were saying and measured everything. The first thing we found was forget HFS use OnLineJFS with convosync=direct,mincache=direct for datafiles and indices.
Regards, Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-19-2001 11:18 PM
тАО05-19-2001 11:18 PM
Re: Oracle fundamentals of a HPUX SA
here is a good link for hp-ux oracle :
http://www.hporaclectc.com/html/database.html
it this link you will find info about kernel param and patches and more info .
and also you can find cookbook for install !!!.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2001 04:48 PM
тАО05-20-2001 04:48 PM
Re: Oracle fundamentals of a HPUX SA
So you might look into some education services and see what they offer....
Just a thought,
/rcw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2001 03:58 PM
тАО05-21-2001 03:58 PM
Re: Oracle fundamentals of a HPUX SA
Seems that Clay and Shannon have a difference of opinion regarding file system types. I tend to prefer vxfs for a bunch of reasons, but the comment that access is faster on hfs is one I would like more of an explanation before I buy it.
So it looks like I need to become a DBA in yet another environment. From what I've experienced so far with this one using Oracle based apps is that it is totally different than what I've seen with an Oracle data warehouse. Also, please excuse my bonehead subject line - I'm naturally confused.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2001 05:12 PM
тАО05-21-2001 05:12 PM
Re: Oracle fundamentals of a HPUX SA
First, I dont want to be misleading. JFS can be faster, but only when there are lots of spindle to spread the load. Normal OS opperations may mirror the OS volumes, but it will not take advantage of striping. Just common sense OS layout without wasting tons of disk will dictate this.
Because HFS is direct read/write as opposed to logging, compression, etc... On a single disk running mirrored HFS will give better performance. IT may not ve huge, but it's enough to make a difference if anything is writing alot to /tmp. Most of the time, listener startup logs are there, lots of script activity, etc...
JFS has benefits when striping volumes over many disks. Plain and simple. The benefits of somethin like /tmp being HFS are miniscule but we all know that on a busy server, every little bit helps!
Regards,
Shannon