- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 10g with HPUX 11i filesystem recommend
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
тАО06-28-2007 04:59 AM
тАО06-28-2007 04:59 AM
Oracle 10g with HPUX 11i filesystem recommend
For datafiles on a VA7400 array:
Raw or filesystem?
HFS or VxFS?
Not RAC, nothing fancy just an OLTP Oracle database, about 200GB of data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2007 05:06 AM
тАО06-28-2007 05:06 AM
Re: Oracle 10g with HPUX 11i filesystem recommend
HFS or VxFS? VxFS
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2007 05:16 AM
тАО06-28-2007 05:16 AM
Re: Oracle 10g with HPUX 11i filesystem recommend
Vxfs or hfs? Always vxfs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2007 05:18 AM
тАО06-28-2007 05:18 AM
Re: Oracle 10g with HPUX 11i filesystem recommend
Before you decide on filesystems and such, please CONSIDER Oracle ASM, as that might change to approach completely.
I'm not saying not recommending you should actually choose to use it, but you should make a concious decision about it.
I'm a little sceptical towards ASM but am hearing more and more positive feedback.
What BACKUP method are you planning to use?
If it is Rman, then raw becomes more interesting
How critical is performance? CPU to spare? The more critical, and the less resources to spare the more interestinf RAW (or ASM) becomes.
What are the HPUX and Oracle skills in house? Comfortable slicing and dicing LUNs and Volumne groups? Then RAW becomes more interesting again.
Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2007 03:22 AM
тАО06-29-2007 03:22 AM
Re: Oracle 10g with HPUX 11i filesystem recommend
In a performance analysis review with HP and Oracle, mincache=direct on the filesystems was heavily tested and it was determined that OS caching was actually BETTER than Oracle's caching algorithms. (v11.11)
We've also separated off each mount point as it's own volume group and associated LUN using LUNs no greater that 100GB. (/u01 is vg01, which has it's own LUN.) It's a pain to manage, but HP and Oracle said we should do it and it did make a difference afterwards...
If you aren't using SecurePath or some other multipathing software, enusre that you are balancing your primary disk paths between the array controllers. (e.g. RG2 uses controller 2 as the primary path)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2007 04:42 AM
тАО06-29-2007 04:42 AM
Re: Oracle 10g with HPUX 11i filesystem recommend
VxFS you should also consider to have the licensed sw 'OnlineJFS' so you can extend the filesystem online !!!
(part of some HP-UX licenses, otherwise separate product)
Mount options is also important.
Consider these for your system.
FS for Oracle sw/log files:
============================
rw,nodatainlog,delaylog,largefiles
FS for Oracle DB datafiles:
===========================
rw,nodatainlog,delaylog,largefiles,mincache=direct,convosync=direct
/Tor-Arne
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2007 04:43 AM
тАО06-29-2007 04:43 AM