- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Mount options for Oracle filesystems
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
тАО12-12-2001 01:55 AM
тАО12-12-2001 01:55 AM
(1) To improve performance, what mount options shall I use?
(2) Will there be a gain in I/O performance when we move Oracle to other types of filesystems (like "Online JFS" or "Veritas Database Edition for Oracle on HP-UX") and with which options
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2001 02:13 AM
тАО12-12-2001 02:13 AM
Re: Mount options for Oracle filesystems
http://h21007.www2.hp.com/dspp/files/unprotected/devresource/Docs/TechPapers/UXPerfCookBook.pdf
... might help ...
Mount options are discussed in there (amongst other things).
Regards,
Tom Geudens
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2001 02:18 AM
тАО12-12-2001 02:18 AM
SolutionSome points to note:
1) For performance, the OS filesystem block size should be the same as the Oracle block size.
2) You should also use OS striping to improve performance. The stripe size should consider the db_file_multiblock_read_count.
Your stripe size should be the same or a multiple of
db_file_multiblock_read_count x db_block_size
3) Do not stripe the redo log filesystems as they are only sequentially written.
Hope this helps. Regards.
Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2001 02:21 AM
тАО12-12-2001 02:21 AM
Re: Mount options for Oracle filesystems
the tuning parameters you need/want for Oracle on vxfs are only available if you have OnlineJFS.
Both OnlineJFS, and certainly Veritas filesystems for Oracle will/can improve performance, but they come with a price tag. Raw devices however are free, and produce maximum performance, but will require a little more effort on administration.
good luck,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2001 02:23 AM
тАО12-12-2001 02:23 AM
Re: Mount options for Oracle filesystems
one more imp things is to place index data files and table data files on the separate disks.
Use glance to find the IO activity by filesystem and try moving files from high IO disk to disk with lower IO rate.
Also for mounting the filesystem you may use mincache=direct.
Hope this helps
...BPK...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2001 08:24 AM
тАО12-12-2001 08:24 AM
Re: Mount options for Oracle filesystems
Online JFS certainly will give performance improvement. Use JFS3.3
Most of the file system mount options are related to Online JFS.
Following is the link explaining different mount options for JFS file systems.
http://us-support.external.hp.com/cki/bin/doc.pl/sid=d79c426517e3b6dc68/screen=ckiSearchResults?searchString=KBAN00000258&mode=id
Thanks.
Prashant.