Re: Parallel Query and disk striping

According to Oracle, they recommend to use RAID or OS disk striping instead of manually striping the tablespace. According to them, unless you are doing a lot of full table scan, you should not use manual striping at all (of course, if you have a choice to use RAID or other kind of striping)

Winnie Liu

Lisa Lewis wrote in message <6o04np$d3e$1_at_usenet01.srv.cis.pitt.edu>...
>Can anyone tell me the considerations for physical layout with the
intention
>of using the parallel query option. I understand that in any good db
>design, tablespaces should be spread across multiple disks. When using
>parallel query, does it matter if you use OS disk striping, RAID
>technologies or manual striping of tablespaces ( via creating TS from
>multiple datafiles on separate disks). Any suggestions/experiences will be
>greatly appreciated. If you use OS disk striping or raid technologies, I
>assume you would want to always have more than one stripe set ( one for
>indexes, one for tablespaces ) in addition to some disks that are not
>striped for redo's, rollbacks, etc. ???
>
>Thanks
>Lisa
>
>
Received on Wed Jul 08 1998 - 23:33:49 CDT