- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: File System vs Raw Device 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
тАО07-17-2002 10:23 AM
тАО07-17-2002 10:23 AM
File System vs Raw Device for Oracle
actually we are working with a 400GB OLTP Oracle database on raw device ( Oracle 8.1.7.x ) and we want to know about opinions of using raw devices or to migrate to file systems.
Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-17-2002 10:37 AM
тАО07-17-2002 10:37 AM
Re: File System vs Raw Device for Oracle
I've done these measurements and these are my conclusions ON MY DATA.
If you are running HP-UX 10.20 or 11.0, the best performance (essentially indistinguishable) from RAW/IO is obtained
using OnlineJFS mount options delaylog,nodatainlog,convosync=direct,mincache=direct for data files and indices. Redo and archive logs should be delaylog,nodatainlog.
The convosync=direct,mincache=direct option bypass the UNIX buffers and thus you are in essence raw/io. Typical maximum buffer cache size should be around 300MB. I find that setting a fixed buffer cache using bufpages is slightly better.
On 11.11, I've actually found that fully buffered I/O is the better performer. All files should be set to nodatainlog,delaylog AND increase buffer cache to about 900-1000MB.
The dynamic buffer cache routines are much improved in 11.11 so feel free to use them although for the present I'm stubbornly sticking to a fixed buffer cache but I've really not been able to measure any difference between reasonable dynamic buffer cache settings and good fixed buffer cache settings on my boxes.
---------------------------------------------
Of course, the real answer is to do the measurements yourself on your box and using your data.
----------------------------------------------
Don't overlook that maintenance (backups, restores, snapshots) is a very important factor as well; in that sense, filesystems win hands down.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-17-2002 10:57 AM
тАО07-17-2002 10:57 AM
Re: File System vs Raw Device for Oracle
With such large database this perhaps can be of interest:
http://veritas.com/products/category/ProductDetail.jhtml?productId=oracleeditionhp&_requestid=112719
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-17-2002 11:20 AM
тАО07-17-2002 11:20 AM
Re: File System vs Raw Device for Oracle
Quick IO and blocklevel backups from veritas seem to offer better performance but I haven't tried them yet.
Not to ignore, striping also can be considered to improve the performance and load balancing.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-17-2002 11:30 AM
тАО07-17-2002 11:30 AM
Re: File System vs Raw Device for Oracle
This is a nice thread :
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x7e0d72106351d5118fef0090279cd0f9,00.html
Manoj Srivastava