Forum Stats

  • 3,854,989 Users
  • 2,264,447 Discussions


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

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.

  1. What should be the best approach in adding space to a tablespace ? Resizing the existing datafiles to its extent or adding uneven dastafiles ?
  2. What will be pro's and con's ?
  3. If extending the datafiles is appropriate. How it will degrade the database performance ?