RE: Storage array advice anyone?

  • From: "Johnson, George" <GJohnson@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 17 Dec 2004 16:14:07 -0000

        Some "whitepapers" were mentioned in this very long thread. Does
anyone have a few reliable/trusted sites where I could get some reading
material, about this topic?

        Thanks in adv

-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx] 
Sent: 17 Dec 2004 15:34
To: oracle-l@xxxxxxxxxxxxx
Cc: Hameed, Amir
Subject: Re: Storage array advice anyone?

No. But I am implying that you think very carefully
about the amount of data that you read/write to a
single disk before you move on to the next disk.

(There are many different terms for this, which is
why I chose to describe the mechanics rather than
give it a name).

Some people set their systems to 32K per disc 
at the SAN, then get Oracle to do 1MB direct
reads and wonder why things don't work well.

It seems that many suppliers can't go higher than 
1MB per disc (at least, whenever I've been on 
site asking what the maximum is, I've invariably
been told that it's 1MB). This means a typical
1MB read will activate two discs - but since many
S/As then decide to put a filesystem stripe on top
of the SAN stripe, who knows what else can go


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Optimising Oracle Seminar - schedule updated Sept 19th

----- Original Message ----- 
From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Sent: Friday, December 17, 2004 1:37 PM
Subject: RE: Storage array advice anyone?

Hi Jonathan,
Are you suggesting that there is no benefit in having a larger stripe width
in comparison to a smaller one, for example, 8-way versus 4-way ?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jonathan Lewis
Sent: Friday, December 17, 2004 4:23 AM
To: Oracle-L
Subject: Re: Storage array advice anyone?


Sorry to come in so late on this one - I've
had a busy three months, and only just got
back to reading the mail.

Personally I find the whole 'virtualization' thing a 
complete con-trick. 

Sure, I now have a LUN which is really 50 
different spindles - so what good is that if I 
send a 'single read request' and that activates
eight of them.   It only takes 8 requests like
that and there are 64 reads queued up somewhere,
and who knows where they might be ?  Ask 
Cary Millsap about queueing and unstable
response times.  (Then ask Stephen Barr what
the minimum and maximum response times were
for his Parallel Query problem).


This message contains confidential information and is intended only 
for the individual or entity named.  If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.  
Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses.  The sender therefore does not
accept liability for any errors or omissions in the contents of this 
message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.
This message is provided for informational purposes and should not
be construed as an invitation or offer to buy or sell any securities or
related financial instruments.
GAM operates in many jurisdictions and is 
regulated or licensed in those jurisdictions as required.


Other related posts: