- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Why oracle recommand using file system to store da...
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-27-2003 11:49 PM
тАО06-27-2003 11:49 PM
I'm a junior dba at oracle. Do anyone answer me following questions?
1, Why oracle recommand using file system to store data? According as I know, most of oracle database store data in file system rather raw device.
2, Why oracle using raw device to store data in OPS environment? Can I implement OPS using file system?
We know raw device provide better i/o performance, informix, sybase using raw device to store data, but oracle doesn't recommand.
thanks ....
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2003 01:24 AM
тАО06-28-2003 01:24 AM
Re: Why oracle recommand using file system to store data?
When choosing a file system, performance is not the most important point. A fast file system is not usable, if there is a risk that data is corrupted, lost or compromised. Oracle database does not support files on file system that do not have a write-through-cache capability. The file system must acknowledge the write operations.
For example Standard NFS uses the UDP protocol, which does not include an acknowledgment. One vendor that supplies a supported network file system is Network Appliance using a modified NFS protocol. There are security requirements as well. Oracle Server and the database files require special file permissions, which are not available on certain file system (such as VFAT). If these file permission are not set correctly, the Oracle server does not function properly. Data files should be accessible only for the database owner. The database server should control all other file and data access. Journaling is a popular characteristic. The major benefit is that the changes to the file system are recorded in a journal file. If the server crashes or shuts down without synchronizing the disk, the journal file can be applied to the file system. Restore such file system integrity is very fast. This effect can be seen on boot up. The fsck command checks journaled file system more quickly than nonjournaled file system.
2.
Some implementations of Oracle Parallel Server require that all Data files and control files are placed onto raw devices so that the different nodes of the parallel environment are all able to see and access the files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2003 03:07 AM
тАО06-28-2003 03:07 AM
Re: Why oracle recommand using file system to store data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2003 03:51 AM
тАО06-28-2003 03:51 AM
Solution1B- File systems and Oracle aren't going away. A few months ago Oracle announced the OCFS, or LCFS, which is recommended with 9i RAC on LINUX. That's Oracle/LINUX Cluster File System. Oracle is recommending it for tuning and database management on LINUX servers.
2A - Given 1A large databases need raw file systems.
In my opinion Oracle is jumping into and supporting LINUX in a big way in the small database market. I personally know Oracle is recommending LINUX as their UNIX O/S of choice for I've met with HP clients that visit Oracle in Redwood City who are told this explicitly. These current HP clients are being told to save money and buy LINUX 'disposable' servers because of their low cost.
I think this all underscores the changes that the enterprise server market is going through and in particular Oracle's push for more control of this market. Its even conceivable that Oracle will attempt to combine their database with the O/S at some point in the future. This has been tried by other databases before, i.e., the PICK database.
The distinction between database and O/S is control of physical devices and by creating their own LCFS Oracle breeches into control of physical devices.
2B) Given this, as HP is attempting to cut into the Windows and Solaris markets I'm concluding that Oracle is attempting to cut into HP's market.
Because they're all worried about future sales which are determined by controlling the marketplace.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-28-2003 04:07 AM
тАО06-28-2003 04:07 AM
Re: Why oracle recommand using file system to store data?
You can add comments to /etc/fstab in hopes that a sysadmin will read it but tools like SAM and newfs as well as the LVM commands have no safety checks except for HFS and VxFS filesystem identifiers. Informix and Sybase have historically used raw devices and have optimized their code for that design. Oracle can do a very good job in managing filesystem performance as long as the SGA is large enough to take advantage of RAM-based transactions such as full row insertions and temp sort areas in memory. This assumes that the sysadmin separates the installation directories, the database mountpoints and the index, rollback and archive logs onto physically separate disk devices and I/O channels.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2003 08:57 PM
тАО06-29-2003 08:57 PM
Re: Why oracle recommand using file system to store data?
To add to the above great replies,
From what i have read, on a UNIX OS, the benefit of raw over cooked are very minimal and mostly in special cases. If you are not comfortable with raw, you can consider staying with a cooked file system. Many OS's/volume managers have options to mount their cooked file systems without buffering.
You should also have a look at the the excellent writeup by one the best Oracle technologists.
[file is attached]
best regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2003 08:59 PM
тАО06-29-2003 08:59 PM
Re: Why oracle recommand using file system to store data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2003 09:06 PM
тАО06-29-2003 09:06 PM
Re: Why oracle recommand using file system to store data?
Its going to make my transition from 8 to 9 a large pain in the you know what.
I am used to raw disk because I'm a dba with Software AG Adabas. I was actually shocked when we went to Oracle and they used filesystems, but got used to it.
SEP
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
тАО06-29-2003 11:03 PM
тАО06-29-2003 11:03 PM
Re: Why oracle recommand using file system to store data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-29-2003 11:57 PM
тАО06-29-2003 11:57 PM
Re: Why oracle recommand using file system to store data?
Perhaps others can offer their advice on your other questions.
Outside of OPS, the only benefit to using raw devices is when the database is clearly I/O-bound. If I/O is not a bottleneck, then using raw devices will not improve performance.
Therefore in my option, the ONLY reason to use raw devices in non-OPS environments is the small benefit of bypassing the JFS cache on reads. Again, I/O contention is seldom the bottleneck for a database, and hence, most database see no benefit from using raw devices.
Hope this helps . . .