From: Armin Ollig <ollig@biofrontera.de>
Subject: Raid and size of datafile(s)
Date: 2000/05/05
Message-ID: <39129F68.870D022D@biofrontera.de>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@ndh.net
X-Trace: passat.ndh.net 957521793 18433 195.227.2.162 (5 May 2000 10:16:33 GMT)
Organization: Biofrontera Pharmaceuticals GmbH
Mime-Version: 1.0
NNTP-Posting-Date: 5 May 2000 10:16:33 GMT
Newsgroups: comp.databases.oracle.server


Dear colleagues,

            i plan to stripe my oracle instance across 4 raid0+1 slices.
            However i dont find any usefull information about the
            layout of the datafiles. Since my oracle and OS are 64bit i
            dont have a 2GB limit. Hence imho it would be a good thing
            to have about 4 very big datafiles on each raid instead of
            e.g. 20 2GB files since oracle accesses all datafiles in
            parallel and having 20 io threads on one raid will certainly
            not impove perfomance.

            What is the appropriate method to optimze the number
            and size of datafiles in order to get the best performance
            ?

            Thanks in advance,
            --Armin 

--
"To save energy
    the light at the end of the tunnel
         will temporarily be switched off."