Oracle-L: Re: partitioning in an NAS or SAN environment

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Thu, 06 Nov 2003 12:39:26 -0800
Message-ID: <F001.005D5DAE.20031106123926@fatcity.com>

At the site of one of my customers, in a not too big (100GB) database environment, using NAS over NFS on RS/6000 with AIX gave us far from enough throughput. It turned out that much more mountpoints (20 i.s.o. 2) were necessary to get a more-or-less satisfactory throughput.

At 10:54 6-11-03 -0800, you wrote:
>most of the oracle docs state that when you partition a table you will get
>the most performance benefits by splitting the datafiles for each
>partition onto seperate storage devices.
>
>Im on an NAS and all I see are logical mount points. What are your
>recommendations for this?

DBA!ert, Independent Oracle Consultancy
Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands

tel.    +31 (0) 182 640 428
fax     +31 (0) 182 640 429
mobile  +31 (0) 653 911 950

e-mail info.dbalert_at_xs4all.nl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Nov 06 2003 - 14:39:26 CST