- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- mincache=direct & convosync=direct for Oracle
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
тАО03-26-2003 05:46 AM
тАО03-26-2003 05:46 AM
Our application would be random & sequential read say 80/20 weight.
1) IS this worth for us to acquire the OnlineJFS product (at what cost)- What is the performance gain (observed not theory please)
2) Do we have to convert existing vxfs file systems and if so what is involved (downtime ?) ?
HPUX 11.0 - Oracle8.1.7.4 64bits - storage on XP128 - with 2 Fibre attachment - RAID1
thanks,
Jean-Luc
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 05:55 AM
тАО03-26-2003 05:55 AM
Re: mincache=direct & convosync=direct for Oracle
2. You need Online JFS for these.
3. I don't think you have to convert anything, as long as you have vxfs file systems already.
4. OnLine JFS is worth it's weight in gold because it allows you to change (increase) file system sizes on the fly while the system is running. Have you ever had to take the system down in the middle of the night to increase /usr or /oracle/SID/sapdata25? With OnLine JFS you never have to take the system down or come in off hours to increase file system sizes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 06:05 AM
тАО03-26-2003 06:05 AM
Solution2. No, you wont have to convert exsiting filesystems. Even if you did the vxupgrade is instantaneous - no downtime needed to upgrade.
Weve tried these options for oracle databases and we found very little performance increase. As well as turning on these mount options you need to tune/modify your oracle database/application to adjust the block size to be a multiple of the filesystem block size, and not all applications do this. If you are prepared to spend quite a bit of time tuning your database to get these options to work fully then the possible performance increase is up to double the current I/O performance, but we didnt think it was worth it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 06:46 AM
тАО03-26-2003 06:46 AM
Re: mincache=direct & convosync=direct for Oracle
It is really dependent on how your database is setup. I tried to benchmarking with these options and I got around 5-7% of increase in the throughput.
You do not need to convert the filesystems to make use of OnlineJFS provided if you have Vxfs filesystems. Even you don't need to unmount the filesystems to enable these options. You can use 'remount' option if you want to change these parameters.
Ours is RAID-5 with XP512. We have a large number of RAID groups and have the flexibility of alloting LUNs in the way we want. We do lvm-striping with 128k, 256k and it is giving us significant improvement in the throughput.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 07:39 AM
тАО03-26-2003 07:39 AM
Re: mincache=direct & convosync=direct for Oracle
If you want to use them, then use convosync=direct,mincache=direct,delaylog,nodatainlog for datafiles and indices and use delaylog,nodatainlog for redo and archive logs.
The main advantage of bypassing the buffer cache was that by limiting the size of the buffer cache, you could increase the size of the SGA but now that systems have very large amounts of memory, I find that cooked files win on 11.11 everytime.
2) No, but you might want to convert your existing Jvxfs filesystems to Version 4 - which can be done "on the fly" and takes a few minutes to complete.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 09:01 AM
тАО03-26-2003 09:01 AM
Re: mincache=direct & convosync=direct for Oracle
OnlineJFS does not seem to be much help for me, if I gain *only* 10% !
I understand that the 1st advantage is to increase fs size on the fly, but we are not 24x7 shop and id does not happen that often.
So much for an *expensive* product.
Should I add that AIX "offer" the increase size on the fly.
I think HP should have it as standard feature..
Clay, is vxfs version 4 any good to me re performance ?
thanks,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 09:22 AM
тАО03-26-2003 09:22 AM
Re: mincache=direct & convosync=direct for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 09:33 AM
тАО03-26-2003 09:33 AM
Re: mincache=direct & convosync=direct for Oracle
If you do striping, then Version 4 JFS may help you quite a bit. It offers tuning options like read_pref_io, write_pref_io that can help you customize your environment for optimal performance.
There are other options like discoverd_direct_io etc., that may be used to improve the performance.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2003 08:24 PM
тАО03-26-2003 08:24 PM
Re: mincache=direct & convosync=direct for Oracle
to add to the excellent replies above, i would also recommend reading the following article from Oracle.
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 03:45 AM
тАО03-27-2003 03:45 AM
Re: mincache=direct & convosync=direct for Oracle
Yogeeraj, I already have the document but as I'm connected to a SAN (XP128), this does not apply really. Writes are done to the cache (therefore the more cache the better) and Reads are from the cache and I suppose it depends on how many spindles you have behind ,... I'm not to sure about how XP128 react with hot spots.
As far as I know the disks used for this server are RAID1+ , it's HP own version for RAID10 (RAID 0+1), eventhough I have not found out what is the stripe size. And if I know it, should I change some of the OS parameters and/or some of the Oracle database parameters
Jean-Luc