- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesyst...
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
тАО10-15-2003 09:42 PM
тАО10-15-2003 09:42 PM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
-
To me, /dev/.... looks no different then /d01/oradata, they are just files after all.
-
I have been using both. For instance, if you consider online redo logs - You never touch online redo logs for anything -- so they are safe on raw (and benefit the most from it -- write intensive)...
-
I've also seen ardent fans who always prefer putting a system together to always go for raw. The reasons being:
-
a) a PIO as reported as Oracle is very likely to be a real PIO, so you get a true picture of whats going on
-
b) the buffering is controlled by Oracle so as a DBA I have more control over it, and Oracle should yield smarter buffering, since it knows thing like extent and segment boundaries
-
c) you typically get some benefits from the OS layer (kernelised aio etc)
-
d) you do *not* get autoextend. Seeing this as a benefit because it forces you to do some decent sizing and planning up front (sadly lacking in many databases)
-
The historical arguments against raw were always management, administrators, etc, but nowadays, every OS as a simple GUI or equivalent to resize them, move them, create/drop them as if they were file systems anyway.
-
Many people "afraid of raw" -- like it is "harder". Perhaps that is because the DBA needs SA help to set things up (needs root everynow and again) and they feel a loss of control. Or, they really don't understand what RAW means. A major "fear" for OPS/RAC adopters has always been "oh, i have to use raw". We had to create a cluster file system just to work around that!
-
hope this helps too!
-
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 09:42 PM
тАО10-15-2003 09:42 PM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
Hi,
We have Oracle 8i (8.1.7.4). All Oracle data files are mounted on file systems. Raw file systems as I recall reading from this forum have the advantage of speed. But it is not much of a difference. You can go with file systems with no worries.
More reading:
http://dbforums.com/arch/165/2001/10/810473
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 09:44 PM
тАО10-15-2003 09:44 PM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
In the past (remember OPS), we have used raw file systems but the unix management effort was too great, as was the difficulty in providing dev and test systems which truly mirrored live.
Technically it may not be compelling, but from a business point of view it is a no-brainer - the company would need a platoon oif unix guys to maintain all environemnts on raw. (Last count > 10 production databases and >100 pre-prod)
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 10:15 PM
тАО10-15-2003 10:15 PM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
I wouldnt trust our DBA's or even our junior admins with raw - too easy to make a mistake, think a volume is free when it isnt, and accidentally blast it. Ive seen it happen too many times...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 11:19 PM
тАО10-15-2003 11:19 PM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
I'll have my dba look at the thread later today.
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
тАО10-16-2003 12:32 AM
тАО10-16-2003 12:32 AM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
If using raw/io, I've found that in all cases, do it for datafiles and indices but leave the archive and redo logs as cooked files.
By the way, there is a way to have your cake and eat it too and that is to use the OnlinewJFS options convosync=direct,mincache=direct,nodatainlog mount options. These have the effect of completely bypassing the buffer cache and the performance is all but indistinguishable from true raw i/o. You can then easily test the difference simply by changing the mount options and restarting Oracle.
NOTE: None of this applies to Oracle RAC. Although there is a Veritas filesystem designed to work across hosts I would never fully trust it and would only use raw/io.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 12:40 AM
тАО10-16-2003 12:40 AM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
to gain a bit of performance one really needs to know where to place the files on the raw devices. otherwise it might happen to overload such a devices. talk about io contention.
usually the peformance gain by tuning the application programm is more significant than any hardware tuning. somewhere on oracle's website they have a list on how to get better performance. hardware tuning (filesystems vs. raw devices) is #10.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 12:44 AM
тАО10-16-2003 12:44 AM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
I don't have much to offer here apart from marvelling at Mr A Clay again except to say that our DBA's run all these version of oracle and very much insist we go the cooked route.
8.1.7 8.1.7.4 9.0.1.4 9.2.0.2.0 9.2.0.4.0
8.1.7.3 9.0.1 9.2.0.1.0 9.2.0.3.
Again, I believe it's mostly for administration purposes, we really like to be sure that we can determine what a disk is being used for by referencing LVM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 01:02 AM
тАО10-16-2003 01:02 AM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
If you are interested in Oracle performance you sould perhaps have a look at Veritas Database Edition for Oracle.
http://www.veritas.com/products/category/ProductDetail.jhtml?productId=oracleedition
From the product description:
"VERITAS Database Edition includes a unique database accelerator that delivers raw device speed with the administrative ease of traditional file systems."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 01:05 AM
тАО10-16-2003 01:05 AM
Re: Oracle 9i Rel2(9.0.2.0.1) raw disk or filesystem.
Sometimes it is useful to copy datafiles for cloning/test/do some kind of experiments; easier than copying logical volumes (we haven't big databases - 10 or 20 GB).
Ciao
Claudio