Partitions by hash use One or Multi ablespace on ASM
Hi,
We are using the 32 Tablespaces for 32 Partitions Partitions by hash on the ASM. My Questions is :-
1) For having this multi table-spaces for each partitions in a on a ASM Will this increase performace ?
2) OR Will it be not any effect on any performance if we were having all partitions went to one tablesapce on the ASM .
So Question is :- Is it better to have one tablespace for for each PArtitions or have Multi tablespace for each partitions on a ASM. when partitions by hash.
Regards
Sahil Soni
0