Re: Clarification from your Paper "Implementing RAID in Oracle Systems"

thin-wide

RAID 0 volume, 8 drives wide, 8K deep. (2 of these mirrored uses 16 drives) Stripe depth = 64K - for a multi_block_read_count = 8, db_block_size= 8192 - a FTS will grab 1 block off of each member in the stripe at a time.

thick-narrow

RAID 1 volume, 2 drives, stripe depth 64K, a FTS will grab 8 blocks off of 1 drive at a time.

The idea is, deeper, wider tends to improve throughput for fewer jobs.
(SAME)

Thicker, more narrow, tends to allow for more distinct files on dedicated volumes (OFA)

The classic tradeoff of (bulk) throughput vs. concurrency (few batch jobs vs. numerous concurrent users).

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 05, 2001 12:55 AM

EXCERPT :-
"A scientific comparison needs to be made to determine whether it is better to create fewer volumes with "thin-wide stripes" or more volumes with relatively "thicker-narrower" stripes. This is dependent on issues such as data/index partitioning, required support parallelism for core operations and any service-level agreements on high or partial availability. While thin-wide stripes are a very attractive solution, the constraining factors of parallelism, availability and data/index partitioning, make it not that appealing. My goal is to meet somewhere halfway between thin-wide stripes and thick-narrow stripes ."

What do you mean by "thin-wide stripes" & "thicker-narrower" stripes ?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infy.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).