Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Raw I/O

Re: Raw I/O

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 17 Jan 2002 07:36:57 -0800
Message-ID: <F001.003F2AC8.20020117072532@fatcity.com>

Tuning apps and SQL will nearly always yield a much bigger performance gain than using raw filesystems rather than cooked.

It's not too unusual to find a very few pieces of code or SQL in an app that can provide dramatic improvements.

Even with 3rd party apps there are often opportunities for improving data access via indexes and partitioning.

Jared

On Thursday 17 January 2002 06:50, Ron Rogers wrote:
> I have been searching for the same answers for a long time and have
> downloaded a lot of papers on the "raw vs cooked" and to get definitive
> answers is a complicated task. Simple methods and opinions and examples
> will go a long way in the understanding of a controversial and
> complicated subject. Yes, I know that it is faster, more complicated, a
> bear to administer but the answer is "it is used today in quite a few
> shops". More informative answers would be appreciated and would help in
> the decision process of "should we or shouldn't we use raw devices" and
> what are the pitfalls and advantages if we do. A guide ,reference, or
> link to help in the decisions would be a blessing.
> ROR mª¿ªm

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 17 2002 - 09:36:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US