Skip to Main Content

What is efficient way in handling the tablespace extension - Datafile resize or adding new datafile?

Nikhil KotakJul 31 2022

A datafile can be resize till 31G or 62G (Based on blocksize).
If a tablespace has hunderds of datafiles with inconsistent size, and tablespace is getting occupied. The requirement is to extend a tablespace.
What should be the best approach in adding space to a tablespace ? Resizing the existing datafiles to its extent or adding uneven dastafiles ?
What will be pro's and con's ?
If extending the datafiles is appropriate. How it will degrade the database performance ?

Post Details