New answers tagged tablespaces
Indexes "grow" differently than tables, also when you rebuild them (for various reasons) your tablespace can get easily fragmented. It's always good idea to keep these separately. Also when usign uniform extent allocation you have no other option that to have at least to tablespaces for small tables (reference, enumerations, LOVs) and targe tables.
Minimal performance benefit, the only benefit in this regard is from reduced fragmentation. But Oracle and most filesystems handle this much better these days than in the past; Oracle handles this better with "automatic segment space management" and the Oracle "filesystem" ASM, though you don't need to use the latter. It's more a manageability choice these ...
Top 50 recent answers are included