Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Network Appliance Options

Re[2]: Network Appliance Options

From: Robert Eskridge <>
Date: Tue, 25 Sep 2001 09:47:19 -0700
Message-ID: <>

That's why you use multiple connections (switched or direct with crossover cables) and balance them. That way you change your mount points to isolate certain types of traffic or limit saturation.

We have 3 mount points for a NetApp, each on a different 100BaseT named like /mnt_n1e0, /mnt_n1e1, etc. Datafiles are separated into an OFA like directory structure that isolates certain types of behavior. For example, large indexes for database TEST might be in the directory /u09/oradata/TEST. We use symbolic links at this level, like:

ln -s /mnt_n1e1/home/u09/oradata/TEST /u09/oradata/TEST

If we wanted to isolate that to a different ethernet link, we shutdown the database and

rm /u09/oradata/TEST
ln -s /mnt_n1e2/home/u09/oradata/TEST /u09/oradata/TEST

And start the database. In a few seconds we've "moved" the datafiles in that directory to a different NFS link without Oracle even knowing it.

There are plenty of games to play if you stocked your equipment with plenty of ethernet ports.

(One word of warning, on some of the quad ethernet cards on the Sun,
I'm told that the overall throughput is far less than 4x a solo card. Be sure and check that out...)


D> Kathy - We have used them for supplemental storage on our test/development
D> system (Compaq Tru64, Oracle 8.1.6). The limitation seems to be the NFS
D> connection is slower than your "conventional" or "real" disks. For some
D> tasks this isn't a problem, but it is easy to start several large tasks that
D> saturate the NFS connection. For example, when I have to build several large
D> indexes, I copy the underlying tables to the "real" disk, and build the
D> indexes one at a time. I won't deny that I may be overreacting to some
D> problems. Other than that, it seems to work fine for our test/development
D> system where it generally receives sporadic and light use. I am told that it
D> cost much less than conventional disks. 

Please see the official ORACLE-L FAQ:
Author: Robert Eskridge

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: (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 Tue Sep 25 2001 - 11:47:19 CDT

Original text of this message