Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

single or multiple data files for a tablespace

ora_learner36Jan 14 2019 — edited Jan 23 2019

Hi All,

Hope all are doing well.

Which one would be better --for a tablespace of size 5 GB, one single data file of size 5 GB or 5 data files of each size 1 GB?

Your help will be appreciated, thanks in advance?

regards.

ebs:12.1.3

db:11.2.0.3

os:rhel 6

Added on Jan 14 2019

#general-database-discussions

22 comments

3,300 views