- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Mount options
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
тАО01-15-2003 06:58 AM
тАО01-15-2003 06:58 AM
Oracle Mount options
-o rw,suid,
convosync=direct,mincache=direct,delaylog,nodatainlog,largefiles
We are now suffering performance problems. It appears that our physical io rates are much larger than the logical io rates.
The purpose of the cahnge was to disable double buffering of the oracle data and index IO.
Is there something we need to do on the oracle configuration to let him take advantage of this change. Or did I screw up the mount options.
Additional information. This is oracle 8.1.7 running unger a service guard cluster. The disk is all switched fiber channel attached XP256. The oracle group does backups using cpio on the data and index file systems. They claim that these backups are taking longer. Is cpio affected by these mount options?
Any help would be appreciated.
Thanks
Jim Krol
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2003 07:01 AM
тАО01-15-2003 07:01 AM
Re: Oracle Mount options
Are you running HP-UX 11.0 or 11i?
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2003 07:05 AM
тАО01-15-2003 07:05 AM
Re: Oracle Mount options
Take a look at this post:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x402436e69499d611abdb0090277a778c,00.html
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2003 07:31 AM
тАО01-15-2003 07:31 AM
Re: Oracle Mount options
We use the following options,
vxfs rw,suid,largefiles,delaylog,datainlog
The Filesystems is vxfs / largefiles.
Hope this helps.
Regds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2003 07:33 AM
тАО01-15-2003 07:33 AM
Re: Oracle Mount options
convosync=direct,mincache=direct meens, that there is no use of the unix-buffer-cache.
This could be good for Oracle-datafiles and redofiles because Oracle has its own datacache (SGA).
However you make an cpio there is no use of the SGA, and every write to disk had to be acknowleged by disk.
convosync=direct,mincache=direct are good for datafiles but you should mount your Oracle binaries only with delaylog.
Best regards ...
Claus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2003 07:57 AM
тАО01-15-2003 07:57 AM
Re: Oracle Mount options
which took the defaults. I guess there is some wisdom in the "Don't touch it you'll break it" philosophy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2003 09:00 AM
тАО01-15-2003 09:00 AM
Re: Oracle Mount options
The mincache=direct option indeed effects cpio. Especially because cpio uses really small reads (4K) during backup.
Oracle usually opens its files using O_SYNC/O_DSYNC. So you may try to use the mincache default setting with only convosync=direct.
Best regards...
Dietmar.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 10:31 AM
тАО01-16-2003 10:31 AM
Re: Oracle Mount options
I am not sure this will add value as I believe if you are running a clustered oracle instance you'd be running OPS with raw files as file systems cannot be shared across nodes.
Anyway, I approached the bypass of the UNIX buffer by utilizing the disk_asynch_io = true in my init.ora. You must also have the async driver running within the O/S kernal. The async driver in /dev is owned by oracle.
Again, this may not apply to your situation, but it is working well for me to do what you are looking to do. Just a thought.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 10:47 AM
тАО01-16-2003 10:47 AM
Re: Oracle Mount options
Here are are current mount settings for oracle data fs, we've made no performance improvements, perhaps this is a problem.
/dev/vg00/oracle2 /oracle2 vxfs delaylog 0 2
Steve
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
тАО01-21-2003 08:58 AM
тАО01-21-2003 08:58 AM
Re: Oracle Mount options
There were vague references in metalink about worse performance if you do long sequential access to the DBs. Some of our databases were fine with the new mount options but others had a lot of heartburn.
Thanks to all that responded, I think I got points assigned to all. I guess it comes down to "don't touch it you'll break it", "you touched it, you broke it"
Jim Krol