Hi People,

IS there still the need to use this other than to spread the I/O over several disks?? We use an EMC SAN and have RAID 1+0 for the disks. In effect, we know the I/O is somehow spread. However, I also have a schema whose objects are created in the USERS tablespace. I would want to know the side effects of this other than Constant fragmentation, ease of administration and spread of I/O which is taken care of from the SAN cache reads and writes.

Is there any other reason why we should have the separate tablespaces??

Thanks,

Erica

Oracle LazyDBA home page