Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> datafiles vs. logical volumes for disk striping
For some time now I've wondered about whether disk striping could be better achieved with datafiles only instead of the traditional combination of both datafiles and logical volumes. Is it true that distribution across multiple disks can be more accurratly done with datafiles only? Of course I realize that to do so would probably require alot more work on the part of the DBA (he/she would have to size each object then perhaps define individual tablespaces sized in such a way so that the table is evenly distributed across all datafiles, perhaps the Oracle max datafile restriction might come into play) thus making it impractical.
Also is it always a good policy to stripe all objects (except perhaps the smallest tables which can be read in with one disk access) across all disks? Under what circumstances would this not be a good policy? Received on Mon Apr 21 1997 - 00:00:00 CDT
![]() |
![]() |