One big Datafile or several smaller datafiles?
Hello @ all.
I already googled for that question, but I'm not satisfied with the answers for 100%.
If I have a tablespace with 4 datafiles and if I import one table, so Oracle will fill all 4 datafiles with the data of the table.
Now lets assume:
Theres a raid formatted san volume.
1. There will be a full table scan, the datafiles are all together on one physical SAN volume
a) are there now 4 io processes, for each datafile one io process and they read the information parallel?
b) or is it one io process which has to read the data seriell from all datafiles
If I have a tablespace with 4 datafiles and if I import one table, so Oracle will fill all 4 datafiles with the data of the table.
Now lets assume:
Theres a raid formatted san volume.
1. There will be a full table scan, the datafiles are all together on one physical SAN volume
a) are there now 4 io processes, for each datafile one io process and they read the information parallel?
b) or is it one io process which has to read the data seriell from all datafiles
0