Re: Oracle and striping

Jean Marc,

Much opinion different about stripping but I think it's a good way to avoid hot spot and disk bottleneck.
It's useful to balance IO between all your hard disk drive. Especially software or hardware stripping if your application have a great number of tables with mixed activity TP, BATCH and decisional. You can have software stripping (with a logical volume manager for example), hardware stripping (with special disk controller) or manual stripping. Manual stripping is possible if you know exactly the activity of a small quantity of tables and their indexes.
For that, with Oracle 7, create a tablespace for the table you want to strippe. Build this tablespace with as many datafiles than you have physical hard disk. Place each file on its own physical hard disk. Create your table as many extents than you have datafiles. The size of each extents is equal (or a little less because a datafile header) of the size of datafiles. The principle, for example, if you have 4 hard disk :

Create tablespace TBS1

    datafile

        'hd1/df1' size 1000 K,
        'hd2/df2' size 1000 K,
        'hd3/df3' size 1000 K,
        'hd4/df4' size 1000 K;

Create table TBL1
storage (

    initial 999 K
    next 999 K
   minextents 4);

Good luck

Jean-Marc Pouchoulon a écrit dans le message <7mffpu$i3f_at_magnum.lirmm.fr>...
>Hello
>Is stripping disks is a good idea to improve perf for an Oracle Database ?
>and why ? Does someone do that ?
>
>Thanks in advance
>
>
>
Received on Tue Jul 13 1999 - 10:15:41 CDT