Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it better to increase the Oracle datafile size or add another datafile to increase the Oracle tablespace size?

April 26, 2017datafile increase Oracle size tablespace

0

Posted

Is it better to increase the Oracle datafile size or add another datafile to increase the Oracle tablespace size?

1 Answer

0

Posted

Some DBA’s choose to add datafiles instead of using autoextend for the tablespace. The choice of adding datafiles depends on your RAID level and how many disk spindles you have. Mike Ault has an eBook dedicate to Oracle space management, and his book “Oracle Disk I/O Tuning” is superb.